Fix Excel Workbooks with Pivot Charts After a Microsoft 365 Update
Question details
Open Excel workbooks containing Pivot Charts and restore the ability to insert charts after a Microsoft 365 update.

- Product
- Microsoft Excel for Microsoft 365
- Device & OS
- Windows
- Scenario
- A user opens a workbook containing Pivot Charts or tries to insert a new chart after an Office update.
- Observed behavior
- Excel reports corrupted content, repair removes the charts, and new charts may fail to insert.
Note your current Windows region, regional format, and display language so you can restore them after testing. Avoid saving a repaired version over the original workbook, because repair may remove its charts.
Test the workbook with US regional and language settings
Use this temporary workaround when the problem began after an update and Windows uses non-English regional settings.
A similar issue was associated with the historical Microsoft 365 service incident MO177791 and affected some non-English regional settings. This workaround may not resolve unrelated workbook corruption.
Close all Excel workbooks and exit Excel before changing Windows settings.
Open Windows Settings > Time & language > Language & region, or Region on some Windows versions. Set the country or region to United States and the regional format to English (United States).
In Settings > Time & language > Language & region, select English (United States) as the Windows display language. Install the language if needed, and sign out and back in if Windows requests it.
Open Excel and try opening the original workbook. Check whether its Pivot Charts appear and whether you can insert a new chart without repairing the file.
Close Excel, then return to Windows Settings > Time & language to restore your original region, regional format, and display language.

Check Excel updates and test without add-ins
Use these checks if the regional settings workaround does not help or if charts also fail in new workbooks.
Work with Excel files in WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel file formats, making it easier to move existing workbooks. It does not fix Microsoft Excel's update issue; check complex Pivot Charts for compatibility when opening a file.

Frequently Asked Questions
Why does Excel remove my Pivot Charts during repair?
Excel's repair process can discard content it cannot read. In the reported update-related issue, this included charts, so avoid overwriting the original file with the repaired version.
Where can I check my Excel version?
Open Excel and go to File > Account > About Excel to see the version and build information.
How do I find out whether an add-in is causing the chart problem?
Press Windows+R, run excel /safe, and test the workbook. If charts work in Safe Mode, check File > Options > Add-ins and disable COM add-ins to investigate.
Can I keep my original Windows language after testing?
Yes. After testing, close Excel and restore your previous settings under Windows Settings > Time & language. Windows may ask you to sign out before a display language change takes effect.
Does WPS Office fix the Microsoft 365 update issue?
No. WPS Office is an alternative for opening supported Excel files; it does not repair Excel itself. Verify that complex Pivot Charts display and behave as expected in WPS Spreadsheet.




