Forum Discussion
Marc Rommel
Sep 26, 2017Copper Contributor
PowerPivot for Excel 2013 - unhandle exception error - unable to cast COM object
Getting following error message when creating formulas / measures in PowerPivot. Any help would be greatly appreciated. See the end of this message for details on invoking just-in-time (JIT) deb...
Alun Davies
Sep 26, 2017Brass Contributor
Can we have a simplified example that causes the error
take a copy as a test and start simplifying it until the error goes away
either
the error never goes away
you find what was causing the issue can you simplify something else
I am expecting a /0 type issue at the root.
take a copy as a test and start simplifying it until the error goes away
either
the error never goes away
you find what was causing the issue can you simplify something else
I am expecting a /0 type issue at the root.
- Marc RommelSep 27, 2017Copper Contributor
Thanks for your reply! no issues when adding data to the model, creating hierarchies, etc. .. error only comes up when trying to enter/edit formulas. Then you can click continue several time to make it disappear, however previously created pivot tables can't be updated anymore.
what do you mean with /0 type issue?
- SergeiBaklanSep 27, 2017Diamond Contributor
Hi Marc,
Perhaps .NET Framework 4.5 is missed and/or you have different versions of the Office installed side-by-side (for such case silution is here https://www.inflectra.com/support/knowledgebase/kb180.aspx).
I'd try to repair/update Office installations as well as add-ins.