Office Settings & Configuration

How to Fix Power Pivot Missing from Excel COM Add-ins

Maira Mehtab Sep 27, 2026 869 views

Question details

The user is unable to find the Power Pivot tool in the Excel COM Add-ins menu and needs to know which Microsoft 365 editions support it and how to restore it.

Product: Microsoft Excel
Device & OS: Windows
Scenario: Attempting to enable the Power Pivot add-in to perform advanced data analysis and create data models in an Excel workbook.
Observed behavior: The Power Pivot option is missing entirely from the COM Add-ins dialog box, preventing the user from enabling the feature.

Before you start

Verify that you are using a Windows desktop version of Excel, as Power Pivot is not supported on Mac or web versions. You should also verify your Microsoft 365 subscription plan, as Power Pivot is typically limited to specific business, enterprise, and perpetual desktop editions.

Solution 1Recommended

Verify Subscription and Enable Power Pivot via Options

Check your Excel product information and manually enable the add-in through the Excel COM Add-ins menu.

Check Product Information

Open Excel and navigate to File > Account. Review the 'Product Information' section to confirm your Microsoft 365 edition and build number.

Open Excel Options

Click on File in the top ribbon, then select Options at the bottom left to open the Excel Options dialog box.

Access COM Add-ins

In the left sidebar, click on Add-ins. At the bottom of the window next to 'Manage', select 'COM Add-ins' from the dropdown menu and click 'Go'.

Enable Power Pivot

Look for 'Microsoft Power Pivot for Excel' in the list. Check the box next to it and click OK to enable the feature on your ribbon.

Subscription Limitations: If Power Pivot is not listed in the COM Add-ins window, your specific Microsoft 365 plan may not support it. Contact your Microsoft 365 administrator if you are using a business account to verify your license.

Solution 2

Repair Your Microsoft Office Installation

Use this solution if your subscription officially supports Power Pivot, but the add-in is still missing, grayed out, or corrupted.

Free Microsoft Office alternative

Try WPS Office for Seamless Data Analysis

If your current Microsoft 365 subscription doesn't include advanced data tools or you frequently experience add-in issues, WPS Office is an excellent lightweight alternative. It provides powerful data analysis features without complex configurations.

1. Download and Install: Download WPS Office for free from the official website and install it on your Windows, Mac, or Linux device.
2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing Excel workbooks securely and with full format compatibility.
3. Use Pivot Tables: Navigate to the Insert tab and click 'PivotTable' to start analyzing your data effortlessly without managing additional add-ins.

Highly compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Free, lightweight, and fast installation process.Built-in pivot tables and data analysis tools available out of the box.Familiar spreadsheet user interface makes switching incredibly easy.

Frequently Asked Questions

Which Microsoft 365 plans include Power Pivot?

Power Pivot is generally included with Microsoft 365 Apps for enterprise, Office 365 E3/E5, and most standalone perpetual versions of Excel (such as Office Professional Plus). It may not be available in standard Personal, Family, or certain Basic business plans.

Can I use Power Pivot on a Mac?

No, Power Pivot is a COM Add-in, which relies on Windows-specific architecture. It is currently not supported on Excel for Mac or Excel for the web.

What should I do if the COM Add-ins button is grayed out?

If the COM Add-ins option is disabled, it may be restricted by your organization's IT group policies, or you may be opening a workbook in Protected View. Try opening a new, blank workbook, or contact your IT administrator.

Office App Problems