File Corruption & Recovery

Fix Excel's “Data May Have Been Lost” Workbook Error

John WilsonJohn Wilson Nov 22, 2026 868 views

Question details

The user needs to recover a workbook that reports possible data loss after Excel crashes.

Fix Excel's “Data May Have Been Lost” Workbook Error
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.
Before you start

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.

Solution 1

Use Excel's Open and Repair command

Try this first when the workbook appears damaged after a crash.

1
Find the workbook

In desktop Excel, select File > Open > Browse and locate the affected workbook.

2
Run the repair

Select the file, click the arrow next to Open, and choose Open and Repair. Select Repair when prompted.

3
Extract data if needed

If Repair fails, repeat Open and Repair and choose Extract Data to try to recover values and formulas.

4
Save the result separately

Check the affected cells, then use File > Save As to save the recovered workbook under a new name, preferably as an Excel Workbook (.xlsx).

Recovery may be incomplete: Repair or extraction may not restore all lost data, formatting, or formulas. Check cells that previously showed #VALUE! errors.
Free Microsoft Office alternative

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.

Open and edit compatible Excel .xls and .xlsx workbooksUse familiar spreadsheet tools to review recovered worksheet dataMove existing Office files into a familiar, easy-to-use interfaceGet a free, lightweight alternative for everyday document work
microsoft office alternative - wps office

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.