File Corruption & Recovery

Recover a Corrupted Excel 2016 Workbook That Will Not Open

John WilsonJohn Wilson Nov 20, 2026 868 views

Question details

Recover accessible data from two corrupted Excel 2016 workbooks and save usable Excel files.

Recover a Corrupted Excel 2016 Workbook That Will Not Open
Product
Microsoft Excel 2016
Device & OS
not provided
Scenario
Two workbooks will not open, and the user needs to retrieve their data and correct damaged cells.
Observed behavior
Open and Repair does not recover the workbooks, although Excel produces a repair log identifying damaged cells.
Before you start

Copy each affected workbook to a different folder or drive and work on the copies. Keep the repair logs available so you can check the affected cells if you recover the sheets.

Solution 1Recommended

Extract data from the damaged workbook

Use Excel's Extract Data option if the repair attempt offers it, even when a standard repair fails.

1
Open the workbook copy

In Excel, select File > Open > Browse and select a copy of the damaged workbook.

2
Start Open and Repair

Select the arrow next to Open, then choose Open and Repair.

3
Extract available data

If Excel offers Extract Data after the repair fails, select it and follow the prompts to retrieve available values or formulas.

4
Check and save the result

Compare the recovered sheets with the repair log, correct any identifiable problems, and use File > Save As to save the result under a new name.

Extract data from the damaged workbook
Recovery may be incomplete: Extract Data may not preserve all formulas, formatting, or workbook features. The repair log can help identify cells to check, but it does not guarantee that all damage has been found.
Free Microsoft Office alternative

Work with Excel files in WPS Spreadsheets

WPS Office is a free, lightweight Office alternative with a familiar interface for opening and editing compatible Excel files. Its format support makes it easier to move existing spreadsheets into WPS, though it does not guarantee recovery of a corrupted workbook.

Open and edit compatible Microsoft Excel XLS and XLSX filesReview and update recovered spreadsheet data in a familiar interfaceMove existing Office documents into a lightweight suiteUse free spreadsheet, document, and presentation tools
microsoft office alternative - wps office

Frequently Asked Questions

What can I do if Open and Repair fails?

If Excel offers Extract Data after the repair attempt, select it to retrieve available values or formulas. Otherwise, look for a previous version, backup, or specialized workbook recovery tool.

How do I find the cells mentioned in the repair log?

If you recover a readable sheet, open the repair log and compare its sheet and cell references with the workbook. Inspect those locations for missing or changed data.

Will enabling editing in Protected View repair the file?

No. Enable Editing only allows changes to a workbook that Excel can already display. Use it only when you trust the file and its source.

Can I restore an earlier version from OneDrive?

If the workbook was stored in OneDrive and version history is available, open the file's Version history in OneDrive and choose an earlier version. Recent changes made after that version may be missing.

Can WPS Office recover a corrupted Excel workbook?

WPS Spreadsheets can open many compatible Excel files, but it is not guaranteed to repair a corrupted workbook. Try Excel's extraction options or an earlier backup if the file cannot be opened.