THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Davide Mauri

A place for my thoughts and experiences the Microsoft Data Platform

PowerPivot not visibile in Excel

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=, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.Office.Interop.Excel, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c'
   at Microsoft.AnalysisServices.Modeler.FieldList.ThisAddIn..ctor()

Google (nor Bing Smile) 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 Smile

Published Friday, July 30, 2010 10:49 AM by Davide Mauri
Filed under: ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Clint said:

Thank you! This worked for me. Evidently .NET Progammability Support isn't installed by default.

August 26, 2010 2:43 PM

PePe said:


It worked for me at last!!!!

October 31, 2010 1:51 PM

JG said:

Thank you Davide, this solved my problem.

November 6, 2010 5:16 AM

David said:

Worked perfectly. Thankyou

Almost spent a whole day looking for this.

November 23, 2010 12:07 AM

Vikas said:

Yeah, It worked perfectly. Thanks alot.

November 24, 2010 4:12 AM

Tamil said:

This is very nice post. I was trying fix this issue for more than two weeks on and off. Kudos to your work. I am glad google helped me to find this post.

January 20, 2011 3:27 PM

Maxon said:

Many Thanks buddy,

May 16, 2011 2:56 AM

Judith said:

Thank you so much!  I looked all over the blogs, particularly Microsoft's, and ultimately, this is what enabled the installation.

Thank you very much!

July 27, 2011 11:37 AM

M. Muneer said:

Worked for me also after adding .NET Programmability Support. Thanks.

August 6, 2011 7:52 AM

Rozack said:

Ok this solutions really works. I mean quite a simple thing and no one talks about it.... nor does it feature in google top results...


August 10, 2011 6:33 AM

Yogesh said:

This worked like a charm! Thanks!

August 26, 2011 6:24 PM

Sunil Kadimdiwan said:

Thanks - Adding .NET programming support worked.

October 4, 2011 3:20 PM

prathap.siddavaatam said:

Thanks a bunch, your simple solution worked like a charm :).

March 31, 2012 4:16 PM

Bill said:

YES YES YES!!!! Thank you so much for this article!  This worked perfectly to get PowerPivot up and running.

June 6, 2012 10:06 AM

Vijay said:

Good article, Helped me greatly..

June 6, 2012 11:09 AM

Navin said:

Thanks Man !

It worked perfecto !

June 28, 2012 2:55 AM

Thorsten said:

Thank you very much. Didn't see this error message, but after installing the component you mention I can activate PowerPivot.

July 30, 2012 4:42 AM

wanwimol said:

Thank you so much for this article!  This worked perfectly to get PowerPivot up and running.Thank you som much. Because you are  Helped me PowerPivot It worked.

September 18, 2012 5:45 AM

Rachathanee said:

Thank you so much. Thank you very much. Thank you very much. Because you Helped me.PowerPivot it worked

September 18, 2012 5:47 AM

madone said:

Any ideas if this doesn't work?

October 15, 2012 5:15 PM

Krishna said:

Your are great.. Its works well. Thanks a Lot :)

November 14, 2012 5:34 PM

Frank said:

Worked. Thanks a bunch!

November 25, 2012 11:18 AM

Frankie said:

It works. Thanks very much.

January 1, 2013 2:32 AM

GilbertoH. said:

Hello, Thank you but it didn´t work for me. It was already on.

I suspect that have something to do with the dual installation. I have office 2010 and office 2013 demo running on the same equipment, since powerpivot version is different on those two solutions, maybe that´s the cause.

January 4, 2013 8:58 AM

EJS said:

Thanks, it works!.

May 21, 2013 5:58 PM

DCD said:

Another satisfied customer! But instead of reinstalling Office 2010, I saw that I only had the client portion of .NET 4.0 loaded and installed the full version. After that, I was finally able to load the COM Add-in.

May 24, 2013 10:42 AM

Liliana said:

Many thanks, took days trying to solve this problem and nothing.

November 6, 2013 10:49 PM

Maxime said:

Many thanks... it fixed my issue after I spent many hours on it.

May 20, 2014 1:31 AM

Wojtek said:

Great thanks! It works now !

July 10, 2014 6:29 PM

Leave a Comment


About Davide Mauri

Director of Software Development & Cloud Infrastructure @ Sensoria, an innovative smart garments and wearable company. After more than 15 year playing with the Microsoft Data Platform, with a specific focus on High Performance databases, Business Intelligence, Data Science and Data Architectures, he's now applying all his skills to IoT, defining architectures to crunch numbers, create nice user experiences and provide meaningful insights, all leveraging Microsoft Azure cloud. MVP on Data Platform since 2006 he has a very strong background development and love both the ER model and OO principles. He is also a fan of Agile Methodology and Automation, which he tries to apply everywhere he can, to make sure that "people think, machines do".

This Blog


Privacy Statement