Yesterday I had to install PowerPivot on my new machine since I would have liked to use it to process some data, but after having succesfully run the installation package, the PowerPivot menu wasn’t visibile in Excel .
Looking in the Event Log for errors I found the following one:
Exception: Customization could not be loaded because the application domain could not be created.
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=18.104.22.168, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.Office.Interop.Excel, Version=22.214.171.124, Culture=neutral, PublicKeyToken=71e9bce111e9429c'
Google (nor Bing ) was able to help me…and after some failed attempt to fix the problem I remembered then when I installed Office 2010 I’ve choose not to install the .NET Programmability Support.
After having installed it (Just run the Office Installation program)
I was finally able to install PowerPivot
So, if you find yourself in the same situation, now you know what to do