Recover a Corrupted Excel 2016 Workbook That Will Not Open
Question details
Recover accessible data from two corrupted Excel 2016 workbooks and save usable Excel files.

- 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.
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.
Extract data from the damaged workbook
Use Excel's Extract Data option if the repair attempt offers it, even when a standard repair fails.
In Excel, select File > Open > Browse and select a copy of the damaged workbook.
Select the arrow next to Open, then choose Open and Repair.
If Excel offers Extract Data after the repair fails, select it and follow the prompts to retrieve available values or formulas.
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.

Restore an earlier workbook version or backup
Use a previous version when extraction fails or the recovered data is incomplete.
Save a readable workbook from Protected View
Try this only if Excel can display the workbook in Protected View and you trust its source.
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.

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.




