Restore and Enable Power Pivot in Excel 2016
Question details
Enable or restore the Power Pivot add-in in Excel 2016.

- Product
- Microsoft Excel 2016
- Device & OS
- not provided
- Scenario
- The user wants to use Power Pivot but cannot find or enable the add-in.
- Observed behavior
- Power Pivot may be disabled, hidden, or missing from the Excel add-in list.
In Excel, check File > Account for your Office edition and confirm that it supports Power Pivot. Availability depends on the edition and installation.
Enable Power Pivot from COM Add-ins
Use this method when Power Pivot appears in the COM Add-ins list.
In Excel 2016, select File > Options > Add-ins.
In the Manage box, select COM Add-ins and click Go.
Select the checkbox for Microsoft Office Power Pivot and click OK. Look for the Power Pivot tab on the ribbon.

Re-enable Power Pivot from Disabled Items
Use this method if Excel has disabled the add-in.
Check the Office edition and repair a missing add-in
Try these checks if Power Pivot is absent from both add-in lists.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface and Excel format support for an easier move between office suites. It cannot restore Excel's Power Pivot add-in.

Frequently Asked Questions
Where do I turn on Power Pivot in Excel 2016?
Go to File > Options > Add-ins. Select COM Add-ins in the Manage box, click Go, select Microsoft Office Power Pivot, and click OK.
What if Power Pivot is listed under Disabled Items?
Go to File > Options > Add-ins, select Disabled Items in the Manage box, and click Go. Select Power Pivot and click Enable, then check the COM Add-ins list to turn it on.
Why is Power Pivot missing from the add-in list?
Your Office edition may not include Power Pivot, or the installation may need repair. Check the product name under File > Account and consult Microsoft's availability guidance.
Can WPS Office restore the Power Pivot add-in in Excel?
No. Power Pivot is an Excel add-in managed through Excel and the Office installation. WPS Office can open Excel spreadsheets, but it does not restore the add-in.




