PowerPivot Metadata Restored

Looking for help with Power Pivot in Excel 2013? Go to Power Pivot Help on Office.com.

This dialog box is displayed in the rare situations in which PowerPivot data becomes corrupted. The source data is not affected in this case, but the data in the PowerPivot window (and any PivotTables or PivotCharts that are based on it) can no longer be used. If data is corrupted, provides three options:

  • Do nothing
    Do not change the workbook in any way. You can still work with Excel data in the workbook, but you will get an error message every time you open the workbook.

  • Recover the structure of the PowerPivot data
    Delete the PowerPivot data and recreate the structure (also known as the schema) of each PowerPivot table. The structure that is recreated is based on the version of the workbook that was most recently saved. The recreated structure will not reflect any changes that were saved by AutoRecover.

    Data is not automatically restored. If you want to continue to use a table in your analysis, you must do the following after the table structure is recreated:

  • Delete the PowerPivot data and continue to use the workbook
    Use this option if you no longer need to use the PowerPivot data but want to continue to use the Excel data in the workbook.

Keep the following issues in mind if you plan to restore data:

  • Underlying data sources (such as a remote database server) must be available so that PowerPivot¬†can query them.

  • For security reasons, the metadata extracted from servers will not contain password information. You must specify the password again in order to refresh data. For more information, see Edit the Properties of an Existing Data Source.

See Also


Take a Tour of the PowerPivot UI