How to solve this Unhandled exception Error in PowerPivot for Excel?

Hi ,


I have an annoying error showing up in PowerPivot which is not letting me to build any DAX functions in PowerPivot, please help me.

Any time I go to create a formula I get an error " Unhandled exception has occurred in a component in your application.  If you click Continue, the application will ignore this error and attempt to continue. Details below.



----------------------------------------------------------------------------------------------------------
See the end of this message for details on invoking
 just-in-time (JIT) debugging instead of this dialog box.

 ************** Exception Text **************
 System.InvalidCastException: Return argument has an invalid type.
    at System.Runtime.Remoting.Proxies.RealProxy.ValidateReturnArg(Object arg, Type paramType)
    at System.Runtime.Remoting.Proxies.RealProxy.PropagateOutParameters(IMessage msg, Object[] outArgs, Object returnValue)
    at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
    at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
    at Microsoft.Office.Interop.Excel._Application.get_ActiveWorkbook()
    at Microsoft.AnalysisServices.XLHost.Addin.GeminiRibbon.currentClientWindow_InFormulaBarChanged(Object sender, EventArgs e)
    at Microsoft.AnalysisServices.XLHost.Modeler.ClientWindow.OnInFormulaBarChanged()
    at Microsoft.AnalysisServices.XLHost.Modeler.ClientWindow.sandboxEditor_InFormulaBarChanged(Object sender, EventArgs e)
    at Microsoft.AnalysisServices.Common.SandboxEditor.OnInFormulaBarChanged(EventArgs e)
    at Microsoft.AnalysisServices.Common.SandboxEditor.formulaBar_Enter(Object sender, EventArgs e)
    at System.EventHandler.Invoke(Object sender, EventArgs e)
    at System.Windows.Forms.Control.OnEnter(EventArgs e)
    at System.Windows.Forms.Control.NotifyEnter()
    at System.Windows.Forms.ContainerControl.UpdateFocusedControl()


 ************** Loaded Assemblies **************
 mscorlib
     Assembly Version: 4.0.0.0
     Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
     CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
 ----------------------------------------
 Microsoft.VisualStudio.Tools.Office.Runtime.Internal
     Assembly Version: 10.0.0.0
     Win32 Version: 10.0.60301.0
     CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Runtime.Internal/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.Runtime.Internal.dll
 ----------------------------------------
 System
     Assembly Version: 4.0.0.0
     Win32 Version: 4.0.30319.34238 built by: FX452RTMGDR
     CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
 ----------------------------------------
 System.Configuration
     Assembly Version: 4.0.0.0
     Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
     CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
 ----------------------------------------
 System.Xml
     Assembly Version: 4.0.0.0
     Win32 Version: 4.0.30319.34234 built by: FX452RTMGDR
     CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
 ----------------------------------------
 Microsoft.VisualStudio.Tools.Applications.Runtime
     Assembly Version: 10.0.0.0
     Win32 Version: 10.0.60301.0
     CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Runtime/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Runtime.dll
 ----------------------------------------
 System.Core
     Assembly Version: 4.0.0.0
     Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
     CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
 ----------------------------------------
 Microsoft.Office.Tools
     Assembly Version: 10.0.0.0
     Win32 Version: 10.0.60301.0
     CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.Office.Tools/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.dll
 ----------------------------------------
 Microsoft.Office.Tools.Excel.Implementation
     Assembly Version: 10.0.0.0
     Win32 Version: 10.0.60301.0
     CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.Office.Tools.Excel.Implementation/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.Excel.Implementation.dll
 ----------------------------------------
 Microsoft.Office.Tools.Common.Implementation
     Assembly Version: 10.0.0.0
     Win32 Version: 10.0.60301.0
     CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.Office.Tools.Common.Implementation/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.Common.Implementation.dll
 ----------------------------------------
 Microsoft.Office.Tools.Common
     Assembly Version: 10.0.0.0
     Win32 Version: 10.0.60301.0
     CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.Office.Tools.Common/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.Common.dll
 ----------------------------------------
 System.Drawing
     Assembly Version: 4.0.0.0
     Win32 Version: 4.0.30319.34270 built by: FX452RTMGDR
     CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
 ----------------------------------------
 System.Windows.Forms
     Assembly Version: 4.0.0.0
     Win32 Version: 4.0.30319.34251 built by: FX452RTMGDR
     CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
 ----------------------------------------
 Microsoft.AnalysisServices.XLHost.Addin
     Assembly Version: 11.0.0.0
     Win32 Version: 11.0.3000.0 ((SQL11_PCU_Main).121019-1322 )
     CodeBase: file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/110/Microsoft.AnalysisServices.XLHost.Addin.DLL
 ----------------------------------------
 Microsoft.Office.Tools.Common.v4.0.Utilities
     Assembly Version: 10.0.0.0
     Win32 Version: 10.0.30319.1
     CodeBase: file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/110/Microsoft.Office.Tools.Common.v4.0.Utilities.DLL
 ----------------------------------------
 Microsoft.Office.Tools.Excel
     Assembly Version: 10.0.0.0
     Win32 Version: 10.0.60301.0
     CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.Office.Tools.Excel/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.Excel.dll
 ----------------------------------------
 Microsoft.AnalysisServices.XLHost.Modeler.O14
     Assembly Version: 11.0.0.0
     Win32 Version: 11.0.3000.0 ((SQL11_PCU_Main).121019-1322 )
     CodeBase: file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/110/Microsoft.AnalysisServices.XLHost.Modeler.O14.DLL
 ----------------------------------------
 Microsoft.AnalysisServices.Common.O14
     Assembly Version: 11.0.0.0
     Win32 Version: 11.0.3000.0 ((SQL11_PCU_Main).121019-1322 )
     CodeBase: file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/110/Microsoft.AnalysisServices.Common.O14.DLL
 ----------------------------------------
 Microsoft.AnalysisServices.Common.FrontEnd.O14
     Assembly Version: 11.0.0.0
     Win32 Version: 2011.0110.3000.00 ((SQL11_PCU_Main).121019-1301)
     CodeBase: file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/110/Microsoft.AnalysisServices.Common.FrontEnd.O14.DLL
 ----------------------------------------
 Accessibility
     Assembly Version: 4.0.0.0
     Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
     CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
 ----------------------------------------
 Microsoft.AnalysisServices.BackEnd.O14
     Assembly Version: 11.0.0.0
     Win32 Version: 2011.0110.3000.00 ((SQL11_PCU_Main).121019-1301)
     CodeBase: file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/110/Microsoft.AnalysisServices.BackEnd.O14.DLL
 ----------------------------------------
 Microsoft.CSharp
     Assembly Version: 4.0.0.0
     Win32 Version: 4.0.30319.34209
     CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.CSharp/v4.0_4.0.0.0__b03f5f7f11d50a3a/Microsoft.CSharp.dll
 ----------------------------------------
 Microsoft.DataWarehouse
     Assembly Version: 11.0.0.0
     Win32 Version: 11.0.3000.0 ((SQL11_PCU_Main).121019-1322 )
     CodeBase: file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/110/Microsoft.DataWarehouse.DLL
 ----------------------------------------
 Anonymously Hosted DynamicMethods Assembly
     Assembly Version: 0.0.0.0
     Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
     CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/mscorlib/v4.0_4.0.0.0__b77a5c561934e089/mscorlib.dll
 ----------------------------------------
 System.Dynamic
     Assembly Version: 4.0.0.0
     Win32 Version: 4.0.30319.34209
     CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Dynamic/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Dynamic.dll
 ----------------------------------------
 Microsoft.AnalysisServices.BackEnd.XmlSerializers.O14
     Assembly Version: 11.0.0.0
     Win32 Version: 2011.0110.3000.00 ((SQL11_PCU_Main).121019-1301)
     CodeBase: file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/110/Microsoft.AnalysisServices.BackEnd.XmlSerializers.O14.DLL
 ----------------------------------------
 System.Data
     Assembly Version: 4.0.0.0
     Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
     CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
 ----------------------------------------
 Microsoft.GeneratedCode
     Assembly Version: 1.0.0.0
     Win32 Version: 4.0.30319.34234 built by: FX452RTMGDR
     CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
 ----------------------------------------
 WindowsBase
     Assembly Version: 4.0.0.0
     Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
     CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/WindowsBase/v4.0_4.0.0.0__31bf3856ad364e35/WindowsBase.dll
 ----------------------------------------
 System.Runtime.Serialization
     Assembly Version: 4.0.0.0
     Win32 Version: 4.0.30319.34234 built by: FX452RTMGDR
     CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Serialization/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Serialization.dll
 ----------------------------------------
 Microsoft.AnalysisServices
     Assembly Version: 11.0.0.0
     Win32 Version: 11.0.3000.0 ((SQL11_PCU_Main).121019-1322 )
     CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.AnalysisServices/11.0.0.0__89845dcd8080cc91/Microsoft.AnalysisServices.dll
 ----------------------------------------
 WindowsFormsIntegration
     Assembly Version: 4.0.0.0
     Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
     CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/WindowsFormsIntegration/v4.0_4.0.0.0__31bf3856ad364e35/WindowsFormsIntegration.dll
 ----------------------------------------
 PresentationFramework
     Assembly Version: 4.0.0.0
     Win32 Version: 4.0.30319.34209
     CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/PresentationFramework/v4.0_4.0.0.0__31bf3856ad364e35/PresentationFramework.dll
 ----------------------------------------
 PresentationCore
     Assembly Version: 4.0.0.0
     Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
     CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/PresentationCore/v4.0_4.0.0.0__31bf3856ad364e35/PresentationCore.dll
 ----------------------------------------
 System.Xaml
     Assembly Version: 4.0.0.0
     Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
     CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xaml/v4.0_4.0.0.0__b77a5c561934e089/System.Xaml.dll
 ----------------------------------------
 System.Transactions
     Assembly Version: 4.0.0.0
     Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
     CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
 ----------------------------------------
 System.Numerics
     Assembly Version: 4.0.0.0
     Win32 Version: 4.0.30319.34209 built by: FX452RTMGDR
     CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll
 ----------------------------------------
 Microsoft.AnalysisServices.AdomdClient
     Assembly Version: 11.0.0.0
     Win32 Version: 11.0.3000.0 ((SQL11_PCU_Main).121019-1322 )
     CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.AnalysisServices.AdomdClient/11.0.0.0__89845dcd8080cc91/Microsoft.AnalysisServices.AdomdClient.dll
 ----------------------------------------
 Microsoft.SqlServer.Configuration.SString
     Assembly Version: 11.0.0.0
     Win32 Version: 11.0.3000.0 ((SQL11_PCU_Main).121019-1322 )
     CodeBase: file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/110/Microsoft.SqlServer.Configuration.SString.DLL
 ----------------------------------------
 msmgdsrv
     Assembly Version: 9.0.0.0
     Win32 Version: 2011.0110.3000.00
     CodeBase: file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20OLEDB/110/msmgdsrv.dll
 ----------------------------------------
 SMDiagnostics
     Assembly Version: 4.0.0.0
     Win32 Version: 4.0.30319.34234 built by: FX452RTMGDR
     CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/SMDiagnostics/v4.0_4.0.0.0__b77a5c561934e089/SMDiagnostics.dll
 ----------------------------------------
 System.ServiceModel.Internals
     Assembly Version: 4.0.0.0
     Win32 Version: 4.0.30319.34234 built by: FX452RTMGDR
     CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel.Internals/v4.0_4.0.0.0__31bf3856ad364e35/System.ServiceModel.Internals.dll
 ----------------------------------------
 Microsoft.AnalysisServices.Common.FrontEnd.XmlSerializers.O14
     Assembly Version: 11.0.0.0
     Win32 Version: 2011.0110.3000.00 ((SQL11_PCU_Main).121019-1301)
     CodeBase: file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/110/Microsoft.AnalysisServices.Common.FrontEnd.XmlSerializers.O14.DLL
 ----------------------------------------

 ************** JIT Debugging **************
 To enable just-in-time (JIT) debugging, the .config file for this
 application or computer (machine.config) must have the
 jitDebugging value set in the system.windows.forms section.
 The application must also be compiled with debugging
 enabled.

 For example:

 <configuration>
     <system.windows.forms jitDebugging="true" />
 </configuration>

 When JIT debugging is enabled, any unhandled exception
 will be sent to the JIT debugger registered on the computer
 rather than be handled by this dialog box.
upobDaPlayaAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Iamthecreator OMIT Admin/EE Solution GuideCommented:
Try removing the Power Pivot add-on and re-adding it (if not done already).
0
upobDaPlayaAuthor Commented:
Tried that. 😥
0
Iamthecreator OMIT Admin/EE Solution GuideCommented:
What we can try.

Check and verify if you have different versions of MS Office products installed.

Download and run the Office configuration Tool analyzer
Microsoft Office Configuration Analyzer Tool 2.2
https://www.microsoft.com/en-us/download/details.aspx?id=36852

Repair/Reinstall .NET Framework
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

upobDaPlayaAuthor Commented:
It appears I have different versions of Office installed...how do I clean remove the versions I dont need/use
0
Iamthecreator OMIT Admin/EE Solution GuideCommented:
Use the control panel
Add and Remove programs OR Programs and Features.
0
upobDaPlayaAuthor Commented:
Thanks...I dont have Admin rights so here hoping my Admin gets back to me quickly for the reinstall :)  I assume this has to be my issue.. thx much
0
Iamthecreator OMIT Admin/EE Solution GuideCommented:
Please confirm the resolution as soon as you can.
The question can be re-opened if the issue is not solved.
0
upobDaPlayaAuthor Commented:
Problem solved.  I did have multiple versions and least according to the registry.  I deleted the 1.8 folder (2013) from Hkeu_Classes_Root Type Lib 00020813 0000 0000 C000 000000000046
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PowerPivot

From novice to tech pro — start learning today.