Fix an Excel Power Pivot Data Model That Disappears After Closing
Question details
The user needs to recover or rebuild an Excel Power Pivot Data Model that disappears after the workbook is closed.

- Product
- Microsoft Excel Power Pivot
- Device & OS
- not provided
- Scenario
- A workbook uses Power Query and a Power Pivot Data Model to maintain relationships and PivotTable reports.
- Observed behavior
- Queries remain visible, but the Data Model, relationships, connections, and PivotTable reports may be missing. Power Pivot may also report a COM exception when opening the model.
Check whether the workbook is still open and whether Power Pivot can open its Data Model. If the model is already missing, look for an earlier version of the workbook before rebuilding it; avoid overwriting a known-good version.
Check Power Pivot for an add-in error before closing Excel
Use this check while the workbook is open to identify a Power Pivot failure before saving or closing.
In Excel, select the Power Pivot tab and click Manage. Check whether the Power Pivot window opens and shows the expected tables.
In the Power Pivot window, open Diagram View and confirm that the expected tables and relationships are present. If an error dialog or COM exception appears instead, the add-in may have failed.
In Excel, go to File > Options > Add-ins. Select COM Add-ins in the Manage list and click Go. Check that Microsoft Power Pivot for Excel is enabled; if it is unresponsive, try clearing the checkbox and enabling it again.
Open Power Pivot > Manage again. If the model and relationships are intact, use File > Save As to save a separate copy. If they are missing or the error persists, avoid overwriting the original and look for an earlier version.

Restore an earlier version of the Excel workbook
Use an earlier version if the current workbook no longer contains the Data Model.
Rebuild the Data Model from the remaining Power Query queries
Use this approach when no intact workbook version is available but the source queries remain.
Work with spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for everyday spreadsheet work and migration of compatible files. It does not repair Excel Power Pivot COM errors or replace an Excel Data Model.

Frequently Asked Questions
Why are my queries still visible when the Data Model is gone?
Power Query queries and the Data Model are separate workbook components. Check Data > Queries & Connections for the queries, and use Power Pivot > Manage to check whether the model and its relationships remain.
What does a Power Pivot COM exception mean?
It indicates that Power Pivot encountered an error while opening the Data Model. Check the add-in under File > Options > Add-ins > COM Add-ins, then try opening Power Pivot > Manage again. Re-enabling the add-in does not guarantee recovery of a missing model.
Can I recover a Data Model after saving the workbook without it?
Recovery is not guaranteed. If the file is stored in OneDrive or SharePoint, check File > Info > Version History for an earlier version containing the model. Otherwise, look for another intact copy or rebuild the model.
How do I add an existing query back to the Data Model?
Open the query from Data > Queries & Connections, then use Home > Close & Load To in Power Query Editor and select Add this data to the Data Model. You may also need to recreate relationships and reports.




