Fix Excel Power Pivot Unable to Load the Data Model
Question details
The user needs to open an Excel workbook whose Data Model cannot be loaded by Power Pivot.

- Product
- Excel for Microsoft 365 and Power Pivot
- Device & OS
- not provided
- Scenario
- Opening a workbook that contains an Excel Data Model in Excel for Microsoft 365 version 1808.
- Observed behavior
- Excel opens multiple windows and reports that a Data Model issue prevents the workbook from opening. Power Pivot cannot load the model.
Check whether the error affects one workbook or every workbook containing a Data Model. If Excel opens, go to File > Account > About Excel and note the exact Office build for troubleshooting.
Restart the computer and reopen the workbook
Use this first to check whether restarting clears the Data Model loading issue.
Close all open Excel windows and any other Office applications.
Use your operating system's Restart command, then sign in again.
Open Excel and select File > Open to try the affected workbook again.

Run an Online Repair of Microsoft Office
Use Online Repair if restarting does not resolve the error.
Test an earlier copy of the workbook
Use an earlier copy to check whether the issue is limited to the current workbook.
Work with Excel files in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with common Office files and moving between applications. It does not repair Excel's Power Pivot Data Model loading error; check whether your workbook's advanced features are supported before switching.

Frequently Asked Questions
How can I tell whether the problem affects all Data Model workbooks?
In Excel, use File > Open to test another workbook that contains a Data Model. If the file is shared, ask another user to open it as well; this can help distinguish a local issue from a file-specific one.
Where can I find my exact Excel build number?
In Excel, select File > Account > About Excel. Record the version and build shown there when asking for support.
What should I send support if Online Repair does not help?
Provide the exact Office build, a screenshot of the error, whether all Data Model workbooks are affected, when the issue began, and any changes made beforehand.
Does a working earlier copy mean the current Data Model is intact?
Not necessarily. Open the earlier copy and check its PivotTables and Data Model, but treat it as a separate version that may not contain recent changes.
Can WPS Office fix the Excel Power Pivot error?
No. WPS Office is an alternative for compatible Office files, not a repair tool for Excel's Power Pivot Data Model. Check advanced feature compatibility before using it with a Data Model workbook.




