Fix Excel 2016 Drawing XML Repairs That Remove Charts
Question details
The user needs to prevent Excel 2016 from removing charts when it repairs a workbook and recover the missing 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.
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.
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.
In Excel, select File > Account > Update Options > Update Now. If Update Options is unavailable, check Windows Update or contact your Office administrator.
Install the available Office updates and restart Excel. If your organization provided a Microsoft hotfix for this issue, follow its installation instructions.
Select File > Open and open a copy of the workbook from before Excel removed the charts. Check whether Excel still displays a repair message.
Check the affected worksheets for the charts. If they are present, use File > Save As to save the tested workbook under a new name.

Restore an earlier workbook with its charts
Use an earlier version if the repaired workbook has already been saved without charts.
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.

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.




