Recover an Excel File Showing “Data May Have Been Lost”
Question details
Recover data from an Excel workbook that shows a data-loss warning and widespread #VALUE! errors after a crash.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user needs to recover a crashed workbook containing manually entered text and numbers.
- Observed behavior
- Excel displays “File error: Data may have been lost,” and many cells show #VALUE! results.
Make a copy of the damaged workbook and attempt recovery on the copy without overwriting the original. Check whether the file was stored in OneDrive or SharePoint, or whether an earlier copy exists in File History or another backup.
Use Excel Open and Repair on a Copy
Try Excel’s built-in repair tool first to recover as much of the workbook as possible.
In desktop Excel, select File > Open > Browse and locate the copy of the damaged workbook.
Select the file, click the arrow next to Open, and choose Open and Repair.
Select Repair. If that does not work, repeat the process and choose Extract Data to attempt to recover values and formulas.
Inspect the affected cells, then use File > Save As to save any recovered workbook under a new name.

Restore an Earlier Version of the Workbook
Use a version or backup created before the crash if repair does not recover the missing entries.
Try Opening the Workbook in Another Spreadsheet App
Use Excel for the web or LibreOffice to see whether another app can read data that desktop Excel cannot.
Work With Excel Workbooks in WPS Spreadsheet
WPS Office is a free, lightweight Office alternative with a familiar interface. Open compatible Excel workbooks and continue working with spreadsheets as you migrate, while keeping the damaged original separate for recovery.

Frequently Asked Questions
Where is Open and Repair in Excel?
In desktop Excel, go to File > Open > Browse, select the workbook, and choose Open and Repair from the arrow next to the Open button.
Can I recover manually entered values that are missing?
Possibly, if Open and Repair or another app can read them. If the values are no longer in the file, check OneDrive or SharePoint version history, Windows File History, or another backup for an intact copy.
Does #VALUE! always mean the workbook is corrupted?
No. A #VALUE! error can also result from a formula or incompatible input. After a crash and a data-loss warning, inspect the affected cells and compare them with an earlier version before assuming the cause.
What should I do if Excel cannot repair the file?
Try Extract Data from the Open and Repair dialog, check an earlier version, or open a copy in Excel for the web or LibreOffice. Keep the original unchanged if professional recovery may be needed.




