Installing Power Pivot

Using Excel 2013 or later?  Power Pivot is an Excel add-in.  

• To enable, in the Excel ribbon, go to File, Options, Add-Ins, and select Microsoft Power Pivot for Excel.  
• Click Go.  
• In the pop-up window, select Microsoft Power Pivot and then Enable.  If Microsoft Power Pivot is not an option in the pop-up window, close the pop-up window and select Ok.  

Back in Excel, on the ribbon, you should now have a new Power Pivot tab.  If so, you are all set and ready for the next lesson. 

If the Power Pivot tab is not on the ribbon, on the Data tab, find the green data model icon under Data Tools, as pictured below.  When hovered over, it should say "Go to the Power Pivot Window".  A pop-up will ask if you want to enable data analysis tools.  Agree.  You should now have the Power Pivot tab on the ribbon and are ready to move on to the next lesson.

Since Office 365 updates frequently, differences may exist.  For additional troubleshooting, try this link to Microsoft installation instructions.

Using Excel 2010? You will need to download the Add-in from Microsoft.  Follow this link.

Excel iOS and Online?  Power Pivot tables can be viewed in these Excel versions: no installation required.  However, changes can't be made to the underlying data model in these versions.  

Excel for Mac and Android? Microsoft does not support Power Pivot on these platforms.   Share your voice on the Microsoft user forum.☹️


Prior post: 2 files, 1 Pivot Table: Power Pivot
Next post: Power Pivot Date Table