PowerPivot Addin Won’t Load ? You May Need Visual Studio 2010 Tools for Office Runtime

If you have attempted to install the Powerpivot Add-in for Excel 2010 and you notice the PowerPivot tab is not there after install, chances are the addin failed to load.     You may also notice an error along the lines of “runtime error occurred during the loading of the COM add-in”.

In Excel 2013 this is a breeze as its all installed ready to go – although if you do have issues with the 2013 edition, it is likely you could be running Office 2013 Standard edition and not the required Office 2013 Professional edition http://office.microsoft.com/en-us/excel-help/start-powerpivot-in-excel-2013-add-in-HA102837097.aspx.  Get this right, and you shouldn’t need any of the prerequisites required for Excel 2010.

For Excel 2010 you need to first ensure the correct version of the add-in is installed for your flavour of Excel 2010.  So 32 bit version of Excel needs 32 bit Powerpivot add-in and 64 bit Excel needs 64 bit Powerpivot add-in.  If you don’t know check by going to the file menu in Excel 2010, select Help and check the version under About  Microsoft Excel.

excelversion

There are two prerequisites as outlined here http://msdn.microsoft.com/en-us/library/ee210599.aspx.

You will need the Visual Studio 2010 tools for Office runtime.  A good read here explaining how the 32 bit versus 64 bit thing works for operating system v Office v Visual Studio 2010 tools …

http://msdn.microsoft.com/en-us/library/bb608603.aspx

and location to down the Visual studio 2010 tools for office runtime here …

http://www.microsoft.com/en-au/download/details.aspx?id=35594

There is a second prerequisite as outlined here http://msdn.microsoft.com/en-us/library/ee210599.aspx

You must have Microsoft NET Framework 4.0 (http://www.microsoft.com/download/en/details.aspx?id=17718) or, on Windows 8 Microsoft .NET Framework 4.5(http://www.microsoft.com/en-us/download/details.aspx?id=30653).

Once you have downloaded and installed the Visual studio 2010 tools for office runtime, go back into Excel, go to File > Options > select add-ins > select Com add-ins and select the PowerPivot for Excel 2010 add-in again.  This should work.

About AussieBICG

Connect with me here https://au.linkedin.com/in/aussiebicg

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s