none
PowerPivot Will Not Load - Tried Most Things

    Question

  • Hi,

    Been grappling with this all day. Running Windows 7 & Office 2010/PowerPivot 32 bit. PowerPivot installs ok, but will not load (A runtime error occurred during the loading of the COM Add-in).

    Have been through all the steps i.e. clean install Office 2010 with Office Shared Features & .Net Programmability Support before installing PowerPivot. Have also tried installing Visual Studio 2010 Tools for Office Runtime and still no luck. Any help would be appreciated, really need to crack this. Thanks.

    Event Viewer states it's a VSTO 4.0 problem:

    Log Name:      Application

    Source:        VSTO 4.0

    Date:          2/27/2013 1:50:20 PM

    Event ID:      4096

    Task Category: None

    Level:         Error

    Keywords:      Classic

    User:          N/A

    Computer:      user09-PC

    Description:

    Customization URI: file:///C:/Program Files/Microsoft Analysis Services/AS Excel Client/110/

    Exception: Customization could not be loaded because the application domain could not be created.

    ************** Exception Text **************

    Microsoft.VisualStudio.Tools.Applications.Runtime.CannotCreateCustomizationDomainException: Customization could not be loaded because the application domain could not be created. ---> System.BadImageFormatException: Could not load file or assembly 'Microsoft.AnalysisServices.XLHost.Addin, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. This assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded.

    File name: 'Microsoft.AnalysisServices.XLHost.Addin, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'

       at System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)

       at System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)

       at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)

       at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)

       at System.Reflection.Assembly.Load(String assemblyString)

       at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.DomainInitializer.ActivatePipeline(String addInAssembly, String addInClass, String[] pipelineInfo)

       at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.DomainInitializer.StartAddIn(IntPtr hostServiceProvider, String[] pipeline, String assemblyName, String[] entryPoints)

       at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.DomainInitializer.StartAddIn(IntPtr hostServiceProvider, String[] pipeline, String assemblyName, String[] entryPoints)

       at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.LoadMafPipeline(AppDomain newDomain, IntPtr hostServiceProvider, String fullAssemblyName, String[] entryPoints, OfficeApp officeApplication, OfficeVersion officeVersion, IntPtr& executor)

       at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.CreateCustomizationDomainInternal(String solutionLocation, String manifestName, String documentName, Boolean showUIDuringDeployment, IntPtr hostServiceProvider, Boolean useFastPath, IntPtr& executor)

    WRN: Assembly binding logging is turned OFF.

    To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.

    Note: There is some performance penalty associated with assembly bind failure logging.

    To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

       --- End of inner exception stack trace ---

    ************** Loaded Assemblies **************

    mscorlib

        Assembly Version: 2.0.0.0

        Win32 Version: 2.0.50727.5466 (Win7SP1GDR.050727-5400)

        CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll

    ----------------------------------------

    Microsoft.VisualStudio.Tools.Office.Runtime.v10.0

        Assembly Version: 10.0.0.0

        Win32 Version: 10.0.40303.0

        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Runtime.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.Runtime.v10.0.dll

    ----------------------------------------

    System

        Assembly Version: 2.0.0.0

        Win32 Version: 2.0.50727.5467 (Win7SP1GDR.050727-5400)

        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

    ----------------------------------------

    System.Core

        Assembly Version: 3.5.0.0

        Win32 Version: 3.5.30729.5420 built by: Win7SP1

        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Core/3.5.0.0__b77a5c561934e089/System.Core.dll

    ----------------------------------------

    Microsoft.VisualStudio.Tools.Applications.Hosting.v10.0

        Assembly Version: 10.0.0.0

        Win32 Version: 10.0.40303.0

        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Hosting.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Hosting.v10.0.dll

    ----------------------------------------

    System.AddIn

        Assembly Version: 3.5.0.0

        Win32 Version: 3.5.30729.5446 built by: Win7SP1GDR

        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.AddIn/3.5.0.0__b77a5c561934e089/System.AddIn.dll

    ----------------------------------------

    Microsoft.VisualStudio.Tools.Applications.ServerDocument.v10.0

        Assembly Version: 10.0.0.0

        Win32 Version: 10.0.40303.0

        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.ServerDocument.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.ServerDocument.v10.0.dll

    ----------------------------------------

    Microsoft.VisualStudio.Tools.Applications.Runtime.v9.0

        Assembly Version: 9.0.0.0

        Win32 Version: 9.0.30729.5806

        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Runtime.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Runtime.v9.0.dll

    ----------------------------------------

    Event Xml:

    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">

      <System>

        <Provider Name="VSTO 4.0" />

        <EventID Qualifiers="49154">4096</EventID>

        <Level>2</Level>

        <Task>0</Task>

        <Keywords>0x80000000000000</Keywords>

        <TimeCreated SystemTime="2013-02-27T17:50:20.000000000Z" />

        <EventRecordID>21647</EventRecordID>

        <Channel>Application</Channel>

        <Computer>user09-PC</Computer>

        <Security />

      </System>

      <EventData>

        <Data>Customization URI: file:///C:/Program Files/Microsoft Analysis Services/AS Excel Client/110/

    Exception: Customization could not be loaded because the application domain could not be created.

    ************** Exception Text **************

    Microsoft.VisualStudio.Tools.Applications.Runtime.CannotCreateCustomizationDomainException: Customization could not be loaded because the application domain could not be created. ---&gt; System.BadImageFormatException: Could not load file or assembly 'Microsoft.AnalysisServices.XLHost.Addin, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. This assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded.

    File name: 'Microsoft.AnalysisServices.XLHost.Addin, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'

       at System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark&amp; stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)

       at System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark&amp; stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)

       at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark&amp; stackMark, Boolean forIntrospection)

       at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark&amp; stackMark, Boolean forIntrospection)

       at System.Reflection.Assembly.Load(String assemblyString)

       at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.DomainInitializer.ActivatePipeline(String addInAssembly, String addInClass, String[] pipelineInfo)

       at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.DomainInitializer.StartAddIn(IntPtr hostServiceProvider, String[] pipeline, String assemblyName, String[] entryPoints)

       at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.DomainInitializer.StartAddIn(IntPtr hostServiceProvider, String[] pipeline, String assemblyName, String[] entryPoints)

       at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.LoadMafPipeline(AppDomain newDomain, IntPtr hostServiceProvider, String fullAssemblyName, String[] entryPoints, OfficeApp officeApplication, OfficeVersion officeVersion, IntPtr&amp; executor)

       at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.CreateCustomizationDomainInternal(String solutionLocation, String manifestName, String documentName, Boolean showUIDuringDeployment, IntPtr hostServiceProvider, Boolean useFastPath, IntPtr&amp; executor)

    WRN: Assembly binding logging is turned OFF.

    To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.

    Note: There is some performance penalty associated with assembly bind failure logging.

    To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

       --- End of inner exception stack trace ---

    ************** Loaded Assemblies **************

    mscorlib

        Assembly Version: 2.0.0.0

        Win32 Version: 2.0.50727.5466 (Win7SP1GDR.050727-5400)

        CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll

    ----------------------------------------

    Microsoft.VisualStudio.Tools.Office.Runtime.v10.0

        Assembly Version: 10.0.0.0

        Win32 Version: 10.0.40303.0

        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Runtime.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.Runtime.v10.0.dll

    ----------------------------------------

    System

        Assembly Version: 2.0.0.0

        Win32 Version: 2.0.50727.5467 (Win7SP1GDR.050727-5400)

        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

    ----------------------------------------

    System.Core

        Assembly Version: 3.5.0.0

        Win32 Version: 3.5.30729.5420 built by: Win7SP1

        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Core/3.5.0.0__b77a5c561934e089/System.Core.dll

    ----------------------------------------

    Microsoft.VisualStudio.Tools.Applications.Hosting.v10.0

        Assembly Version: 10.0.0.0

        Win32 Version: 10.0.40303.0

        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Hosting.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Hosting.v10.0.dll

    ----------------------------------------

    System.AddIn

        Assembly Version: 3.5.0.0

        Win32 Version: 3.5.30729.5446 built by: Win7SP1GDR

        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.AddIn/3.5.0.0__b77a5c561934e089/System.AddIn.dll

    ----------------------------------------

    Microsoft.VisualStudio.Tools.Applications.ServerDocument.v10.0

        Assembly Version: 10.0.0.0

        Win32 Version: 10.0.40303.0

        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.ServerDocument.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.ServerDocument.v10.0.dll

    ----------------------------------------

    Microsoft.VisualStudio.Tools.Applications.Runtime.v9.0

        Assembly Version: 9.0.0.0

        Win32 Version: 9.0.30729.5806

        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Runtime.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Runtime.v9.0.dll

    ----------------------------------------

     
    Wednesday, February 27, 2013 6:29 PM

Answers