PowerPivot for Excel 2013 errors after October update KB 2825655
(Updated Dec 2013)
After installing the October 2013 update (KB 2825655) for Excel 2013, PowerPivot is unable to be used.
Examples of errors you will receive when trying to work within existing PowerPivot workbooks or launching the PowerPivot Window to create a new one are below.
ERRORS:
"We couldn't get data from the Data Model. Here's the error message we got: Invalid pointer array"
"PowerPivot is unable to load the Data Model"
At this time, the only resolution to this issue is to uninstall update KB 2825655 https://support.microsoft.com/kb/2825655/EN-US
Microsoft is working on a resolution. Watch the blog for updates on when a fix is available for this issue.
*** UPDATE : Hotfix Available ***
To resolve this issue, you can request a hotfix from the link below.
https://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2837666\&kbln=en-us
Comments
- Anonymous
January 01, 2003
Still valid to use the fix from MS, http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2837666&kbln=en-us, as I was experiencing same issue on my 2013 installation - Anonymous
January 01, 2003
Uninstalling KB 2752087 fixed the problem for me. Thanks @John. - Anonymous
January 01, 2003
I get this when I try to use Powerpivot in Excel 2013 -
"We couldn't get data from the Data Model. Here's the error message we got:
The type initializer for 'Microsoft.Analysis.Services.XmlaClient' threw an exception.
Configuration system failed to initialize.
Root element is missing. (CWindowsMicrosoft.NETFrameworkv4.0.30319configmachineconfig)
Root element is missing."
When I close this error another appears with a details button, when clicked shows:
============================
Error Message:
============================
Object reference not set to an instance of an object.
============================
Call Stack:
============================
at Microsoft.Office.PowerPivot.ExcelAddIn.InProcServer.CannotUpgrade(GeminiWorkbook geminiWb, WorkbookConnection wbConn, String& message)
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
Nobody seems to know how to fix this or shed any light on it - Anonymous
January 01, 2003
thanks - Anonymous
April 10, 2014
The comment has been removed - Anonymous
April 10, 2014
Bjarni - I had the same problem today. Did you by chance install the most recent windows update? It seems like that is the problem. I used system restore to go back before installing the update and I am able to use PowerPivot again. - Anonymous
April 10, 2014
Had the same problem unistalled update KB 2752087 and PowerPivot is working - Anonymous
April 10, 2014
I had the same problem this afternoon and solved it a few minutes ago by installing the latest windows update (from today). - Anonymous
April 11, 2014
The comment has been removed - Anonymous
April 11, 2014
Same problem. I uninstalled KB 2752087 but the problem is not fixed. - Anonymous
April 13, 2014
I have requested this hotfix but then the link given to me returns
"The resource you are looking for has been removed, had its name changed, or is temporarily unavailable." - Anonymous
April 14, 2014
The comment has been removed - Anonymous
June 25, 2014
In excel 2010 while ia m creating power pivot chart i am getting error which is shown below
"The command was canceled.Please press F1 to get help on topic "Excel Window:Power pivot Field list" for more details.
When i am clicking on pivot chart the above error is pooping up but i am able to create pivot table.
Could anyone please help me on this. - Anonymous
August 23, 2014
these errors are unbelievable! what's wrong with excel! please post if someone finds a solution.
--- Byron Injeeli