greg_c used Ask the Experts™

How do I install Powerpivot into MS Excel 2010?

Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Awarded 2010

go to http://www.powerpivot.com/download.aspx

If you don't have Excel 2010, then start with step 1 (prerequisites) and step 2 (download Excel 2010 trial).

Then, or if you already have Excel 2010 installed, follow with step 3 to download the free PowerPivot Add-in. Follow the on-screen instructions to complete the PowerPivot install.

cheers, teylyn

zeshanazizSystem Administrator

If you do not see the PowerPivot tab after you install Office 2010 and PowerPivot for Excel, try the following:
Load the add-in by clicking File, Options, and then Add-ins. In the Add-ins area, click Manage, select COM Add-ins, and click Go. In the COM Add-ins window, select the Microsoft.AnalysisService.Modeler.FieldList.Addin.Integration check box and click OK.
If the add-in does not appear after you completed the above steps, and you are running Windows XP and do not have SP3 installed. You will need to install SP3 in order to use PowerPivot. You can download SP3 from the following location: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=68c48dad-bc34-40be-8d85-6bb4f56f5110 
If the add-in still does not appear and you installed Excel 2010 and PowerPivot only, you will need to install Office Shared Tools also. With the Office Beta, VSTO is installed when Office Shared Tools is installed. If this is the situation that you are encountering, you need to uninstall PowerPivot for Excel and Excel 2010. Next, install Excel 2010 and Office Shared Tools, and then install PowerPivot for Excel.

Most Valuable Expert 2011
Awarded 2010


you forgot to mention that your comment is a verbatim copy of the advice given by AshviniSharma on the MSDN forums, namely http://social.msdn.microsoft.com/Forums/en-NZ/sqlkjpowerpivotforexcel/thread/572168c3-7faf-41a6-88b4-790a9cd223d0

If you use someone else's solution, you need to quote your source. Anything else is considered plagiarism and not welcome at EE.


Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial