Pivot Table Issues

Fix Excel Workbooks with Pivot Charts After a Microsoft 365 Update

Maira MehtabMaira Mehtab Nov 14, 2026 868 views

Question details

Open Excel workbooks containing Pivot Charts and restore the ability to insert charts after a Microsoft 365 update.

Fix Excel Workbooks with Pivot 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.
Before you start

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.

Solution 1Recommended

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.

1
Close Excel

Close all Excel workbooks and exit Excel before changing Windows settings.

2
Change regional 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).

3
Set the display language

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.

4
Test the workbook

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.

5
Restore your settings

Close Excel, then return to Windows Settings > Time & language to restore your original region, regional format, and display language.

Test the workbook with US regional and language settings
Check for a service update: A Microsoft 365 administrator can check the Microsoft 365 admin center under Health > Service health for relevant advisories. MO177791 is a historical incident and may not apply to a current issue.
Free Microsoft Office alternative

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.

Open and edit common Microsoft Excel formats, including XLSX and XLSReview spreadsheet data and charts in WPS SpreadsheetUse a familiar interface to ease the move from ExcelWork with a free, lightweight office suite
microsoft office alternative - wps office

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.