Power PIvot add-in for Excel 2010 will not load

Posted on 2015-01-23
Medium Priority
Last Modified: 2015-02-08
I am having issues installing Power Pivot for Excel 2010.

It is listed in the com Apps list but when enabled from here it won't load it.

I have managed to get the following error message:

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=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'.
   at System.ModuleHandle.ResolveType(Int32 typeToken, RuntimeTypeHandle* typeInstArgs, Int32 typeInstCount, RuntimeTypeHandle* methodInstArgs, Int32 methodInstCount)
   at System.ModuleHandle.ResolveTypeHandle(Int32 typeToken, RuntimeTypeHandle[] typeInstantiationContext, RuntimeTypeHandle[] methodInstantiationContext)
   at System.Reflection.Module.ResolveType(Int32 metadataToken, Type[] genericTypeArguments, Type[] genericMethodArguments)
   at System.Reflection.CustomAttribute.FilterCustomAttributeRecord(CustomAttributeRecord caRecord, MetadataImport scope, Assembly& lastAptcaOkAssembly, Module decoratedModule, MetadataToken decoratedToken, RuntimeType attributeFilterType, Boolean mustBeInheritable, Object[] attributes, IList derivedAttributes, RuntimeType& attributeType, RuntimeMethodHandle& ctor, Boolean& ctorHasParameters, Boolean& isVarArg)
   at System.Reflection.CustomAttribute.GetCustomAttributes(Module decoratedModule, Int32 decoratedMetadataToken, Int32 pcaCount, RuntimeType attributeFilterType, Boolean mustBeInheritable, IList derivedAttributes)
   at System.Reflection.CustomAttribute.GetCustomAttributes(RuntimeType type, RuntimeType caType, Boolean inherit)
   at System.RuntimeType.GetCustomAttributes(Type attributeType, Boolean inherit)
   at System.Runtime.Remoting.Metadata.RemotingCachedData.GetSoapAttribute()
   at System.Runtime.Remoting.InternalRemotingServices.GetCachedSoapAttribute(Object reflectionObject)
   at System.Runtime.Remoting.SoapServices.GetXmlTypeForInteropType(Type type, String& xmlType, String& xmlTypeNamespace)
   at System.Runtime.Remoting.RemotingServices.DetermineDefaultQualifiedTypeName(Type type)
   at System.Runtime.Remoting.Metadata.RemotingTypeCachedData.get_QualifiedTypeName()
   at System.Runtime.Remoting.Activation.ActivationServices.IsCurrentContextOK(Type serverType, Object[] props, ConstructorCallMessage& ctorCallMsg)
   at System.Runtime.Remoting.Activation.ActivationServices.CreateInstance(Type serverType)
   at System.Runtime.Remoting.Activation.ActivationServices.IsCurrentContextOK(Type serverType, Object[] props, Boolean bNewObj)
   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 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)
   --- End of inner exception stack trace ---

************** Loaded Assemblies **************
    Assembly Version:
    Win32 Version: 2.0.50727.5485 (Win7SP1GDR.050727-5400)
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
    Assembly Version:
    Win32 Version: 10.0.40820.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Runtime.v10.0/
    Assembly Version:
    Win32 Version: 2.0.50727.5485 (Win7SP1GDR.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/
    Assembly Version:
    Win32 Version: 3.5.30729.5420 built by: Win7SP1
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Core/
    Assembly Version:
    Win32 Version: 10.0.40820.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Hosting.v10.0/
    Assembly Version:
    Win32 Version: 3.5.30729.5446 built by: Win7SP1GDR
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.AddIn/
    Assembly Version:
    Win32 Version: 10.0.40820.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.ServerDocument.v10.0/
    Assembly Version:
    Win32 Version: 9.0.30729.5806
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Runtime.v9.0/

I have already:

Confirmed that the correct version of Excel is installed (32 bit, 14.0.7015.1000)
Reinstalled  the full version .net 4
Reinstalled visual studio tools 2010
made sure that all the office 2010 extras are installed and ran repair to make sure.

Any ideas?
Question by:support01
  • 6
  • 3
LVL 27

Expert Comment

ID: 40566395
it seems that the registry files are corrupted.

try uninstalling it, then restart the machine and then re install and hopefully it should work.

Author Comment

ID: 40566643
Thanks, I will give that a go.

Author Comment

ID: 40570230
I'm afraid that didn't work.

I've tried:

Re-installing the software
Completely removing the software and all registry entries using a combination of Revo Uninstaller andCC cleaner and then installing the software again and the problem still persists.

I've also logged on as a different user on the same machine to see if the issue was profile specific and the problem is still there.
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

LVL 27

Expert Comment

ID: 40570247
Ok. in this case, then there is a problem with your Office .NET Programmability Support

when you installed the office, you must have installed through customised option not marking the .NET Programmability Support.

to fix this. follow Easy option.

Uninstall PowerPivot.
Restart the machine.
download Microsoft .Net Framework 4.5 latest from Microsoft link http://download.microsoft.com/download/B/A/4/BA4A7E71-2906-4B2D-A0E1-80CF16844F5F/dotNetFx45_Full_setup.exe

install it.

then check if you  already have the Visual Studio 2010 Tools for Office Runtime  installed in your machine, if you have then you need to uninstall it. and download install a fresh copy from the link below. or if you do not have it already in your machine you download and install it.

then download and install powerpivot again
 restart the machine and then your powerpivot must work.

if it still does not work, check if antivirus setting in your machine is not blocking the .net framework ability to create the 'shadow copy' version of the vsto .dll.

hope this helps.

let me know how did it go.

Author Comment

ID: 40572577
I'm afraid that still hasn't worked, have followed all the steps and even disabled the anti-virus on the pc and the issue is still there.

I think we are going to have to replace this machine as I don't have any more to troubleshoot this, thanks for your help.
LVL 27

Expert Comment

ID: 40572652
before you replace the machine.

can you try unstalling the microsoft office and restart and reinstall it and then instlal powerpivot.  if this last step do not work. then do what you may wish to do.

Author Comment

ID: 40574795
I should have the laptop in front of me on Monday so I'll  try and re-install office before we wipe it.

Accepted Solution

support01 earned 0 total points
ID: 40586042
I have tried reinstalling office and powerpivot and unfortuantely it still won't work.

It's going to be quicker for me to just to wipe the laptop and re-install the software.

Thanks for you help.

Author Closing Comment

ID: 40596676
Couldn't fix so laptop is being wiped,

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question