PowerPivot - COM exception while opening...even though I was closing

Question

I am running Office 365 ProPlus 16.0.6001.1038 (64 bit) on Win 10 Pro (64 bit).  I recently upgraded from Office 365 ProPlus 2013 (32 bit) in order to handle larger data sets in PowerPivot data models.

After upgrading several of my files and data models, I was able to open the data models in PowerPivot, refresh data and manipulate my pivot tables and charts.  However, when I would click to save or exit  the file without saving I would get the following message:

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

Details:  

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

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)

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

I have tried the Quick Repair, Full Repair, Uninstall & Reinstall but still get the same results.  Once the issue does happen, if I do not close the file and go into PowerPivot, all of my data models are gone and PP is blank.  Unfortunately I did not realize this the first couple of times and saved my files only to find the data models gone on reopening and only static pivot tables/charts remaining.  My backup files are currently worthless because I can't save them after refreshing without the data models being erased.

I thought it might be related to older files that I upgraded the data models.  However, I created brand new files with new data models only to have the same issue occur.

Please advise as I need to refresh my models and populate dashboards!

Thanks,

RL

Answer 1

Hello,

Welcome to Microsoft Community and thank you for posting your query.

Since you are using Power Pivot, you may also post this in the following TechNet forum for better suggestions. 

http://social.technet.microsoft.com/Forums/en/excel/threads 

Please feel free to reply in case you face any other issues with Office in future.

Thank you.