File Corruption & Recovery

Fix Excel 2016 Drawing XML Repairs That Remove Charts

Phi Hung VoPhi Hung Vo Nov 14, 2026 868 views

Question details

The user needs to prevent Excel 2016 from removing charts when it repairs a workbook and recover the missing charts.

Fix Excel 2016 Drawing XML Repairs That Remove Charts
Product
Microsoft Excel 2016
Device & OS
not provided
Scenario
Opening XLS or XLSM workbooks containing charts that display correctly in another spreadsheet application.
Observed behavior
Excel reports that it repaired drawing XML files, and charts disappear from the workbook.
Before you start

Locate an unmodified copy of the workbook or an earlier version that still contains the charts. Note the drawing XML filenames in Excel's repair report so you can compare the results after updating.

Solution 1Recommended

Update Excel 2016 and retest the original workbook

Use this preferred approach to address an Excel update issue before reopening a workbook that still contains its charts.

1
Check for updates

In Excel, select File > Account > Update Options > Update Now. If Update Options is unavailable, check Windows Update or contact your Office administrator.

2
Install available fixes

Install the available Office updates and restart Excel. If your organization provided a Microsoft hotfix for this issue, follow its installation instructions.

3
Open the unmodified workbook

Select File > Open and open a copy of the workbook from before Excel removed the charts. Check whether Excel still displays a repair message.

4
Verify the charts

Check the affected worksheets for the charts. If they are present, use File > Save As to save the tested workbook under a new name.

Update Excel 2016 and retest the original workbook
Updates may not restore deleted charts: If a repaired workbook was already saved without its charts, updating Excel alone may not bring them back. Test an earlier copy that still contains them.
Free Microsoft Office alternative

View spreadsheet charts with WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for opening Office files. Try WPS Spreadsheets to inspect charts in an unmodified workbook, though it does not fix Excel's repair behavior or guarantee identical chart rendering.

Open and inspect spreadsheet charts in WPS SpreadsheetsCompatible with common Microsoft Excel formats, including XLS and XLSXFamiliar spreadsheet interface for an easier transition from OfficeFree, lightweight office suite
QA img-9

Frequently Asked Questions

Why does Excel say it repaired drawing1.xml?

Excel reports that it changed a drawing component while opening the workbook. Drawing components can contain chart information, so check the affected worksheets for missing charts and retain the repair report.

Will updating Excel restore charts that were already removed?

Not necessarily. If the workbook was saved after Excel removed the charts, open an earlier copy or use Version history in OneDrive or SharePoint to find a version that still contains them.

Will saving the workbook in another spreadsheet application fix it?

It may not. In the reported case, saving through OpenOffice still led to repair messages or missing charts in Excel. Update Excel first and test an unmodified copy.

Where can I update Excel 2016?

In Excel, select File > Account > Update Options > Update Now. If that option is missing, check Windows Update or ask your Office administrator how updates are managed.