Office Settings & Configuration

Restore and Enable Power Pivot in Excel 2016

Kushani NimanthikaKushani Nimanthika Nov 20, 2026 869 views

Question details

Enable or restore the Power Pivot add-in in Excel 2016.

Restore and Enable Power Pivot 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.
Before you start

In Excel, check File > Account for your Office edition and confirm that it supports Power Pivot. Availability depends on the edition and installation.

Solution 1Recommended

Enable Power Pivot from COM Add-ins

Use this method when Power Pivot appears in the COM Add-ins list.

1
Open add-in settings

In Excel 2016, select File > Options > Add-ins.

2
Open COM Add-ins

In the Manage box, select COM Add-ins and click Go.

3
Enable Power Pivot

Select the checkbox for Microsoft Office Power Pivot and click OK. Look for the Power Pivot tab on the ribbon.

Enable Power Pivot from COM Add-ins
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLSX and XLS filesUse spreadsheet tools for everyday data analysisNavigate a familiar ribbon-style interfaceUse a lightweight office suite for everyday work
microsoft office alternative - wps office

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.