PowerPivot for Excel 2013 - unhandle exception error - unable to cast COM object

Question

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) debugging instead of this dialog box.

************** Exception Text **************
System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.Office.Core.IRibbonUI'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{000C03A7-0000-0000-C000-000000000046}' failed due to the following error: Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED)).
   at System.StubHelpers.StubHelpers.GetCOMIPFromRCW(Object objSrc, IntPtr pCPCMD, IntPtr& ppTarget, Boolean& pfNeedsRelease)
   at Microsoft.Office.Core.IRibbonUI.Invalidate()
   at Microsoft.Office.PowerPivot.ExcelAddIn.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.18063 built by: FX45RTMGDR
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
Microsoft.Mashup.Client.Excel
    Assembly Version: 1.0.0.0
    Win32 Version: 2.37.4464.644
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/Microsoft.Mashup.Client.Excel.dll
----------------------------------------
Extensibility
    Assembly Version: 7.0.3300.0
    Win32 Version: 7.00.9466
    CodeBase: file:///C:/WINDOWS/assembly/GAC/Extensibility/7.0.3300.0__b03f5f7f11d50a3a/Extensibility.dll
----------------------------------------
office
    Assembly Version: 15.0.0.0
    Win32 Version: 15.0.4963.1002
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/office/15.0.0.0__71e9bce111e9429c/office.dll
----------------------------------------
Microsoft.Mashup.Client.Windows
    Assembly Version: 1.0.0.0
    Win32 Version: 2.37.4464.644
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/Microsoft.Mashup.Client.Windows.DLL
----------------------------------------
Microsoft.Mashup.Document
    Assembly Version: 1.0.0.0
    Win32 Version: 2.37.4464.644
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/Microsoft.Mashup.Document.DLL
----------------------------------------
System
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.18044 built by: FX45RTMGDR
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.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.Core
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.17929 built by: FX45RTMREL
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Windows.Forms
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.18047 built by: FX45RTMGDR
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
Microsoft.MashupEngine
    Assembly Version: 1.0.0.0
    Win32 Version: 2.37.4464.644
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/Microsoft.MashupEngine.DLL
----------------------------------------
Microsoft.Mashup.Client.AddinTelemetry
    Assembly Version: 1.0.0.0
    Win32 Version: 2.37.4464.644
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/Microsoft.Mashup.Client.AddinTelemetry.DLL
----------------------------------------
Microsoft.Mashup.ProviderShared
    Assembly Version: 1.0.0.0
    Win32 Version: 2.37.4464.644
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/Microsoft.Mashup.ProviderShared.DLL
----------------------------------------
Microsoft.Office.Interop.Excel
    Assembly Version: 15.0.0.0
    Win32 Version: 15.0.4569.1506
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.Office.Interop.Excel/15.0.0.0__71e9bce111e9429c/Microsoft.Office.Interop.Excel.dll
----------------------------------------
Microsoft.Practices.Unity
    Assembly Version: 2.1.505.0
    Win32 Version: 2.1.505.2
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/Microsoft.Practices.Unity.DLL
----------------------------------------
Microsoft.Mashup.Client.Models
    Assembly Version: 1.0.0.0
    Win32 Version: 2.37.4464.644
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/Microsoft.Mashup.Client.Models.DLL
----------------------------------------
System.Configuration
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.18060 built by: FX45RTMGDR
    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.18060 built by: FX45RTMGDR
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Microsoft.Mashup.EventSource
    Assembly Version: 1.0.0.0
    Win32 Version: 2.37.4464.644
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/Microsoft.Mashup.EventSource.DLL
----------------------------------------
Anonymously Hosted DynamicMethods Assembly
    Assembly Version: 0.0.0.0
    Win32 Version: 4.0.30319.18063 built by: FX45RTMGDR
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/mscorlib/v4.0_4.0.0.0__b77a5c561934e089/mscorlib.dll
----------------------------------------
Microsoft.Mashup.Document.resources
    Assembly Version: 1.0.0.0
    Win32 Version: 2.37.4464.644
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/de/Microsoft.Mashup.Document.resources.DLL
----------------------------------------
Microsoft.Mashup.Client.Excel.resources
    Assembly Version: 1.0.0.0
    Win32 Version: 2.37.4464.644
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/de/Microsoft.Mashup.Client.Excel.resources.DLL
----------------------------------------
System.Web.Mvc
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.60926.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/System.Web.Mvc.DLL
----------------------------------------
System.Web.Routing
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.17929
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Web.Routing/v4.0_4.0.0.0__31bf3856ad364e35/System.Web.Routing.dll
----------------------------------------
System.Web
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.34280 built by: FX452RTMGDR
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Web/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Web.dll
----------------------------------------
Microsoft.Mashup.OAuth
    Assembly Version: 1.0.0.0
    Win32 Version: 2.37.4464.644
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/Microsoft.Mashup.OAuth.DLL
----------------------------------------
Microsoft.MashupEngine.resources
    Assembly Version: 1.0.0.0
    Win32 Version: 2.37.4464.644
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/de/Microsoft.MashupEngine.resources.DLL
----------------------------------------
Localytics
    Assembly Version: 13.0.0.0
    Win32 Version: 13.0.1500.494
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/Localytics.DLL
----------------------------------------
System.ServiceModel
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.18055 built by: FX45RTMGDR
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel/v4.0_4.0.0.0__b77a5c561934e089/System.ServiceModel.dll
----------------------------------------
WindowsBase
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.18060 built by: FX45RTMGDR
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/WindowsBase/v4.0_4.0.0.0__31bf3856ad364e35/WindowsBase.dll
----------------------------------------
System.Web.Extensions
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.34280
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Web.Extensions/v4.0_4.0.0.0__31bf3856ad364e35/System.Web.Extensions.dll
----------------------------------------
Microsoft.Mashup.Client.Windows.resources
    Assembly Version: 1.0.0.0
    Win32 Version: 2.37.4464.644
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/de/Microsoft.Mashup.Client.Windows.resources.DLL
----------------------------------------
System.Runtime.Remoting
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.17929 built by: FX45RTMREL
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Remoting/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
Microsoft.Mashup.Document.XmlSerializers
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Power%20Query%20for%20Excel/bin/Microsoft.Mashup.Document.XmlSerializers.DLL
----------------------------------------
CustomMarshalers
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.17929 built by: FX45RTMREL
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/CustomMarshalers/v4.0_4.0.0.0__b03f5f7f11d50a3a/CustomMarshalers.dll
----------------------------------------
Microsoft.Office.PowerPivot.ExcelAddIn
    Assembly Version: 11.0.0.0
    Win32 Version: 2011.0110.2814.08 ((BI_O15_OfficeBox-OD).140812-1437)
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Office15/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.Office.PowerPivot.ExcelAddIn.dll
----------------------------------------
Microsoft.AnalysisServices.XLHost.Modeler
    Assembly Version: 11.0.0.0
    Win32 Version: 11.0.2814.8 ((BI_O15_OfficeBox-OD).140812-1446 )
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Office15/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.AnalysisServices.XLHost.Modeler.DLL
----------------------------------------
Microsoft.AnalysisServices.Common
    Assembly Version: 11.0.0.0
    Win32 Version: 11.0.2814.8 ((BI_O15_OfficeBox-OD).140812-1446 )
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Office15/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.AnalysisServices.Common.DLL
----------------------------------------
Microsoft.AnalysisServices.Excel.BackEnd
    Assembly Version: 11.0.0.0
    Win32 Version: 2011.0110.2814.08 ((BI_O15_OfficeBox-OD).140812-1437)
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Office15/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.AnalysisServices.Excel.BackEnd.DLL
----------------------------------------
Microsoft.AnalysisServices.Excel.Common.FrontEnd
    Assembly Version: 11.0.0.0
    Win32 Version: 2011.0110.2814.08 ((BI_O15_OfficeBox-OD).140812-1437)
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Office15/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.AnalysisServices.Excel.Common.FrontEnd.DLL
----------------------------------------
PresentationFramework
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.18060
    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.18060 built by: FX45RTMGDR
    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.18015 built by: FX45RTMGDR
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xaml/v4.0_4.0.0.0__b77a5c561934e089/System.Xaml.dll
----------------------------------------
Microsoft.Office.PowerPivot.ExcelAddIn.resources
    Assembly Version: 11.0.0.0
    Win32 Version: 2011.0110.2809.91 ((BI_O15_OfficeBox-CU).131122-1050)
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Office15/ADDINS/PowerPivot%20Excel%20Add-in/de/Microsoft.Office.PowerPivot.ExcelAddIn.resources.DLL
----------------------------------------
Microsoft.Data.Recommendation.Client.Picasso
    Assembly Version: 11.0.0.0
    Win32 Version: 11.0.2814.8 ((BI_O15_OfficeBox-OD).140812-1446 )
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Office15/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.Data.Recommendation.Client.Picasso.DLL
----------------------------------------
Microsoft.Data.Recommendation.Client.Core
    Assembly Version: 11.0.0.0
    Win32 Version: 2011.0110.2814.08 ((BI_O15_OfficeBox-OD).140812-1437)
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Office15/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.Data.Recommendation.Client.Core.DLL
----------------------------------------
Microsoft.Data.Recommendation.Common
    Assembly Version: 11.0.0.0
    Win32 Version: 2011.0110.2814.08 ((BI_O15_OfficeBox-OD).140812-1437)
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Office15/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.Data.Recommendation.Common.DLL
----------------------------------------
Microsoft.AnalysisServices.Common.resources
    Assembly Version: 11.0.0.0
    Win32 Version: 11.0.2809.86 ((BI_O15_OfficeBox-CU).130809-1908 )
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Office15/ADDINS/PowerPivot%20Excel%20Add-in/de/Microsoft.AnalysisServices.Common.resources.DLL
----------------------------------------
Microsoft.AnalysisServices.Excel.Common.FrontEnd.resources
    Assembly Version: 11.0.0.0
    Win32 Version: 2011.0110.2814.08 ((BI_O15_OfficeBox-OD).140812-1437)
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Office15/ADDINS/PowerPivot%20Excel%20Add-in/de/Microsoft.AnalysisServices.Excel.Common.FrontEnd.resources.DLL
----------------------------------------
Microsoft.GeneratedCode
    Assembly Version: 1.0.0.0
    Win32 Version: 4.0.30319.18060 built by: FX45RTMGDR
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Xml.Linq
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.17929 built by: FX45RTMREL
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml.Linq/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.Linq.dll
----------------------------------------
Microsoft.GeneratedCode
    Assembly Version: 1.0.0.0
    Win32 Version: 4.0.30319.18060 built by: FX45RTMGDR
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Microsoft.GeneratedCode
    Assembly Version: 1.0.0.0
    Win32 Version: 4.0.30319.18060 built by: FX45RTMGDR
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Microsoft.GeneratedCode
    Assembly Version: 1.0.0.0
    Win32 Version: 4.0.30319.18060 built by: FX45RTMGDR
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Microsoft.Office.Excel.DataModel
    Assembly Version: 15.0.0.0
    Win32 Version: 15.0.4615.1000
    CodeBase: file:///C:/Program%20Files%20(x86)/Common%20Files/Microsoft%20Shared/OFFICE15/DataModel/Microsoft.Office.Excel.DataModel.dll
----------------------------------------
System.Data
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.18047 built by: FX45RTMGDR
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
Microsoft.Excel.Amo
    Assembly Version: 11.0.0.0
    Win32 Version: 11.0.2814.2 ((BI_O15_OfficeBox-OD).140331-1835 )
    CodeBase: file:///C:/Program%20Files%20(x86)/Common%20Files/Microsoft%20Shared/OFFICE15/DataModel/Microsoft.Excel.Amo.DLL
----------------------------------------
Microsoft.GeneratedCode
    Assembly Version: 1.0.0.0
    Win32 Version: 4.0.30319.18060 built by: FX45RTMGDR
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Numerics
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.17929 built by: FX45RTMREL
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll
----------------------------------------
Microsoft.Excel.AdomdClient
    Assembly Version: 11.0.0.0
    Win32 Version: 11.0.2814.2 ((BI_O15_OfficeBox-OD).140331-1835 )
    CodeBase: file:///C:/Program%20Files%20(x86)/Common%20Files/Microsoft%20Shared/OFFICE15/DataModel/Microsoft.Excel.AdomdClient.DLL
----------------------------------------
Microsoft.GeneratedCode
    Assembly Version: 1.0.0.0
    Win32 Version: 4.0.30319.18060 built by: FX45RTMGDR
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Microsoft.GeneratedCode
    Assembly Version: 1.0.0.0
    Win32 Version: 4.0.30319.18060 built by: FX45RTMGDR
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Microsoft.GeneratedCode
    Assembly Version: 1.0.0.0
    Win32 Version: 4.0.30319.18060 built by: FX45RTMGDR
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Microsoft.GeneratedCode
    Assembly Version: 1.0.0.0
    Win32 Version: 4.0.30319.18060 built by: FX45RTMGDR
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Microsoft.GeneratedCode
    Assembly Version: 1.0.0.0
    Win32 Version: 4.0.30319.18060 built by: FX45RTMGDR
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Runtime.Serialization
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.18055 built by: FX45RTMGDR
    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
    Assembly Version: 11.0.0.0
    Win32 Version: 11.0.2809.81 ((BI_O15_OfficeBox-CU).130628-1558 )
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Office15/ADDINS/PowerPivot%20Excel%20Add-in/de/Microsoft.AnalysisServices.XLHost.Modeler.resources.DLL
----------------------------------------
WindowsFormsIntegration
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.18060 built by: FX45RTMGDR
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/WindowsFormsIntegration/v4.0_4.0.0.0__31bf3856ad364e35/WindowsFormsIntegration.dll
----------------------------------------
Microsoft.DataWarehouse
    Assembly Version: 11.0.0.0
    Win32 Version: 11.0.2814.8 ((BI_O15_OfficeBox-OD).140812-1446 )
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Office15/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.DataWarehouse.DLL
----------------------------------------
System.Transactions
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.17929 built by: FX45RTMREL
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
Microsoft.SqlServer.Configuration.SString
    Assembly Version: 11.0.0.0
    Win32 Version: 11.0.2814.8 ((BI_O15_OfficeBox-OD).140812-1446 )
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Office15/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.SqlServer.Configuration.SString.DLL
----------------------------------------
SMDiagnostics
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.17929 built by: FX45RTMREL
    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.17929 built by: FX45RTMREL
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel.Internals/v4.0_4.0.0.0__31bf3856ad364e35/System.ServiceModel.Internals.dll
----------------------------------------
Microsoft.Data.Recommendation.Client.Picasso.Sampler
    Assembly Version: 11.0.0.0
    Win32 Version: 2011.0110.2814.08 ((BI_O15_OfficeBox-OD).140812-1437)
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Office15/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.Data.Recommendation.Client.Picasso.Sampler.DLL
----------------------------------------
System.Data.Entity
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.18044 built by: FX45RTMGDR
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Data.Entity/v4.0_4.0.0.0__b77a5c561934e089/System.Data.Entity.dll
----------------------------------------
Microsoft.AnalysisServices.Excel.Common.FrontEnd.XmlSerializers
    Assembly Version: 11.0.0.0
    Win32 Version: 2011.0110.2814.08 ((BI_O15_OfficeBox-OD).140812-1437)
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Office15/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.AnalysisServices.Excel.Common.FrontEnd.XmlSerializers.dll
----------------------------------------
Microsoft.AnalysisServices.Excel.BackEnd.XmlSerializers
    Assembly Version: 11.0.0.0
    Win32 Version: 2011.0110.2814.08 ((BI_O15_OfficeBox-OD).140812-1437)
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Office/Office15/ADDINS/PowerPivot%20Excel%20Add-in/Microsoft.AnalysisServices.Excel.BackEnd.XmlSerializers.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:

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.

alun davies · Answer

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.

sergeibaklan · Answer

Hi Marc,&nbsp;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).&nbsp;I'd try to repair/update Office installations as well as add-ins.

marc rommel · Answer

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?

Forum Discussion

PowerPivot for Excel 2013 - unhandle exception error - unable to cast COM object

3 Replies

Resources