Fix Power Pivot Missing from COM Add-ins in Excel for Microsoft 365
Question details
The user needs to restore Power Pivot in Excel for Microsoft 365 and determine whether its DLL requires replacement.
- Product
- Microsoft Excel for Microsoft 365 — Power Pivot
- Device & OS
- not provided
- Scenario
- The user is checking Excel's add-in settings to enable Power Pivot.
- Observed behavior
- Power Pivot appears under Inactive Application Add-ins but is absent from the COM Add-ins dialog. Opening Microsoft.Office.PowerPivot.ExcelAddin.dll manually produces an invalid add-in error.
In Excel, open File > Account > About Excel and note your Office product, version, and build. The checks below apply to Windows desktop Excel; Power Pivot is not available in Excel for Mac or Excel for the web.
Check Power Pivot availability and Excel's add-in settings
Use this check first to distinguish an unavailable feature from an inactive or disabled add-in.
Open Excel > File > Account and review Product Information. Check Microsoft's official Power Pivot availability guidance for that product; an inactive entry alone does not confirm that the feature is correctly installed.
Go to File > Options > Add-ins. Set Manage to COM Add-ins and click Go. If Microsoft Power Pivot for Excel appears, select its checkbox and click OK.
Return to File > Options > Add-ins, set Manage to Disabled Items, and click Go. If Power Pivot is listed, select it and click Enable. Restart Excel, then check COM Add-ins again.
Repair Microsoft 365 to restore Power Pivot components
Use Office repair when your product supports Power Pivot but it is missing from COM Add-ins.
Reinstall Microsoft 365 or request installation support
Use this option if Power Pivot is still missing after Online Repair and your Office product supports it.
Use WPS Spreadsheet for Everyday Excel Workbook Tasks
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel files, making migration straightforward for everyday workbook editing. It does not repair Microsoft's Power Pivot installation or replace Power Pivot data-model functionality.
Frequently Asked Questions
Why does Power Pivot appear inactive but not show up in COM Add-ins?
Excel may retain an add-in entry even when its registration or installation is incomplete. Check File > Options > Add-ins > Manage: Disabled Items > Go first. If Power Pivot is not disabled and your Office product supports it, repair Microsoft 365.
Does the invalid add-in error mean the Power Pivot DLL is corrupted?
Not necessarily. Opening Microsoft.Office.PowerPivot.ExcelAddin.dll manually is not the supported way to install or enable Power Pivot. Use File > Options > Add-ins > Manage: COM Add-ins > Go, then repair Office if the entry is missing.
Where can I download a replacement Power Pivot DLL?
Obtain replacement components through Microsoft 365 repair or an official Microsoft installer, not a standalone DLL download site. On Windows, select Microsoft 365 under Settings > Apps > Installed apps > Modify to access repair options.
Will removing an Adobe file association fix Power Pivot?
No. A file association controls which application opens a file when you double-click it; it does not register Power Pivot in Excel. Do not use the DLL's icon or associated application as evidence that its contents are damaged.
Can WPS Office run Power Pivot instead of Excel?
WPS Office does not provide Microsoft's Power Pivot add-in and cannot repair its registration. Use WPS Spreadsheet for ordinary Excel-compatible workbook tasks; use a supported Windows desktop Excel installation for Power Pivot data models.
