Fix an Excel Workbook That Opens in Excel 2010 but Appears Corrupted in Microsoft 365
Question details
Identify why a large workbook opens in Excel 2010 but is reported as corrupted in newer versions, and investigate how to prevent recurring corruption.

- Product
- Microsoft Excel 2010, Excel 2016, and Excel for Microsoft 365
- Device & OS
- not provided
- Scenario
- A workbook of approximately 220 MB contains many charts, some of which may have been duplicated with an add-in.
- Observed behavior
- Excel 2010 opens the workbook, but Excel 2016 and Microsoft 365 report corruption. Repair removes many charts and reports that a drawing XML file was deleted.
Place a copy of the affected workbook on a local drive and keep the original unchanged while testing. Note which Excel version opens the file and whether a chart-duplication add-in was used before the corruption appeared.
Update Excel and review the Open and Repair log
Use this method to recover what Excel can and identify the workbook components reported as damaged.
In Excel, open File > Account > Update Options > Update Now if that option is available. If updates are managed by your organization, ask your administrator to check them.
Go to File > Open > Browse, select the local workbook copy, and choose Open and Repair from the arrow next to the Open button.
Choose Repair, then open the recovery log from the message Excel displays. Record any removed drawing XML parts, charts, or other components.
Use File > Save As to give the repaired workbook a new name, then check its worksheets and charts against the original in Excel 2010.

Test the chart-duplication add-in
Use a controlled test to check whether the add-in or its chart-duplication workflow is associated with recurring corruption.
Isolate problematic charts in the large workbook
Use this approach when the repair log points to drawing content or corruption returns after charts are recreated.
Work with Excel Workbooks in WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Microsoft Excel formats, making it easy to move everyday workbook tasks between suites. It does not fix Excel's corruption diagnosis or guarantee recovery of damaged charts.

Frequently Asked Questions
Why does Excel repair delete my charts?
Excel may remove damaged drawing or chart components to open the workbook. Check the recovery log linked from the repair message to see which parts were removed.
Does opening successfully in Excel 2010 mean the workbook is healthy?
Not necessarily. Different Excel versions can handle or validate workbook content differently. Test a local copy in the affected version and review its repair log.
How can I tell whether a chart add-in caused the corruption?
On Windows, review File > Options > Add-ins, disable the relevant add-in through the Manage controls, and compare controlled chart-duplication tests with and without it. A repeatable difference is a useful lead, not conclusive proof.
Can a 220 MB workbook cause this error?
The file's size and many charts can make the workbook harder to test, but they do not by themselves establish the cause. Use smaller test copies and compare which ones reopen successfully.
Where is Open and Repair in Excel?
In Excel, go to File > Open > Browse, select the workbook, and use the arrow next to Open to choose Open and Repair. Select Repair and review the resulting log.




