Sorry, Power Pivot can't open the Data Model because there was a COM exception while opening, You might be opening a workbook on a corrupt installation of Excel. Click Details for more information.

Question

Hello

I am working with multiple excel files that have data loaded in Data Model. I often get the error below when I open or close the file and then I cannot access the data model in that file anymore, there's a message that says that the data model does not exist. This happens frequently with all files I used. I tried reinstalling the Excel and clearing the temp file but it does not make any difference.

I use Microsoft Office Professional Plus 2016.

Sorry, Power Pivot can't open the Data Model because there was a COM exception while opening, You might be opening a workbook on a corrupt installation of Excel. Click Details for more information.

============================

Error Message:

============================

Object reference not set to an instance of an object.

============================

Call Stack:

============================

at Microsoft.AnalysisServices.BackEnd.DataModelingSandbox.HandleRegionalSettingsChange()

at Microsoft.Office.PowerPivot.ExcelAddIn.InProcServer.LoadSandboxAfterConnection(String errorCache)

at Microsoft.Office.PowerPivot.ExcelAddIn.InProcServer.LoadSafeSandboxAfterConnection(String errorCache)

at Microsoft.Office.PowerPivot.ExcelAddIn.InProcServer.LoadOLEDBConnection(Boolean raiseCompleteEvent, String errorCache)

Answer 1

Hi @Alina alina ，

First please try to repair .net in your computer.

Then please try this method and check the result:

Start Excel in Safe Mode ( run: excel \safemode)
Alt - F11 (opens VBA editor)
Tools > references
Un-checked the following:
OLE Automation
Microsoft Office 15.0 Object Library
'Save As'
Re-open workbook normal
Any updates please let me know, and I'm glad to help you.

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.