Excel Error Codes

Fix Power Pivot Data Model COM Exception in Excel

Aamir Naveed AkramAamir Naveed Akram Nov 20, 2026 869 views

Question details

The user needs to open an Excel data model after a Power Pivot COM or assembly exception.

Fix a Power Pivot Data Model COM Exception in Excel
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.
Before you start

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.

Solution 1Recommended

Update Office and restart Windows

Install available Office updates to address outdated or inconsistent Excel and Power Pivot components.

1
Open update settings

In Excel, select File > Account, then look for Update Options under Product Information.

2
Install updates

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.

3
Restart and test

Restart Windows, reopen Excel, and open the affected workbook. Try opening its data model again.

Update Office and restart Windows
Free Microsoft Office alternative

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.

Open and edit everyday spreadsheets in a familiar interfaceCompatible with common Microsoft Excel formats, including XLSX and XLSUse a free, lightweight office suiteMove common spreadsheet tasks from Excel with minimal adjustment
microsoft office alternative - wps office

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.