Updating report model

by  |  11-Jan-2020 05:26

You try to update it, but you see this message: "Excel was unable to get necessary information about this cube.

In this section, you’ll learn how to respond to specific errors indicating a partial or incomplete upgrade.

The workbook is upgraded but missing certain functionality.

If a workbook contains drillthrough query tables, upgrade will appear to succeed at first, but then returns an upgrade error each time you click on a field in a Pivot Table.

Password protected workbooks that also contain a Data Model will fail upgrade with this error: “Unable to upgrade the Data Model in this workbook.” To work around this problem, remove the password prior to upgrading.

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.

Community Discussion