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:
Element not found. (Exception from HRESULT: 0x8002802B (TYPE_E_ELEMENTNOTFOUND))
at Microsoft.Office.PowerPivot.ExcelAddIn.INativeEntryPoint.BeginUpgradeASPPModel(String workbookName)
at Microsoft.Office.PowerPivot.ExcelAddIn.InProcServer.LoadSandboxAfterConnection(String errorCache)
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.