Wednesday, 30 September 2015

Start the Power Pivot in Microsoft Excel add-in

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
PowerPivot-26

  • 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.


PowerPivot-27
The ribbon now has a Power Pivot tab
PowerPivot-28

1 comment: