Exception while using powerpivot for EXCEL

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

Answer 1

Found the solution:

1 - First complete the uninstall of OFFICE 2013:

http://support.microsoft.com/kb/2739501

http://answers.microsoft.com/en-us/office/forum/office_home-office_install/unable-to-uninstall-office-365-home-preview/86bd3242-f137-4a0b-ba22-94867d82b7c2

2 - Delete all Registry Keys refering the following assembly: Microsoft.Office.Interop.Excel, Version=15.0.0.0

3 - If not enought delete all keys refering Microsoft.Office.Interop.XXXX, Version=15.0.0.0 where XXXX is an Office 2013 program