Fix Excel's “Data May Have Been Lost” Workbook Error
Question details
The user needs to recover a workbook that reports possible data loss after Excel crashes.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A workbook is opened after an Excel crash, potentially in the older Excel 97–2003 format.
- Observed behavior
- Excel displays “File error: data may have been lost,” and previously valid text cells may show #VALUE! errors.
Check the workbook's file extension and note whether the issue occurs in an .xls file, an .xlsx file, or both. Work with a copy of the affected file when testing repairs so you can preserve the original.
Use Excel's Open and Repair command
Try this first when the workbook appears damaged after a crash.
In desktop Excel, select File > Open > Browse and locate the affected workbook.
Select the file, click the arrow next to Open, and choose Open and Repair. Select Repair when prompted.
If Repair fails, repeat Open and Repair and choose Extract Data to try to recover values and formulas.
Check the affected cells, then use File > Save As to save the recovered workbook under a new name, preferably as an Excel Workbook (.xlsx).
Restore an earlier version or copy recoverable worksheets
Use an earlier version if one is available, or move accessible sheets into a new workbook.
Test Excel in Safe Mode and repair Office on Windows
Use this Windows troubleshooting path if multiple workbooks show errors or Excel continues to crash.
Work with Excel-Compatible Files in WPS Spreadsheets
WPS Office is a free, lightweight Office alternative with a familiar interface for opening and editing compatible workbooks. It can help you move existing files into a different spreadsheet environment, though it does not repair Microsoft Excel itself or guarantee recovery of corrupted data.

Frequently Asked Questions
What does “data may have been lost” mean in Excel?
Excel detected a problem while reading the workbook and may not have recovered all of its contents. Check the affected cells and try File > Open > Browse > Open and Repair.
Can I recover cells that now show #VALUE!?
Possibly. Try Open and Repair or open an earlier version through File > Info > Version History if the file is stored in OneDrive or SharePoint. Compare the affected cells; recovery is not guaranteed.
Will saving an .xls file as .xlsx fix corruption?
Saving a recoverable workbook as .xlsx creates a modern-format copy, but it does not restore data already lost. Check the saved copy, and use .xlsm instead if you need to retain macros.
How do I open Excel in Safe Mode?
On Windows, press Windows+R, type excel /safe, and select OK. Then use File > Open to test the workbook.




