How to Install Power Pivot in Excel?

Last Updated : 24 Jun, 2022

Power Pivot is a data modeling technique that lets you create data models, establish relationships, and create calculations. We can work on large data sets, build extensive relationships, and create complex (or simple) calculations using this Power Pivot tool. Power Pivot is one of the three data analysis tools available in Excel, the other two tools are Power View and Power Query.

Microsoft Excel Version - Power Pivot is Included

Power Pivot tool is available as an Add-in for certain versions of Microsoft Excel like 2013,2016,2019,2021 and Microsoft 365.

Microsoft Excel Version - Power Pivot is NOT Included

Office Professional 2016
Office Home & Student 2013
Office Home & Student 2016
Office Home & Business 2013
Office Home & Business 2016
Office for Mac
Office for Android
Office RT 2013
Office Standard 2013
Office Professional 2013
All Office versions older than 2013

Note: The Power Pivot Add-in for Excel 2010 did not ship with Office, but is available for download. This downloaded Add-in works only with Excel 2010, and not with newer versions of Excel.

Microsoft Excel 2010 - Power Pivot - Installation

As mentioned above, the Power Pivot Add-in is not directly available in Microsoft Excel 2010 and the Add-in needs to be downloaded from the Microsoft official website - Click here.

Select the required language and click on the Download option. On the next page select the version (whether 32-bit or 64-bit) that needs to be downloaded based on your system configurations.

Once the required version Add-in is downloaded successfully, double-click on it to start Installation.

Then click on the 'Next>' button, and you will be re-directed to the license agreement screen. In the license agreement screen accept Terms and Conditions and click on the 'Next>' button.

License-agreement-screen — License Agreement

On the next screen click on the 'Install' button and the Installation of Add-in will start.

Installing-program — Begin the Installation

Updating-component-registration — Installation status bar

Once the installation status is completed, click on the 'Finish' button and then the installation of Power Pivot Add-in for Excel 2010 is completed successfully.

Completing-installation — completion of Installation

Now open Microsoft Excel 2010 and the PowerPivot tab will appear.

Powerpivot-tab-appears — PowerPivot tab in Excel

Enabling Power Pivot add-in in Microsoft Excel (Enabling of the add-in in versions later than 2010):

As discussed earlier in this article, the Power Pivot tool is available as Add-in in Microsoft Excel versions 2013, 2016, 2019, 2021, and Microsoft 365. Now let us discuss enabling that Add-in.
Open Microsoft Excel and go to File > Options > Add-Ins.