File Cannot Open

Fix Excel Power Pivot Unable to Load the Data Model

John WilsonJohn Wilson Nov 20, 2026 869 views

Question details

The user needs to open an Excel workbook whose Data Model cannot be loaded by Power Pivot.

Fix Excel Power Pivot Unable to Load the Data Model
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.
Before you start

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.

Solution 1Recommended

Restart the computer and reopen the workbook

Use this first to check whether restarting clears the Data Model loading issue.

1
Close Excel

Close all open Excel windows and any other Office applications.

2
Restart the computer

Use your operating system's Restart command, then sign in again.

3
Open the workbook

Open Excel and select File > Open to try the affected workbook again.

Restart the computer and reopen the workbook
Free Microsoft Office alternative

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.

Open and edit compatible Excel workbooks, including XLSX filesUse a familiar spreadsheet interface for everyday workbook tasksWork with common Microsoft Word, Excel, and PowerPoint formatsUse a lightweight Office alternative for files that do not depend on Power Pivot
microsoft office alternative - wps office

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.