Pivot Table Issues

Fix an Excel Power Pivot Data Model That Disappears After Closing

Olivia MillerOlivia Miller Nov 18, 2026 870 views

Question details

The user needs to recover or rebuild an Excel Power Pivot Data Model that disappears after the workbook is closed.

Fix an Excel Power Pivot Data Model That Disappears After Closing
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the Data Model

In Excel, select the Power Pivot tab and click Manage. Check whether the Power Pivot window opens and shows the expected tables.

2
Check the relationships

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.

3
Check the add-in

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.

4
Recheck before saving

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.

Check Power Pivot for an add-in error before closing Excel
If the model is already missing: Restarting or re-enabling the add-in may not recover a lost model. Restore an earlier workbook version or rebuild the model if no intact version is available.
Free Microsoft Office alternative

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.

Open and edit compatible Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface for everyday workbook tasksCreate standard PivotTable reports from supported spreadsheet dataMove compatible files into a lightweight office suite
microsoft office alternative - wps office

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.