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.
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 …
and location to down the Visual studio 2010 tools for office runtime here …
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.