File Corruption & Recovery

Recover an Excel File Showing “Data May Have Been Lost”

Adam DavisAdam Davis Nov 20, 2026 869 views

Question details

Recover data from an Excel workbook that shows a data-loss warning and widespread #VALUE! errors after a crash.

Recover an Excel File Showing “Data May Have Been Lost”
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the file picker

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

2
Choose Open and Repair

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

3
Repair or extract data

Select Repair. If that does not work, repeat the process and choose Extract Data to attempt to recover values and formulas.

4
Save the result separately

Inspect the affected cells, then use File > Save As to save any recovered workbook under a new name.

Use Excel Open and Repair on a Copy
Recovery may be incomplete: If manually entered values are missing, formulas cannot recreate them. An intact earlier copy may be needed.
Free Microsoft Office alternative

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.

Open and edit compatible Excel XLSX and XLS filesReview spreadsheet data in a familiar interfaceUse a free, lightweight office suiteMove existing Office documents into a familiar workspace
microsoft office alternative - wps office

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.