Power Pivot in Microsoft Excel 2013 is an add-in you can use to perform powerful data analysis in Excel. The add-in is built into Excel, but by default, it’s not enabled. Here’s how you enable Power Pivot before using it for the first time.
- Go to File > Options > Add-Ins.
In the Manage box, click COM Add-ins> Go
- Check the Microsoft Office Power Pivot in Microsoft Excel 2013 box, and then click OK. If you have other versions of the Power Pivot add-in installed, those versions are also listed in the COM Add-ins list. Be sure to select the Power Pivot add-in for Excel.
The ribbon now has a Power Pivot tab