Fix an Excel Power Pivot Window That Will Not Open
Question details
The user needs to restore the Excel Power Pivot window so they can create data models and calculated columns.
- Product
- Microsoft Excel for Microsoft 365, Power Pivot
- Device & OS
- not provided
- Scenario
- Opening Power Pivot and working with data models in an administrator-managed Microsoft 365 installation.
- Observed behavior
- The Power Pivot window displays an error or does not open correctly. The reported Office installation is outdated, and data-model creation reportedly works in Safe Mode.
In Excel, open File > Account and note the version, build, and update channel under Product Information or About Excel. If your organization manages Office updates, ask IT to confirm the supported build and whether you have permission to update or repair Office.
Update Microsoft 365 to a supported build
Start here when Excel is running an outdated build, especially on a company-managed installation.
Open Excel > File > Account > About Excel and record the version and build number. Share these details with your Microsoft 365 administrator.
If updates are available to you, choose File > Account > Update Options > Update Now. If Update Options is missing or updates are managed by your organization, ask IT to deploy a current supported build for your assigned update channel.
After the update completes, close and reopen Excel. Open the affected workbook, then select Power Pivot > Manage and check whether the window opens and data-model editing works.
Repair the Microsoft 365 installation
Use an Office repair before or after updating if damaged installation components may be preventing Power Pivot from opening.
Use Excel Safe Mode to investigate add-in conflicts
Use this diagnostic check when Excel behaves differently in normal mode and Safe Mode.
Use WPS Spreadsheet for Everyday Excel Workbook Tasks
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel formats, making it easy to move routine workbook editing to WPS. It does not repair Microsoft Excel or replace Power Pivot data-model and DAX functionality; keep those workflows in a supported Excel installation.
Frequently Asked Questions
What should I do if Update Now is missing in Excel?
Check File > Account for update controls. If Update Options is missing or managed by your organization, send your version and build from About Excel to your Microsoft 365 administrator and request an approved update.
How do I enable Power Pivot if its tab is missing?
In normal Excel mode, go to File > Options > Add-ins. Choose COM Add-ins in the Manage list, click Go, select Microsoft Power Pivot for Excel, and click OK. If it is not listed, ask IT to confirm that your Excel edition and installation include Power Pivot.
Does better behavior in Safe Mode prove that an add-in caused the error?
No. Safe Mode also changes startup behavior and limits customizations. It suggests a possible add-in or startup conflict, but you should test nonessential COM add-ins individually in normal mode. Power Pivot may not be available in Safe Mode.
Should I use Quick Repair or Online Repair?
Start with Quick Repair through Control Panel > Programs and Features > Microsoft 365 > Change. If the problem continues, try Online Repair with an internet connection. On a managed computer, have IT approve or perform the repair.
Can WPS Office fix the Power Pivot window or replace its data model?
No. WPS Office does not repair Microsoft 365 and is not a replacement for Power Pivot or DAX workflows. Use it for ordinary Excel-format worksheet editing, and use a supported Microsoft Excel installation for Power Pivot. Do not assume data-model features will work or be preserved when saving through another spreadsheet application.
