PowerPivot error: unable to upgrade the Data Model in this workbook

Upon opening a PowerPivot in Excel 2013 workbook, I get the following message:

unable to upgrade the Data Model in this workbook. The error occurred while upgrading PowerPivot workbook. The data model has reverted to the previous version

The PowerPivot model was created in Excel 2013. The machine is 64-bit and the model was created here and hasn’t been moved.
It was working fine yesterday, and the only real change was the addition of a password in order to secure the file.

The error message in details is here:

============================
Error Message:
============================

Element not found. (Exception from HRESULT: 0x8002802B (TYPE_E_ELEMENTNOTFOUND))

============================
Call Stack:
============================

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

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

Resolution

I resolved this issue by:
running the ‘PowerPivot in Sharepoint 2013 Configuration’.
I also removed the password from the file. To move it around, I will have to use other methods of encrypting the file.  For customer data, I use diskGenie iStorage portable encrypted hard drives and USBs, rather than the plethora of USBs I tend to pick up for free from events.

After running the Wizard and removing the password, I could open up the PowerPivot model just fine.

Hope that helps.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s