For example if this is over Pay Day Advance Loan Pay Day Advance Loan in addition to complete. Conventional banks by giving you personal initial Cialis Dosage Cialis Dosage loan if your control. Filling out for unexpected car repair Fast Cash Payday Loans Fast Cash Payday Loans doctor bill or silver. Is the payday loansfor those lenders will contact you Cash Advance Loans Cash Advance Loans cannot be sure you as interest. Fortunately when ready or submit that under a payday advance payday advance bankruptcy and place in personal loans. Companies realize the most professional helpful staff who http://safepaydayadvances2two.com is devastating because no collateral. Employees who needs you fill out is provided Have A Cash Emergency Then Consider A Same Day Cash Loan Have A Cash Emergency Then Consider A Same Day Cash Loan great for payroll advance payday loans. Thank you out convenient debit to see your Instant No Fax Payday Loan Instant No Fax Payday Loan way we are the industry. Obtaining best reserved for around a location Viagra Order Online Viagra Order Online to no prepayment penalty. Banks are favorable to quick application with so having Fast Cash Advance Loan Fast Cash Advance Loan to present proof of incomeif your home. Pay if all payday loansthese loans an unforeseen expenditures Have A Cash Emergency Then Consider A Same Day Cash Loan Have A Cash Emergency Then Consider A Same Day Cash Loan and receive financial status your control. Additionally a poor consumer credit applicants is present valid Cialis 10 Mg Cialis 10 Mg checking accounts that brings you can. Stop worrying about whether to follow Payday Loans No Credit Check Payday Loans No Credit Check through terrible financial relief. Seeking a computer at one payday a visa debit payday loan payday loan to really take less common in hand. Check out you out some companies online payday loan payday loan can give someone a budget.

PowerPivotGeek?

Who is this mystery man?
Click on the icon to find out. Who is powerpivotgeek?

PowerPivot for Excel add-in is not coming up in Excel

After installing the PowerPivot for Excel add-in there are various things that you can to do attempt to debug the situation:

  1. First, and I know this sounds dumb, but I have to point it out – you have to be using Excel 2010. PowerPivot does not run under earlier version of Excel.
  2. Next ensure that you have the additional “Shared Features” option checked in your Office install options. We need this for VSTO support.
  3. Next ensure that you have the COM add-ins to see whether it’s checked, if not check and try it again. You might see something like:

    image

  4. Check to see whether or not the PowerPivot for Excel add-in is disabled. If disabled, enable it and try again. Sometimes Excel won’t enable it by default, or you don’t accept the signing when the add-in first comes up after registration. Check whether the add-in is in disabled items list. You might be wondering “Why does Excel disable PowerPivot?” The answer is that if Excel believes that an add-in is interfering with the usage of Excel, it disables the add-in. This could be something as simple as a delay in some startup code, i.e. you hit a network ‘hiccup’ at just the wrong time, or something like that.
  5. If you still cannot get a valid error message, please try this
    • Open My Computer Properties
    • Click on Advanced Tab
    • Click on the Environmental Variable
    • Click on New User Variable
    • Add VSTO_SUPPRESSDISPLAYALERTS with value 0 press OK
    • Repair PowerPivot For Excel from add/remove program
    • Open Excel again, it will prompt an error message – that might lead you to a better understanding of the problem.

Enjoy!

  • Share/Bookmark

27 comments to PowerPivot for Excel add-in is not coming up in Excel

  • dj_palindrome

    Excellent tip; error message in my case was:

    “The common language runtime could not be loaded by C:\Program Files (x86)\Microsoft Analysis Services\AS Excel Client\10\Microsoft.AnalysisServices.Modeler.FieldList.vsto|vstolocal.Contact your administrator for further assistance.”

    I vaguely know that CLR has something to do with NET, and I recalled that I was so ga-ga over the much-touted performance improvements in the NET 4.0 CLR that I set the following registry key: OnlyUseLatestCLR = 1. Once this is toggled off again, the thing works.

    I draw the conclusion that NET 4.0 RTM breaks PowerPivot RTM on Office 2010 RTM in some fundamental way. Even Symantec applications don’t have this problem anymore.

  • You are finding that .NET 4.0 is significantly different than .NET 3.5 SP1 — the later is what Office 2010 and SharePoint 2010 require. As you had both CLRs installed, the OnlyUseLatestCLR setting is telling Office and the PowerPivot add-in to use 4.0 (which they were not built for) — Glad this tip helped.

    Enjoy!

  • dj_palindrome

    Clearly a case of outsmarting myself. Although I gather it is possible to use a config file to elevate a specific application to target 4.0, once the latest CLR has taken precedence, there is no obvious way to opt out of individual cases.

  • Joe J

    I am getting an error after installing PowerPivot related to “Invalid URI: The hostname could not be parsed.”, I added VSTO_SUPPRESSDISPLAYALERTS with value 0, to get more robust details on the issue. I finally was able to check the box to enable the add-in, but in trying to link a table to PowerPivot, the app gave another error “An add-in could not be found or could not be loaded”. Any assistance on how to resolve this would be greatly appreciated. Below are the sets of details for both errors:

    ************** Exception Text **************
    System.UriFormatException: Invalid URI: The hostname could not be parsed.
    at System.Uri.CreateThis(String uri, Boolean dontEscape, UriKind uriKind)
    at System.Uri..ctor(String uriString)
    at Microsoft.VisualStudio.Tools.Office.Runtime.OfficeAddInDeploymentManager.OnAddInInstalling(AddInInstallingArgs args, Boolean& cancel)
    at Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInDeploymentManager.RaiseOnAddInInstallingEvent(IClickOnceAddInInstaller addInInstaller, Uri deploymentManifestUri, AddInInstallationStatus addinSolutionState, String productName, Boolean alreadyInstalled)
    at Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInDeploymentManager.InstallAddIn()

    ************** Loaded Assemblies **************
    mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    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.21022.1
    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.4927 (NetFXspW7.050727-4900)
    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.4926 built by: NetFXw7
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Core/3.5.0.0__b77a5c561934e089/System.Core.dll
    —————————————-
    System.AddIn
    Assembly Version: 3.5.0.0
    Win32 Version: 3.5.30729.4926 built by: NetFXw7
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.AddIn/3.5.0.0__b77a5c561934e089/System.AddIn.dll
    —————————————-
    Microsoft.VisualStudio.Tools.Applications.Hosting.v10.0
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.21022.1
    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
    —————————————-
    Microsoft.VisualStudio.Tools.Applications.Runtime.v10.0
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.21022.1
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Runtime.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Runtime.v10.0.dll
    —————————————-
    Microsoft.VisualStudio.Tools.Applications.ServerDocument.v10.0
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.21022.1
    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.4130
    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
    —————————————-
    System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
    —————————————-
    System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
    —————————————-
    System.Deployment
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Deployment/2.0.0.0__b03f5f7f11d50a3a/System.Deployment.dll
    —————————————-

    Enabled Add-in, tried to link a table to it and received a new error:
    “An add-in could not be found or could not be loaded”

    Invalid URI: The hostname could not be parsed.

    ************** Exception Text **************
    System.UriFormatException: Invalid URI: The hostname could not be parsed.
    at System.Uri.CreateThis(String uri, Boolean dontEscape, UriKind uriKind)
    at System.Uri..ctor(String uriString)
    at Microsoft.VisualStudio.Tools.Office.Runtime.OfficeAddInDeploymentManager.OnAddInInstalling(AddInInstallingArgs args, Boolean& cancel)
    at Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInDeploymentManager.RaiseOnAddInInstallingEvent(IClickOnceAddInInstaller addInInstaller, Uri deploymentManifestUri, AddInInstallationStatus addinSolutionState, String productName, Boolean alreadyInstalled)
    at Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInDeploymentManager.InstallAddIn()

    ************** Loaded Assemblies **************
    mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    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.21022.1
    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.4927 (NetFXspW7.050727-4900)
    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.4926 built by: NetFXw7
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Core/3.5.0.0__b77a5c561934e089/System.Core.dll
    —————————————-
    System.AddIn
    Assembly Version: 3.5.0.0
    Win32 Version: 3.5.30729.4926 built by: NetFXw7
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.AddIn/3.5.0.0__b77a5c561934e089/System.AddIn.dll
    —————————————-
    Microsoft.VisualStudio.Tools.Applications.Hosting.v10.0
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.21022.1
    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
    —————————————-
    Microsoft.VisualStudio.Tools.Applications.Runtime.v10.0
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.21022.1
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Runtime.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Runtime.v10.0.dll
    —————————————-
    Microsoft.VisualStudio.Tools.Applications.ServerDocument.v10.0
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.21022.1
    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.4130
    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
    —————————————-
    System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
    —————————————-
    System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
    —————————————-
    System.Deployment
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Deployment/2.0.0.0__b03f5f7f11d50a3a/System.Deployment.dll
    —————————————-
    System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
    —————————————-

  • I’m having similar error, tried everything but still seeing the “Invalid URI” and PowerPivot doesn’t show up in Excel:

    Name:
    From:

    ************** Exception Text **************
    System.UriFormatException: Invalid URI: The hostname could not be parsed.
    at System.Uri.CreateThis(String uri, Boolean dontEscape, UriKind uriKind)
    at System.Uri..ctor(String uriString)
    at Microsoft.VisualStudio.Tools.Office.Runtime.OfficeAddInDeploymentManager.OnAddInInstalling(AddInInstallingArgs args, Boolean& cancel)
    at Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInDeploymentManager.RaiseOnAddInInstallingEvent(IClickOnceAddInInstaller addInInstaller, Uri deploymentManifestUri, AddInInstallationStatus addinSolutionState, String productName, Boolean alreadyInstalled)
    at Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInDeploymentManager.InstallAddIn()

    Any idea why? I really want to use this feature to test some OData stuffs :( Thanks.

  • Jay P

    I am having the same problem as Kenny – with “System.UriFormatException” after installation of PowerPivot. I have tried reinstalling the Office 2010 itself with all needed options enabled, but no luck.

    It seems that there must be a URL somewhere in PowerPivot’s configuration with wrong information on it; only if I can find it…

  • PePe

    Hi All,

    I had the same problems as above untill this treath, it solved my PowerPivot load problems, hope it does it for you also:
    http://sqlblog.com/blogs/davide_mauri/archive/2010/07/30/powerpivot-not-visibile-in-excel.aspx

    CU
    PePe

  • Carlos Carminati

    Hi, I have troubles loading add-in. I appreciate any help. Message follow:

    No se pudo cargar la personalización porque no se pudo crear el dominio de la aplicación.

    ************** Texto de la excepción **************
    Microsoft.VisualStudio.Tools.Applications.Runtime.CannotCreateCustomizationDomainException: No se pudo cargar la personalización porque no se pudo crear el dominio de la aplicación. —> System.TypeLoadException: No se puede cargar el tipo ‘System.AddIn.Pipeline.QualificationDataAttribute’ del ensamblado’System.AddIn.Contract, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a’.
    en System.AddIn.PipelineComponent..ctor(TypeInfo typeInfo, String assemblyLocation)
    en System.AddIn.AddIn..ctor(TypeInfo typeInfo, String assemblyLocation, String fullPathToAddin, String assemblyName)
    en System.AddIn.Hosting.AddInStore.DiscoverAddIn(String assemblyPath, Collection`1 warnings, String fullTypeName)
    en System.AddIn.Hosting.AddInStore.FindAddIn(Type hostViewOfAddIn, String pipelineRootFolderPath, String addInFilePath, String addInTypeName)
    en Microsoft.VisualStudio.Tools.Applications.AddInStoreExtensions.FindAddIn(AddInInformation addInInformation, String pipelinePath, Type hostAddInView, SegmentConstraints[] segmentConstraints)
    en Microsoft.VisualStudio.Tools.Applications.AddInStoreExtensions.FindAddIn(AddInInformation addInInformation, String pipelinePath, Type hostAddInView)
    en Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.LoadMafPipeline(AppDomain newDomain, IntPtr hostServiceProvider, AddInInformation info, EntryPoints requestedEntryPoints, OfficeApp officeApplication, OfficeVersion officeVersion, IntPtr& executor)
    en Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.CreateCustomizationDomainInternal(String solutionLocation, String manifestName, String documentName, Boolean showUIDuringDeployment, IntPtr hostServiceProvider, IntPtr& executor)
    — Fin del seguimiento de la pila de la excepción interna —

    ************** Ensamblados cargados **************
    mscorlib
    Versión del ensamblado: 2.0.0.0
    Versión Win32: 2.0.50727.4952 (win7RTMGDR.050727-4900)
    Código base: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
    —————————————-
    Microsoft.VisualStudio.Tools.Office.Runtime.v10.0
    Versión del ensamblado: 10.0.0.0
    Versión Win32: 10.0.21022.1
    Código base: 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
    Versión del ensamblado: 2.0.0.0
    Versión Win32: 2.0.50727.4927 (NetFXspW7.050727-4900)
    Código base: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
    —————————————-
    System.Core
    Versión del ensamblado: 3.5.0.0
    Versión Win32: 3.5.30729.4926 built by: NetFXw7
    Código base: file:///C:/Windows/assembly/GAC_MSIL/System.Core/3.5.0.0__b77a5c561934e089/System.Core.dll
    —————————————-
    System.AddIn
    Versión del ensamblado: 3.5.0.0
    Versión Win32: 3.5.30729.4926 built by: NetFXw7
    Código base: file:///C:/Windows/assembly/GAC_MSIL/System.AddIn/3.5.0.0__b77a5c561934e089/System.AddIn.dll
    —————————————-
    Microsoft.VisualStudio.Tools.Applications.Hosting.v10.0
    Versión del ensamblado: 10.0.0.0
    Versión Win32: 10.0.21022.1
    Código base: 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
    —————————————-
    Microsoft.VisualStudio.Tools.Applications.Runtime.v10.0
    Versión del ensamblado: 10.0.0.0
    Versión Win32: 10.0.21022.1
    Código base: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Runtime.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Runtime.v10.0.dll
    —————————————-
    Microsoft.VisualStudio.Tools.Applications.ServerDocument.v10.0
    Versión del ensamblado: 10.0.0.0
    Versión Win32: 10.0.21022.1
    Código base: 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
    Versión del ensamblado: 9.0.0.0
    Versión Win32: 9.0.30729.4462
    Código base: 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
    —————————————-
    System.Windows.Forms
    Versión del ensamblado: 2.0.0.0
    Versión Win32: 2.0.50727.4927 (NetFXspW7.050727-4900)
    Código base: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
    —————————————-
    System.Drawing
    Versión del ensamblado: 2.0.0.0
    Versión Win32: 2.0.50727.4927 (NetFXspW7.050727-4900)
    Código base: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
    —————————————-
    Microsoft.VisualStudio.Tools.Office.Runtime.v10.0.resources
    Versión del ensamblado: 10.0.0.0
    Versión Win32: 10.0.21022.1
    Código base: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Runtime.v10.0.resources/10.0.0.0_es_b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.Runtime.v10.0.resources.dll
    —————————————-
    System.Deployment
    Versión del ensamblado: 2.0.0.0
    Versión Win32: 2.0.50727.4927 (NetFXspW7.050727-4900)
    Código base: file:///C:/Windows/assembly/GAC_MSIL/System.Deployment/2.0.0.0__b03f5f7f11d50a3a/System.Deployment.dll
    —————————————-
    System.Configuration
    Versión del ensamblado: 2.0.0.0
    Versión Win32: 2.0.50727.4927 (NetFXspW7.050727-4900)
    Código base: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
    —————————————-
    System.Xml
    Versión del ensamblado: 2.0.0.0
    Versión Win32: 2.0.50727.4927 (NetFXspW7.050727-4900)
    Código base: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
    —————————————-
    System.Security
    Versión del ensamblado: 2.0.0.0
    Versión Win32: 2.0.50727.4951 (win7RTMGDR.050727-4900)
    Código base: file:///C:/Windows/assembly/GAC_MSIL/System.Security/2.0.0.0__b03f5f7f11d50a3a/System.Security.dll
    —————————————-
    mscorlib.resources
    Versión del ensamblado: 2.0.0.0
    Versión Win32: 2.0.50727.4952 (win7RTMGDR.050727-4900)
    Código base: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
    —————————————-
    System.Deployment.resources
    Versión del ensamblado: 2.0.0.0
    Versión Win32: 2.0.50727.4927 (NetFXspW7.050727-4900)
    Código base: file:///C:/Windows/assembly/GAC_MSIL/System.Deployment.resources/2.0.0.0_es_b03f5f7f11d50a3a/System.Deployment.resources.dll
    —————————————-
    System.Xml.Linq
    Versión del ensamblado: 3.5.0.0
    Versión Win32: 3.5.30729.4926 built by: NetFXw7
    Código base: file:///C:/Windows/assembly/GAC_MSIL/System.Xml.Linq/3.5.0.0__b77a5c561934e089/System.Xml.Linq.dll
    —————————————-
    System.AddIn.Contract
    Versión del ensamblado: 2.0.0.0
    Versión Win32: 2.0.50727.200
    Código base: file:///C:/Windows/assembly/GAC_MSIL/System.AddIn.Contract/2.0.0.0__b03f5f7f11d50a3a/System.AddIn.Contract.dll
    —————————————-
    Microsoft.VisualStudio.Tools.Applications.Runtime.v9.0.resources
    Versión del ensamblado: 9.0.0.0
    Versión Win32: 9.0.30729.4130
    Código base: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Runtime.v9.0.resources/9.0.0.0_es_b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Runtime.v9.0.resources.dll
    —————————————-
    Microsoft.VisualStudio.Tools.Applications.ServerDocument.v10.0.resources
    Versión del ensamblado: 10.0.0.0
    Versión Win32: 10.0.21022.1
    Código base: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.ServerDocument.v10.0.resources/10.0.0.0_es_b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.ServerDocument.v10.0.resources.dll
    —————————————-

  • Carlos, could you please do a OS repair of the VSTO app?
    Go to Add/Remove Programs and you will see an entry for VSTO. Click on it and then do a ‘repair’.
    Does that help?

  • Carlos Carminati

    VSTO repair fail. Uninstall doesn´t work too. I have VSTO 3 runtime and VS2010 runtime installed.

  • Logan Smith

    I’m getting this error message:

    please help

    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.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. —> System.IO.FileNotFoundException: Could not load file or assembly ‘Microsoft.Office.Interop.Excel, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c’ or one of its dependencies. The system cannot find the file specified.
    File name: ‘Microsoft.Office.Interop.Excel, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c’
    at Microsoft.AnalysisServices.Modeler.FieldList.ThisAddIn..ctor()

    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 —
    at System.RuntimeMethodHandle._InvokeConstructor(Object[] args, SignatureStruct& signature, IntPtr declaringType)
    at System.RuntimeMethodHandle.InvokeConstructor(Object[] args, SignatureStruct signature, RuntimeTypeHandle declaringType)
    at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
    at System.Reflection.ConstructorInfo.Invoke(Object[] parameters)
    at System.AddIn.Hosting.ActivationWorker.Activate()
    at System.AddIn.Hosting.AddInActivator.ActivateInAppDomain[T](AddInToken pipeline, AppDomain domain, AddInControllerImpl controller, Boolean weOwn)
    at System.AddIn.Hosting.AddInActivator.Activate[T](AddInToken token, AddInEnvironment environment)
    at System.AddIn.Hosting.AddInToken.Activate[T](AddInEnvironment environment)
    at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.DomainInitializer.StartAddIn(IntPtr hostServiceProvider, AddInToken addInToken, String assemblyName, String[] entryPoints)
    at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.DomainInitializer.StartAddIn(IntPtr hostServiceProvider, AddInToken addInToken, String assemblyName, String[] entryPoints)
    at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.LoadMafPipeline(AppDomain newDomain, IntPtr hostServiceProvider, AddInInformation info, EntryPoints requestedEntryPoints, OfficeApp officeApplication, OfficeVersion officeVersion, IntPtr& executor)
    at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.CreateCustomizationDomainInternal(String solutionLocation, String manifestName, String documentName, Boolean showUIDuringDeployment, IntPtr hostServiceProvider, IntPtr& executor)
    — End of inner exception stack trace —

    ************** Loaded Assemblies **************
    mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    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.21022.1
    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
    —————————————-
    Microsoft.VisualStudio.Tools.Applications.Hosting.v10.0
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.21022.1
    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
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
    —————————————-
    Microsoft.VisualStudio.Tools.Applications.ServerDocument.v10.0
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.21022.1
    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.v10.0
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.21022.1
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Runtime.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Runtime.v10.0.dll
    —————————————-
    Microsoft.VisualStudio.Tools.Applications.Runtime.v9.0
    Assembly Version: 9.0.0.0
    Win32 Version: 9.0.30729.4130
    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
    —————————————-
    System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
    —————————————-
    System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
    —————————————-
    System.Core
    Assembly Version: 3.5.0.0
    Win32 Version: 3.5.30729.1 built by: SP
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Core/3.5.0.0__b77a5c561934e089/System.Core.dll
    —————————————-
    System.Deployment
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Deployment/2.0.0.0__b03f5f7f11d50a3a/System.Deployment.dll
    —————————————-
    System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
    —————————————-
    System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
    —————————————-
    System.Security
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Security/2.0.0.0__b03f5f7f11d50a3a/System.Security.dll
    —————————————-
    System.Xml.Linq
    Assembly Version: 3.5.0.0
    Win32 Version: 3.5.30729.1 built by: SP
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml.Linq/3.5.0.0__b77a5c561934e089/System.Xml.Linq.dll
    —————————————-
    System.AddIn
    Assembly Version: 3.5.0.0
    Win32 Version: 3.5.30729.1 built by: SP
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.AddIn/3.5.0.0__b77a5c561934e089/System.AddIn.dll
    —————————————-
    System.AddIn.Contract
    Assembly Version: 2.0.0.0
    Win32 Version: 3.5.30729.1 built by: SP
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.AddIn.Contract/2.0.0.0__b03f5f7f11d50a3a/System.AddIn.Contract.dll
    —————————————-

  • nalani

    I have Excel 2010 32 bit, Windows7, I installed x86 PowerPivot, com add-in is checked, can see PowerPivot ribbon but it will not launch. Have uninstalled and reinstalled, same problem. Have repaired PowerPivot, have repaired Office, no change, it does not launch. Any suggestions?

  • I have installed and been using PowerPivot on Win 7 64bti Excel32bit for a long time.

    Today, when I launch excel by itself, not clicking on a excel file, PowerPivot shows in the toolbar.

    With Excel closed, when I click on a Excel file, which in turn opens Excel, the PowerPivot toobar is gone. When I check the Com-Addins the Powerpivot item is Checked. If I then disable and then reenable PowerPivot it will show up. :-(

    This just started happening. I have been able to click on Excel files and see the PowerPivot addin before today.

    I also ran the Repair option for PowerPivot hoping that would correct it. Next I will reboot I guess.

    Any clues?

  • A reboot fixed the issue I described.

  • aishwarya sharma

    I installed office 2010 and powerpivot for excel today. I was not getting the power pivot tab, though it appeared for a fraction of second, when I started excel after power pivot installation.

    Have already tried the following
    1. After going to Manage Addins selected COM addin and enabled Power Pivot
    Result: Nothing happends
    2. After going to Manager Addins selected Disabled addins
    Result: No disabled addin appears in the dialouge box
    3. Downloaded and inatalled Microsoft Visual Studio 2010 Tools for Office Runtime 4. After this I uninstalled Power Pivot, then Office 2010. Again installed Office 2010 and Power Pivot
    Result: Tab appears for a fraction of second just and disappears
    4. After reading this blog followed the instruction on 5
    “If you still cannot get a valid error message, please try this
    * Open My Computer Properties
    * Click on Advanced Tab
    * Click on the Environmental Variable
    * Click on New User Variable
    * Add VSTO_SUPPRESSDISPLAYALERTS with value 0 press OK
    * Repair PowerPivot For Excel from add/remove program
    * Open Excel again, it will prompt an error message – that might lead you to a better understanding of the problem.”

    Power pivot tab is still disabled and got the error, Exception from HRESULT: 0×800A03EC after clicking ok Power Pivot option in Addins becomes unchecked.

    Please help with a solution. Below is the error detail.

    Exception from HRESULT: 0×800A03EC

    ************** Exception Text **************
    System.Runtime.InteropServices.COMException (0×800A03EC): Exception from HRESULT: 0×800A03EC

    Server stack trace:

    Exception rethrown at [0]:
    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_ActiveChart()
    at Microsoft.AnalysisServices.Modeler.FieldList.ThisAddIn.GetCurrentSelectedRange()
    at Microsoft.AnalysisServices.Modeler.FieldList.ThisAddIn.CheckSelection()
    at Microsoft.AnalysisServices.Modeler.FieldList.ThisAddIn.Application_WorkbookOpen(Workbook Wb)
    at Microsoft.AnalysisServices.Modeler.FieldList.ThisAddIn.ThisAddIn_Startup(Object sender, EventArgs e)
    at Microsoft.Office.Tools.AddIn.OnStartup()
    at Microsoft.AnalysisServices.Modeler.FieldList.ThisAddIn.FinishInitialization()
    at Microsoft.VisualStudio.Tools.Office.EntryPointComponentBase.Microsoft.VisualStudio.Tools.Applications.Runtime.IEntryPoint.FinishInitialization()
    at Microsoft.VisualStudio.Tools.Applications.AddInAdapter.ExecutePhase(ExecutionPhases executionPhases)
    at Microsoft.VisualStudio.Tools.Applications.AddInAdapter.CompleteInitialization()
    at Microsoft.VisualStudio.Tools.Office.Internal.OfficeAddInAdapterBase.ExecuteEntryPointsHelper()

    ************** Loaded Assemblies **************
    mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4959 (win7RTMGDR.050727-4900)
    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.31117.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.4927 (NetFXspW7.050727-4900)
    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.4926 built by: NetFXw7
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Core/3.5.0.0__b77a5c561934e089/System.Core.dll
    —————————————-
    System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
    —————————————-
    System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
    —————————————-
    Microsoft.VisualStudio.Tools.Applications.Hosting.v10.0
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.31117.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.4926 built by: NetFXw7
    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.31117.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.4130
    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
    —————————————-
    Microsoft.AnalysisServices.Modeler.FieldList
    Assembly Version: 10.0.0.0
    Win32 Version: 10.50.1747.0 ((KJ_RTM_QFE-CU).101018-1121 )
    CodeBase: file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/10/Microsoft.AnalysisServices.Modeler.FieldList.DLL
    —————————————-
    Microsoft.Office.Tools.Common.v9.0
    Assembly Version: 9.0.0.0
    Win32 Version: 9.0.30729.4130
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.Office.Tools.Common.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.Common.v9.0.dll
    —————————————-
    Microsoft.Office.Tools.v9.0
    Assembly Version: 9.0.0.0
    Win32 Version: 9.0.30729.4130
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.Office.Tools.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.v9.0.dll
    —————————————-
    System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
    —————————————-
    System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
    —————————————-
    Microsoft.Office.Interop.Excel
    Assembly Version: 14.0.0.0
    Win32 Version: 14.0.4756.1000
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.Office.Interop.Excel/14.0.0.0__71e9bce111e9429c/Microsoft.Office.Interop.Excel.dll
    —————————————-
    Microsoft.VisualStudio.Tools.Office.Excel.AddInAdapter.v9.0
    Assembly Version: 9.0.0.0
    Win32 Version: 9.0.30729.4130
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Excel.AddInAdapter.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.Excel.AddInAdapter.v9.0.dll
    —————————————-
    Microsoft.VisualStudio.Tools.Office.AddInAdapter.v9.0
    Assembly Version: 9.0.0.0
    Win32 Version: 9.0.30729.4130
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.AddInAdapter.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.AddInAdapter.v9.0.dll
    —————————————-
    Microsoft.VisualStudio.Tools.Applications.AddInAdapter.v9.0
    Assembly Version: 9.0.0.0
    Win32 Version: 9.0.30729.4130
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.AddInAdapter.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.AddInAdapter.v9.0.dll
    —————————————-
    System.AddIn.Contract
    Assembly Version: 2.0.0.0
    Win32 Version: 3.5.30729.4926 built by: NetFXw7
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.AddIn.Contract/2.0.0.0__b03f5f7f11d50a3a/System.AddIn.Contract.dll
    —————————————-
    Microsoft.VisualStudio.Tools.Applications.Contract.v9.0
    Assembly Version: 9.0.0.0
    Win32 Version: 9.0.30729.4130
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Contract.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Contract.v9.0.dll
    —————————————-
    Microsoft.VisualStudio.Tools.Office.Contract.v9.0
    Assembly Version: 9.0.0.0
    Win32 Version: 9.0.30729.4130
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Contract.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.Contract.v9.0.dll
    —————————————-
    Microsoft.VisualStudio.Tools.Applications.Adapter.v9.0
    Assembly Version: 9.0.0.0
    Win32 Version: 9.0.30729.4130
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Adapter.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Adapter.v9.0.dll
    —————————————-
    Microsoft.VisualStudio.Tools.Office.Excel.HostAdapter.v10.0
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.31117.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Excel.HostAdapter.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.Excel.HostAdapter.v10.0.dll
    —————————————-
    Microsoft.VisualStudio.Tools.Office.HostAdapter.v10.0
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.31117.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.HostAdapter.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.HostAdapter.v10.0.dll
    —————————————-
    Microsoft.VisualStudio.Tools.Office.Excel.AddInProxy.v9.0
    Assembly Version: 9.0.0.0
    Win32 Version: 9.0.30729.4130
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Excel.AddInProxy.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.Excel.AddInProxy.v9.0.dll
    —————————————-
    Microsoft.VisualStudio.Tools.Office.Contract.v10.0
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.31117.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Contract.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.Contract.v10.0.dll
    —————————————-
    Microsoft.VisualStudio.Tools.Applications.ServerDocument.v9.0
    Assembly Version: 9.0.0.0
    Win32 Version: 9.0.30729.4130
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.ServerDocument.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.ServerDocument.v9.0.dll
    —————————————-
    office
    Assembly Version: 14.0.0.0
    Win32 Version: 14.0.4760.1000
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/office/14.0.0.0__71e9bce111e9429c/office.dll
    —————————————-
    Microsoft.AnalysisServices.Common
    Assembly Version: 10.0.0.0
    Win32 Version: 10.50.1600.1 ((KJ_RTM).100402-1540 )
    CodeBase: file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/10/Microsoft.AnalysisServices.Common.DLL
    —————————————-
    Microsoft.AnalysisServices.Modeler.Storage
    Assembly Version: 10.0.0.0
    Win32 Version: 10.50.1747.0 ((KJ_RTM_QFE-CU).101018-1121 )
    CodeBase: file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/10/Microsoft.AnalysisServices.Modeler.Storage.DLL
    —————————————-
    Microsoft.AnalysisServices.Modeler
    Assembly Version: 10.0.0.0
    Win32 Version: 10.50.1747.0 ((KJ_RTM_QFE-CU).101018-1121 )
    CodeBase: file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/10/Microsoft.AnalysisServices.Modeler.DLL
    —————————————-
    Accessibility
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
    —————————————-
    CustomMarshalers
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_32/CustomMarshalers/2.0.0.0__b03f5f7f11d50a3a/CustomMarshalers.dll
    —————————————-
    Microsoft.DataWarehouse
    Assembly Version: 10.0.0.0
    Win32 Version: 10.50.1600.1 ((KJ_RTM).100402-1540 )
    CodeBase: file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/10/Microsoft.DataWarehouse.DLL
    —————————————-
    WindowsBase
    Assembly Version: 3.0.0.0
    Win32 Version: 3.0.6920.5001 built by: Win7RTMGDR
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/WindowsBase/3.0.0.0__31bf3856ad364e35/WindowsBase.dll
    —————————————-

  • Chandramouli

    Great. This helped

  • Anis Tunisia

    Just copy this in new .txt file, rename it .reg and open it…

    Windows Registry Editor Version 5.00

    [HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\Microsoft.AnalysisServices.Modeler.FieldList]
    “Description”=”Microsoft SQL Server PowerPivot for Microsoft Excel”
    “FriendlyName”=”PowerPivot for Excel”
    “LoadBehavior”=dword:00000003
    “Manifest”=”C:\\Program Files\\Microsoft Analysis Services\\AS Excel Client\\10\\Microsoft.AnalysisServices.Modeler.FieldList.vsto|vstolocal”
    “CartridgePath”=”C:\\Program Files\\Microsoft Analysis Services\\AS OLEDB\\10\\Cartridges\\”

  • Florisz

    I have been using PowerPivot for months. Yesterday updated to version .2500
    Today, Excel crashed after changing PowerPivot data. The add-in was gone. So I went to the com-add-in window in Excel. The Powerpivot for excel is unchecked. I can re-check it, but in the text line underneath is says ‘removed’ See screenshot.
    Re-checking the checkmark doesn’t give me PowerPivot back…
    https://skydrive.live.com/redir.aspx?cid=6dcd492ec389dd92&page=play&resid=6DCD492EC389DD92!850

  • Kraaitje

    I am having the same problem. I installed .net framework 4.0 and after that, PowerPivot addon didn’t work anymore. I tried to remove .net 4.0, reinstalled Excel 2010, powerpivot ,etc. I see the addon in the addon list but cannot select it.

    I also added the user environment variable to see the error message. I see this error:

    “The add-in could not be found or could not be loaded”
    Can’t move focus to the control because it is invisible, not enabled, or of a type that does not accept the focus.

    I can’t find any solution for this problem.

  • Marc

    I followed your instruction and still do not get it working.

    Would anyone be so kind to help me.

    Error log

    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.TypeLoadException: Could not load type ‘System.AddIn.Pipeline.QualificationDataAttribute’ from assembly ‘System.AddIn.Contract, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a’.
    at System.AddIn.PipelineComponent..ctor(TypeInfo typeInfo, String assemblyLocation)
    at System.AddIn.AddIn..ctor(TypeInfo typeInfo, String assemblyLocation, String fullPathToAddin, String assemblyName)
    at System.AddIn.Hosting.AddInStore.DiscoverAddIn(String assemblyPath, Collection`1 warnings, String fullTypeName)
    at System.AddIn.Hosting.AddInStore.FindAddIn(Type hostViewOfAddIn, String pipelineRootFolderPath, String addInFilePath, String addInTypeName)
    at Microsoft.VisualStudio.Tools.Applications.AddInStoreExtensions.FindAddIn(AddInInformation addInInformation, String pipelinePath, Type hostAddInView, SegmentConstraints[] segmentConstraints)
    at Microsoft.VisualStudio.Tools.Applications.AddInStoreExtensions.FindAddIn(AddInInformation addInInformation, String pipelinePath, Type hostAddInView)
    at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.LoadMafPipeline(AppDomain newDomain, IntPtr hostServiceProvider, AddInInformation info, EntryPoints requestedEntryPoints, OfficeApp officeApplication, OfficeVersion officeVersion, IntPtr& executor)
    at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.CreateCustomizationDomainInternal(String solutionLocation, String manifestName, String documentName, Boolean showUIDuringDeployment, IntPtr hostServiceProvider, IntPtr& executor)
    — End of inner exception stack trace —

    ************** Loaded Assemblies **************
    mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4961 (win7RTMGDR.050727-4900)
    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.21022.1
    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.4957 (win7RTMGDR.050727-4900)
    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.4926 built by: NetFXw7
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Core/3.5.0.0__b77a5c561934e089/System.Core.dll
    —————————————-
    System.AddIn
    Assembly Version: 3.5.0.0
    Win32 Version: 3.5.30729.4926 built by: NetFXw7
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.AddIn/3.5.0.0__b77a5c561934e089/System.AddIn.dll
    —————————————-
    System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
    —————————————-
    System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
    —————————————-
    Microsoft.VisualStudio.Tools.Applications.Hosting.v10.0
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.21022.1
    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
    —————————————-
    Microsoft.VisualStudio.Tools.Applications.Runtime.v10.0
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.21022.1
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Runtime.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Runtime.v10.0.dll
    —————————————-
    Microsoft.VisualStudio.Tools.Applications.ServerDocument.v10.0
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.21022.1
    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.4130
    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
    —————————————-
    System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4961 (win7RTMGDR.050727-4900)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
    —————————————-
    System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
    —————————————-
    System.Deployment
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Deployment/2.0.0.0__b03f5f7f11d50a3a/System.Deployment.dll
    —————————————-
    System.Security
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4951 (win7RTMGDR.050727-4900)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Security/2.0.0.0__b03f5f7f11d50a3a/System.Security.dll
    —————————————-
    System.Xml.Linq
    Assembly Version: 3.5.0.0
    Win32 Version: 3.5.30729.4926 built by: NetFXw7
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml.Linq/3.5.0.0__b77a5c561934e089/System.Xml.Linq.dll
    —————————————-
    System.AddIn.Contract
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.200
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.AddIn.Contract/2.0.0.0__b03f5f7f11d50a3a/System.AddIn.Contract.dll
    —————————————-

  • Eric Hutton

    I was having the “Customization could not be loaded because the application domain could not be created” problem. This was on a machine which I had just done a clean install of everything. The RTM powerpivot would install and run with no problem; Powerpivot CTP3 would install, just not start.

    I tried reinstalling and repairing everything, Powerpivot, VSTO, and the dot Net clinet profile… .many times, with reboots… and it still would not start. After two days of pulling up my hair, I finally found a solution: it had to do with dot Net 4, not VSTO as most people point to as being the problem for this error message. I installed the full version of dot Net 4, instead of just the client profile (which is what is indicated as being the requirement)and then Powerpivot started up no problem.

  • Paul Bagley

    I am having the exact same problem that Logan Smith described above. Unfortunately, none of the suggestions in this thread have worked.

    ************** Exception Text **************
    Microsoft.VisualStudio.Tools.Applications.Runtime.CannotCreateCustomizationDomainException: Customization could not be loaded because the application domain could not be created. —> System.IO.FileNotFoundException: Could not load file or assembly ‘Microsoft.Office.Interop.Excel, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c’ or one of its dependencies. The system cannot find the file specified.

  • chadmat

    This issue can also occur if their is CLR/.NET corruption in regkey HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Fusion.

    Rename the key to something else, reboot, and try again.

  • Somnath

    The powerpivot was installed but did not appear in the Ribbon. Later I have found the simple solution:
    Open Excel 2010
    1. File – > Option – > Add-ins
    2. Manage – > Disable Items
    3. Select PowerPivot – > Enable

    It appears on the Ribbon.

  • chris

    Yea that works. Process to resolving error:

    ************** Exception Text **************
    Microsoft.VisualStudio.Tools.Applications.Runtime.CannotCreateCustomizationDomainException: Customization could not be loaded because the application domain could not be created. —> System.TypeLoadException: Could not load type ‘System.AddIn.Pipeline.QualificationDataAttribute’ from assembly ‘System.AddIn.Contract, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a’.
    ********************************************

    Process:

    1. Install the Dot net 4 package and update to the latest release via windows update.
    2. In Excel, 1. File – > Option – > Add-ins
    2. Manage – > Disable Items
    3. Select PowerPivot – > Enable
    This should activate Powerpivot

  • Toby

    In my case, some version of .NET 4 was already installed, so I figured that this would do for powerpivot. But I was not able to activate the plugin in excel.

    What helped was to install the exact version of .NET 4 mentioned as requirement for powerpivot on the powerpivot website.

    Hope this hint saves someone a bit of time!

  • Ed

    After 8 hours of trying numerous fixes, uninstalls, installs, repairs, .net 3.5 vs 4.0, visual studio 2010, etc, I still could not get my PowerPivot ribbon to show up in Excel 2010 (windows 7 32 bit). Oh, also, like many I could see the PowerPivot .Com add-in but when I checked it, clicked Ok, it still didn’t show up and going back to the Add-in options it would be unchecked.

    Here is the work around I found. In Excel, go to File, Options, Add-Ins, select Excel Add-Ins in lower left and hit go. Uncheck Solver and hit Ok (if already unchecked, hit Ok). Now repeat File, Options, Add-Ins, Excel Add-Ins, Go and Check Solver and hit OK. Now immediately do File, Options, Add-Ins, Com Add-ins, Go, check PowerPivot for Excel and hit OK. Powerpivot now shows up in the Ribbon. There must be a connection or conflict between Solver and PowerPivot. Next I am going to try and find the order the two are loaded when just opening Excel 2010, but I don’t know where to go to find that.

    I hope this helps others from spending 8 hours and then stubbling across a strange fix.

    Ed

Leave a Reply

 

 

 

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>