Updating pivot tables with new data

04-Sep-2015 21:37

Read the following sections in this article to learn more.

Outdated and orphaned tables are not upgraded with the rest of the model, resulting in data deletion or unusable data.

“Upgrade has been unable to upgrade the following linked tables If you already saved the workbook, you cannot roll it back a previous version.

You will need to recreate the linked table from scratch.

In some cases, you’ll need to make manual changes to the workbook or data model to fully upgrade to Excel 2013 or Excel 2016.

More about: Add worksheet data to a Data Model using a linked table.

Top of Page In previous versions, a Pivot Table Field List displayed column or field descriptions as Tooltips.

Workbook Data Models that have restrictions on print, edit, or copy will fail upgrade with this error: “Unable to upgrade the Data Model in this workbook.” To work around this problem, remove the restrictions prior to upgrading.

You created a workbook in Excel 2010 with a connection to an external data source. When you try to change a Pivot Table in the workbook, you see a message that you must update the Pivot Table.

In some cases, you’ll need to make manual changes to the workbook or data model to fully upgrade to Excel 2013 or Excel 2016.

More about: Add worksheet data to a Data Model using a linked table.

Top of Page In previous versions, a Pivot Table Field List displayed column or field descriptions as Tooltips.

Workbook Data Models that have restrictions on print, edit, or copy will fail upgrade with this error: “Unable to upgrade the Data Model in this workbook.” To work around this problem, remove the restrictions prior to upgrading.

You created a workbook in Excel 2010 with a connection to an external data source. When you try to change a Pivot Table in the workbook, you see a message that you must update the Pivot Table.

Please refresh or recalculate the model.” If you get this error (and you may get it several times), be sure to note which tables and columns are indicated so that you can go directly to those tables.