

You will need the Visual Studio 2010 tools for Office runtime. There are two prerequisites as outlined here. 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. So 32 bit version of Excel needs 32 bit Powerpivot add-in and 64 bit Excel needs 64 bit Powerpivot add-in. Get this right, and you shouldn’t need any of the prerequisites required for Excel 2010.įor Excel 2010 you need to first ensure the correct version of the add-in is installed for your flavour of Excel 2010. 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. You may also notice an error along the lines of “runtime error occurred during the loading of the COM add-in”. 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.
