Fix an Excel Power Pivot Data Model That Disappears After Reopening
Question details
The user needs to restore access to an Excel workbook's Power Pivot data model and make its PivotTable interactive again after reopening.
- Product
- Microsoft Excel with Power Pivot
- Device & OS
- not provided
- Scenario
- A workbook containing a data-model-based PivotTable is saved, closed, and reopened.
- Observed behavior
- The PivotTable still displays values, but it is no longer interactive, and the Manage Data Model button does not respond.
Check the workbook's file extension and record your Excel edition, version, and bitness under File > Account > About Excel, where available. Use desktop Excel for these checks; Power Pivot management requires a supported Excel edition on Windows.
Check whether the workbook format supports the data model
Start here if the workbook was converted to an older Excel format or saved through another application.
Visible PivotTable values do not prove that the underlying data model is still available. Cached results can remain visible even when Excel cannot access the model.
In Excel, open File > Save As and check the selected file type. Use Excel Workbook (*.xlsx) or Excel Macro-Enabled Workbook (*.xlsm), rather than Excel 97–2003 Workbook (*.xls) or CSV.
If the workbook is in an unsupported format, choose .xlsx, or .xlsm if it contains macros, and save it under a new name. If you have an original workbook saved before conversion, open that version instead.
Close the saved workbook, reopen it in desktop Excel, and select Data > Manage Data Model or Power Pivot > Manage. Click the PivotTable and check whether its field list and filtering controls work.
Confirm that your Excel edition includes Power Pivot
Use this check when Manage Data Model is unresponsive or the Power Pivot tab is missing.
Update or repair Excel and test a current 64-bit installation
Use this approach when the workbook format and Power Pivot availability are correct but the model still will not open.
Use WPS Spreadsheet for Everyday Workbook and PivotTable Tasks
WPS Office is a free, lightweight alternative with a familiar interface and Microsoft Office format compatibility for an easy transition to everyday spreadsheet work. Use WPS Spreadsheet for standard PivotTable analysis, but keep Power Pivot-dependent workbooks in supported Microsoft Excel: WPS is not a repair tool for Excel data models.
Frequently Asked Questions
Why can I still see PivotTable values if the data model is unavailable?
Excel can retain cached PivotTable results in the workbook. Those displayed values do not confirm that the model is accessible. Select Power Pivot > Manage or Data > Manage Data Model to check whether Excel can open it.
Will saving the workbook as .xlsx bring the missing model back?
Not if the model was already removed. File > Save As > Excel Workbook (*.xlsx) uses a format that supports the data model, but recovery requires an earlier intact workbook or rebuilding the model from the source data.
Where do I enable Power Pivot in Excel?
In a supported Windows desktop edition, go to File > Options > Add-ins, select COM Add-ins, and click Go. Check Microsoft Power Pivot for Excel and click OK. If it is not listed, check whether your installed edition includes Power Pivot.
Should I switch to 64-bit Excel to fix this?
Testing in current 64-bit Excel with Power Pivot support can help identify installation or resource-related issues, especially with larger models. Check your current bitness under File > Account > About Excel. Switching does not guarantee recovery of a missing or damaged model.
Can WPS Office restore an Excel Power Pivot data model?
No. Use supported Microsoft Excel to diagnose and manage Power Pivot models. WPS Spreadsheet is an alternative for standard workbook editing and worksheet-based PivotTable tasks, not a way to repair or manage Excel Power Pivot data models.
