THE SQL Server Blog Spot on the Web

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

Davide Mauri

A place for my thoughts and experiences on SQL Server, Business Intelligence and .NET

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=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()

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)

 

image

 

I was finally able to install PowerPivot

 

image


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

Comments

 

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:

THANK YOU!!!

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...

Great!!

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

(required) 
(required) 
Submit

About Davide Mauri

Davide Mauri - MCP, MCAD, MCDBA, MCT, MVP on SQL Server - has worked with SQL Server since version 6.5, and his interests cover the whole platform, from the Relational Engine to Analysis Services, from architecture definition to performance tuning. He also has a strong knowledge of XML, .NET and the Object Oriented Design principles, which allows him to have the correct vision and experience to handle development of complex business intelligence solutions. Having worked as a Microsoft Certified Teacher for many years, Davide is able to pass all his knowledge to his co-workers, allowing his team to deliver high-quality solutions. He currently works as a Mentor for SolidQ and can be found speaking in many Italian and internationals events.

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement