Fix Power Pivot Data Model COM Exception in Excel
Question details
The user needs to open an Excel data model after a Power Pivot COM or assembly exception.

- Product
- Microsoft Excel Power Pivot
- Device & OS
- not provided
- Scenario
- Opening a workbook that contains a Power Pivot data model.
- Observed behavior
- Power Pivot reports a Microsoft.AnalysisServices.BackEnd.DataModelingSandboxManager COM or assembly exception, or Excel closes when the workbook is opened.
Check the Excel version and build under File > Account > About Excel. Keep a copy of the complete error message and confirm that your Excel edition supports Power Pivot.
Update Office and restart Windows
Install available Office updates to address outdated or inconsistent Excel and Power Pivot components.
In Excel, select File > Account, then look for Update Options under Product Information.
Select Update Options > Update Now and follow the prompts. If Update Options is unavailable, check with your organization or use the update method for your Office installation.
Restart Windows, reopen Excel, and open the affected workbook. Try opening its data model again.

Repair the Office installation
Use Office repair if Excel still closes or reports the exception after updating.
Check the Power Pivot add-in and Excel compatibility
Verify that Power Pivot is enabled and that the workbook is opened in a supported Excel edition.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Excel formats, making it easy to move everyday workbook tasks between applications. It does not repair Excel Power Pivot or guarantee support for Power Pivot data models.

Frequently Asked Questions
What causes the DataModelingSandboxManager exception in Excel?
The exception can occur when Office or Power Pivot components are outdated or inconsistent. Start by selecting File > Account > Update Options > Update Now in Excel.
How do I enable Power Pivot in Excel?
Go to File > Options > Add-ins, choose COM Add-ins in the Manage list, and select Go. Check Microsoft Power Pivot for Excel if it is listed. Availability depends on your Excel edition.
What should I do if Excel closes without showing another error?
Repair Office through Windows Settings > Apps by selecting your Office installation and choosing Modify. If the problem continues, provide your Office build and a description of the closure in a Microsoft support thread.
Can WPS Office fix the Power Pivot COM exception?
No. The exception belongs to Microsoft Excel and its Power Pivot components. WPS Office can be used for common spreadsheet tasks, but Power Pivot data model support is not guaranteed.




