locked
Exception while using powerpivot for EXCEL RRS feed

  • Question

  • I have an exception while clickingin the Powerpivot window. Seems to be after installing and desintalling OFFICE 2013 and reinstalling OFFICE 2010, due to licence key problem (avoid testing Office 2013 if not on a separate VM !). Any idea ?  

    System.InvalidCastException: L'argument de retour a un type non valide.
       à System.Runtime.Remoting.Proxies.RealProxy.ValidateReturnArg(Object arg, Type paramType)
       à System.Runtime.Remoting.Proxies.RealProxy.PropagateOutParameters(IMessage msg, Object[] outArgs, Object returnValue)
       à System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
       à System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
       à Microsoft.Office.Interop.Excel._Application.get_ActiveWorkbook()
       à Microsoft.AnalysisServices.XLHost.Addin.GeminiRibbon.currentClientWindow_InFormulaBarChanged(Object sender, EventArgs e)
       à Microsoft.AnalysisServices.XLHost.Modeler.ClientWindow.OnInFormulaBarChanged()
       à Microsoft.AnalysisServices.XLHost.Modeler.ClientWindow.sandboxEditor_InFormulaBarChanged(Object sender, EventArgs e)
       à Microsoft.AnalysisServices.Common.SandboxEditor.OnInFormulaBarChanged(EventArgs e)
       à Microsoft.AnalysisServices.Common.SandboxEditor.formulaBar_Enter(Object sender, EventArgs e)
       à System.EventHandler.Invoke(Object sender, EventArgs e)
       à System.Windows.Forms.Control.OnEnter(EventArgs e)
       à System.Windows.Forms.Control.NotifyEnter()
       à System.Windows.Forms.ContainerControl.UpdateFocusedControl()


    ************** Assemblys chargés **************
    mscorlib
        Version de l'assembly : 4.0.0.0
        Version Win32 : 4.0.30319.17379 built by: FXBETAREL
        CodeBase : file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
    ----------------------------------------
    Microsoft.VisualStudio.Tools.Office.Runtime.Internal
        Version de l'assembly : 10.0.0.0
        Version Win32 : 10.0.31125.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
        Version de l'assembly : 4.0.0.0
        Version Win32 : 4.0.30319.17379 built by: FXBETAREL
        CodeBase : file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
    ----------------------------------------
    Microsoft.VisualStudio.Tools.Applications.Runtime
        Version de l'assembly : 10.0.0.0
        Version Win32 : 10.0.31125.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
        Version de l'assembly : 4.0.0.0
        Version Win32 : 4.0.30319.17379 built by: FXBETAREL
        CodeBase : file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
    ----------------------------------------
    Microsoft.Office.Tools
        Version de l'assembly : 10.0.0.0
        Version Win32 : 10.0.31125.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
        Version de l'assembly : 10.0.0.0
        Version Win32 : 10.0.31125.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
        Version de l'assembly : 10.0.0.0
        Version Win32 : 10.0.31125.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
        Version de l'assembly : 10.0.0.0
        Version Win32 : 10.0.31125.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
    ----------------------------------------
    Microsoft.Office.Tools.Excel
        Version de l'assembly : 10.0.0.0
        Version Win32 : 10.0.31125.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
    ----------------------------------------
    System.Windows.Forms
        Version de l'assembly : 4.0.0.0
        Version Win32 : 4.0.30319.17451 built by: FXBETAGDR
        CodeBase : file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
    ----------------------------------------
    System.Drawing
        Version de l'assembly : 4.0.0.0
        Version Win32 : 4.0.30319.17379 built by: FXBETAREL
        CodeBase : file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
    ----------------------------------------
    Microsoft.AnalysisServices.XLHost.Addin
        Version de l'assembly : 11.0.0.0
        Version Win32 : 11.0.2100.60 ((SQL11_RTM).120210-1846 )
        CodeBase : file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/110/Microsoft.AnalysisServices.XLHost.Addin.DLL
    ----------------------------------------
    Microsoft.Office.Tools.Common.v4.0.Utilities
        Version de l'assembly : 10.0.0.0
        Version Win32 : 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.AnalysisServices.XLHost.Modeler
        Version de l'assembly : 11.0.0.0
        Version Win32 : 11.0.2100.60 ((SQL11_RTM).120210-1846 )
        CodeBase : file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/110/Microsoft.AnalysisServices.XLHost.Modeler.DLL
    ----------------------------------------
    Microsoft.AnalysisServices.Common
        Version de l'assembly : 11.0.0.0
        Version Win32 : 11.0.2100.60 ((SQL11_RTM).120210-1846 )
        CodeBase : file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/110/Microsoft.AnalysisServices.Common.DLL
    ----------------------------------------
    Microsoft.AnalysisServices.Common.FrontEnd
        Version de l'assembly : 11.0.0.0
        Version Win32 : 2011.0110.2100.60 ((SQL11_RTM).120210-1612)
        CodeBase : file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/110/Microsoft.AnalysisServices.Common.FrontEnd.DLL
    ----------------------------------------
    System.Xml
        Version de l'assembly : 4.0.0.0
        Version Win32 : 4.0.30319.17379 built by: FXBETAREL
        CodeBase : file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
    ----------------------------------------
    Microsoft.AnalysisServices.XLHost.Addin.resources
        Version de l'assembly : 11.0.0.0
        Version Win32 : 11.0.2100.60 ((SQL11_RTM).120210-1846 )
        CodeBase : file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/110/fr/Microsoft.AnalysisServices.XLHost.Addin.resources.DLL
    ----------------------------------------
    Accessibility
        Version de l'assembly : 4.0.0.0
        Version Win32 : 4.0.30319.17379 built by: FXBETAREL
        CodeBase : file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
    ----------------------------------------
    Microsoft.AnalysisServices.BackEnd
        Version de l'assembly : 11.0.0.0
        Version Win32 : 2011.0110.2100.60 ((SQL11_RTM).120210-1612)
        CodeBase : file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/110/Microsoft.AnalysisServices.BackEnd.DLL
    ----------------------------------------
    Microsoft.AnalysisServices.Common.resources
        Version de l'assembly : 11.0.0.0
        Version Win32 : 11.0.2100.60 ((SQL11_RTM).120210-1846 )
        CodeBase : file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/110/fr/Microsoft.AnalysisServices.Common.resources.DLL
    ----------------------------------------
    Microsoft.AnalysisServices.Common.FrontEnd.resources
        Version de l'assembly : 11.0.0.0
        Version Win32 : 2011.0110.2100.60 ((SQL11_RTM).120210-1612)
        CodeBase : file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/110/fr/Microsoft.AnalysisServices.Common.FrontEnd.resources.DLL
    ----------------------------------------
    Microsoft.CSharp
        Version de l'assembly : 4.0.0.0
        Version Win32 : 4.0.30319.17379
        CodeBase : file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.CSharp/v4.0_4.0.0.0__b03f5f7f11d50a3a/Microsoft.CSharp.dll
    ----------------------------------------
    Microsoft.DataWarehouse
        Version de l'assembly : 11.0.0.0
        Version Win32 : 11.0.2100.60 ((SQL11_RTM).120210-1846 )
        CodeBase : file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/110/Microsoft.DataWarehouse.DLL
    ----------------------------------------
    Anonymously Hosted DynamicMethods Assembly
        Version de l'assembly : 0.0.0.0
        Version Win32 : 4.0.30319.17379 built by: FXBETAREL
        CodeBase : file:///C:/Windows/Microsoft.Net/assembly/GAC_32/mscorlib/v4.0_4.0.0.0__b77a5c561934e089/mscorlib.dll
    ----------------------------------------
    System.Dynamic
        Version de l'assembly : 4.0.0.0
        Version Win32 : 4.0.30319.17379
        CodeBase : file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Dynamic/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Dynamic.dll
    ----------------------------------------
    System.Configuration
        Version de l'assembly : 4.0.0.0
        Version Win32 : 4.0.30319.17379 built by: FXBETAREL
        CodeBase : file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
    ----------------------------------------
    Microsoft.AnalysisServices.BackEnd.XmlSerializers
        Version de l'assembly : 11.0.0.0
        Version Win32 : 2011.0110.2100.60 ((SQL11_RTM).120210-1612)
        CodeBase : file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/110/Microsoft.AnalysisServices.BackEnd.XmlSerializers.DLL
    ----------------------------------------
    Microsoft.GeneratedCode
        Version de l'assembly : 1.0.0.0
        Version Win32 : 4.0.30319.17379 built by: FXBETAREL
        CodeBase : file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
    ----------------------------------------
    WindowsBase
        Version de l'assembly : 4.0.0.0
        Version Win32 : 4.0.30319.17379 built by: FXBETAREL
        CodeBase : file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/WindowsBase/v4.0_4.0.0.0__31bf3856ad364e35/WindowsBase.dll
    ----------------------------------------
    System.Runtime.Serialization
        Version de l'assembly : 4.0.0.0
        Version Win32 : 4.0.30319.17379 built by: FXBETAREL
        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.XLHost.Modeler.resources
        Version de l'assembly : 11.0.0.0
        Version Win32 : 11.0.2100.60 ((SQL11_RTM).120210-1846 )
        CodeBase : file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/110/fr/Microsoft.AnalysisServices.XLHost.Modeler.resources.DLL
    ----------------------------------------
    Microsoft.AnalysisServices
        Version de l'assembly : 11.0.0.0
        Version Win32 : 11.0.2100.60 ((SQL11_RTM).120210-1846 )
        CodeBase : file:///C:/Windows/assembly/GAC_MSIL/Microsoft.AnalysisServices/11.0.0.0__89845dcd8080cc91/Microsoft.AnalysisServices.dll
    ----------------------------------------
    WindowsFormsIntegration
        Version de l'assembly : 4.0.0.0
        Version Win32 : 4.0.30319.17379 built by: FXBETAREL
        CodeBase : file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/WindowsFormsIntegration/v4.0_4.0.0.0__31bf3856ad364e35/WindowsFormsIntegration.dll
    ----------------------------------------
    PresentationFramework
        Version de l'assembly : 4.0.0.0
        Version Win32 : 4.0.30319.17379
        CodeBase : file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/PresentationFramework/v4.0_4.0.0.0__31bf3856ad364e35/PresentationFramework.dll
    ----------------------------------------
    PresentationCore
        Version de l'assembly : 4.0.0.0
        Version Win32 : 4.0.30319.17379 built by: FXBETAREL
        CodeBase : file:///C:/Windows/Microsoft.Net/assembly/GAC_32/PresentationCore/v4.0_4.0.0.0__31bf3856ad364e35/PresentationCore.dll
    ----------------------------------------
    System.Xaml
        Version de l'assembly : 4.0.0.0
        Version Win32 : 4.0.30319.17379 built by: FXBETAREL
        CodeBase : file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xaml/v4.0_4.0.0.0__b77a5c561934e089/System.Xaml.dll
    ----------------------------------------
    System.Data
        Version de l'assembly : 4.0.0.0
        Version Win32 : 4.0.30319.17379 built by: FXBETAREL
        CodeBase : file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
    ----------------------------------------
    System.Transactions
        Version de l'assembly : 4.0.0.0
        Version Win32 : 4.0.30319.17379 built by: FXBETAREL
        CodeBase : file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
    ----------------------------------------
    System.Numerics
        Version de l'assembly : 4.0.0.0
        Version Win32 : 4.0.30319.17379 built by: FXBETAREL
        CodeBase : file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll
    ----------------------------------------
    Microsoft.AnalysisServices.AdomdClient
        Version de l'assembly : 11.0.0.0
        Version Win32 : 11.0.2100.60 ((SQL11_RTM).120210-1846 )
        CodeBase : file:///C:/Windows/assembly/GAC_MSIL/Microsoft.AnalysisServices.AdomdClient/11.0.0.0__89845dcd8080cc91/Microsoft.AnalysisServices.AdomdClient.dll
    ----------------------------------------
    Microsoft.SqlServer.Configuration.SString
        Version de l'assembly : 11.0.0.0
        Version Win32 : 11.0.2100.60 ((SQL11_RTM).120210-1846 )
        CodeBase : file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/110/Microsoft.SqlServer.Configuration.SString.DLL
    ----------------------------------------
    msmgdsrv
        Version de l'assembly : 9.0.0.0
        Version Win32 : 2011.0110.2316.00
        CodeBase : file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20OLEDB/110/msmgdsrv.dll
    ----------------------------------------
    SMDiagnostics
        Version de l'assembly : 4.0.0.0
        Version Win32 : 4.0.30319.17379 built by: FXBETAREL
        CodeBase : file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/SMDiagnostics/v4.0_4.0.0.0__b77a5c561934e089/SMDiagnostics.dll
    ----------------------------------------
    System.ServiceModel.Internals
        Version de l'assembly : 4.0.0.0
        Version Win32 : 4.0.30319.17379 built by: FXBETAREL
        CodeBase : file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel.Internals/v4.0_4.0.0.0__31bf3856ad364e35/System.ServiceModel.Internals.dll
    ----------------------------------------
    System.RunTime.Serialization.resources
        Version de l'assembly : 4.0.0.0
        Version Win32 : 4.0.30319.17379 built by: FXBETAREL
        CodeBase : file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Serialization.resources/v4.0_4.0.0.0_fr_b77a5c561934e089/System.Runtime.Serialization.resources.dll
    ----------------------------------------
    System.Windows.Forms.resources
        Version de l'assembly : 4.0.0.0
        Version Win32 : 4.0.30319.17379 built by: FXBETAREL
        CodeBase : file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms.resources/v4.0_4.0.0.0_fr_b77a5c561934e089/System.Windows.Forms.resources.dll
    ----------------------------------------
    Microsoft.AnalysisServices.Common.FrontEnd.XmlSerializers
        Version de l'assembly : 11.0.0.0
        Version Win32 : 2011.0110.2100.60 ((SQL11_RTM).120210-1612)
        CodeBase : file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/110/Microsoft.AnalysisServices.Common.FrontEnd.XmlSerializers.DLL
    ----------------------------------------
    Microsoft.AnalysisServices.BackEnd.resources
        Version de l'assembly : 11.0.0.0
        Version Win32 : 2011.0110.2100.60 ((SQL11_RTM).120210-1612)
        CodeBase : file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/110/fr/Microsoft.AnalysisServices.BackEnd.resources.DLL

    Friday, August 17, 2012 10:23 AM

Answers