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.o restore the Power Pivot menu, do the following: Go to File Options Add-Ins. In the Manage box, click Disabled Items Go. Select Microsoft Office Power Pivot in Microsoft Excel 2013 and then click Enable.