Fix Excel 2016 Chart Corruption and Workbook Save Errors
Question details
The user needs to resolve incorrect chart values, blank buttons, and workbook save errors in Excel 2016.

- Product
- Microsoft Excel 2016
- Device & OS
- Windows; version not provided
- Scenario
- Working with charts and saving workbooks in Excel 2016.
- Observed behavior
- Chart data and buttons display incorrectly, and saving may fail. The same symptoms can occur in a newly created workbook.
Note your current Windows regional format and country settings so you can restore them if needed. Close Excel before changing regional settings, and have a small sample dataset ready for testing.
Check and change the Windows regional format
Try this when chart and save problems also occur in new workbooks and may be related to regional settings.
Open Windows Settings and go to Time & Language > Region, or Time & Language > Language & region, depending on your Windows version.
Check Country or region and Regional format. Choose a regional format appropriate for your language and country; in the reported case, changing the format from English (Sweden) to Swedish (Sweden) resolved the issue.
Reopen Excel 2016, create a chart from sample data, and use File > Save As to save the workbook. Check whether the chart values and buttons display correctly.

Test a new workbook and save a local copy
Use a new workbook to determine whether the issue affects one file or Excel more broadly.
Update or repair Microsoft Office 2016
Try Office maintenance if the issue persists across workbooks after checking regional settings.
Work with Excel charts in WPS Spreadsheets
WPS Office is a free, lightweight Office alternative with a familiar interface. Open compatible Excel workbooks and continue working with spreadsheets as you transition from Microsoft Office; it does not repair Excel 2016 itself.

Frequently Asked Questions
Does a corrupted chart always mean the workbook is damaged?
No. Create a blank workbook through File > New and insert a chart with sample data. If the same issue appears there, regional settings or the Office installation may be involved.
Which regional setting resolved the reported Excel 2016 issue?
Changing the Windows regional format from English (Sweden) to Swedish (Sweden) resolved the reported chart and save problems. Open Settings > Time & Language > Region or Language & region to review your settings.
Will changing the regional format affect other programs?
It can change how dates, numbers, and decimal separators appear across Windows applications. Note your original format before changing it so you can restore it if necessary.
How do I repair Office 2016 if new workbooks have the same problem?
Close Office apps, then open Control Panel > Programs > Programs and Features. Select Microsoft Office 2016, choose Change, and run Quick Repair or Online Repair if available.




