File Corruption & Recovery

Fix an Excel Workbook That Opens in Excel 2010 but Appears Corrupted in Microsoft 365

Algirdas JasaitisAlgirdas Jasaitis Nov 20, 2026 869 views

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.

Fix an Excel Workbook That Opens in Excel 2010 but Appears Corrupted in Microsoft 365
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.
Before you start

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.

Solution 1Recommended

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.

1
Update Microsoft Office

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.

2
Open the local copy for repair

Go to File > Open > Browse, select the local workbook copy, and choose Open and Repair from the arrow next to the Open button.

3
Review the repair result

Choose Repair, then open the recovery log from the message Excel displays. Record any removed drawing XML parts, charts, or other components.

4
Save the recovered workbook separately

Use File > Save As to give the repaired workbook a new name, then check its worksheets and charts against the original in Excel 2010.

Update Excel and review the Open and Repair log
Repair may remove charts: A deleted drawing XML part can affect multiple drawing objects or charts. The recovery log identifies what Excel removed, but it may not establish what originally caused the corruption.
Free Microsoft Office alternative

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.

Open and edit supported Microsoft Excel XLS and XLSX filesWork with charts in a familiar spreadsheet interfaceUse a free, lightweight Office alternative for everyday tasksMove compatible spreadsheets between WPS Office and Microsoft Office
QA img-9

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.