To repair a corrupted Excel file, open Excel, go to File > Open > Browse, select the workbook, click the arrow next to Open and choose Open and Repair, then click Repair. If that fails, run it again and choose Extract Data to rescue values and formulas. You can also set calculation to manual before opening, link to the damaged workbook from a new one to pull its data out, or restore an earlier version from OneDrive or Previous Versions. When Excel's own tools fail or lose sheets and formulas, a file repair tool can rebuild the workbook itself.
Make a copy of the damaged workbook before you try anything, and work on the copy.
Excel's built-in repair options compared
| Method | What you get back | What you can lose |
|---|---|---|
| Open and Repair: Repair | As much of the workbook as Excel can fix | Formatting, charts, named ranges or whole sheets if badly damaged |
| Open and Repair: Extract Data | Cell values, optionally formulas | Formatting, charts, macros, pivot tables |
| Manual calculation | The full workbook, if recalculation was the trigger | Nothing, if it opens |
| External reference link | Values from specific sheets | Formulas, formatting, everything except values |
| Version history / Previous Versions | An earlier, undamaged copy | Changes made since that version |
Method 1: Open and Repair
- Open Excel with a blank workbook.
- Go to File > Open > Browse and select the damaged workbook (single-click, do not open it).
- Click the arrow next to Open and choose Open and Repair.
- Click Repair to recover as much as possible.
- If Repair fails, repeat the steps and click Extract Data. Choose Recover Formulas to keep formulas where possible, or Convert to Values if that fails.
When Excel finishes, it lists what it repaired or removed, for example "Removed Records: Formula from /xl/worksheets/sheet2.xml part". Read that list carefully, because it tells you exactly what to check. Save the result with File > Save As under a new name.
Method 2: Other tricks worth trying
Set calculation to manual
Sometimes the file is fine but Excel crashes recalculating it. Open a blank workbook, go to Formulas > Calculation Options and choose Manual. Then open the damaged file with File > Open. If it opens, save a copy straight away.
Link to the damaged workbook
If you know the sheet names, you can pull the values out with an external reference, even when Excel will not open the file itself.
- In a new workbook, click cell A1 and type a formula such as
='C:\Reports\[Budget.xlsx]Sheet1'!A1, using the real path, file name and sheet name. - Press Enter. If Excel asks you to find the file, select the damaged workbook.
- Copy A1 across and down to cover the area your data used.
- Select everything, copy, then Paste Special > Values to keep the numbers without the links.
This only recovers values, one sheet at a time, but it can rescue numbers you cannot get any other way.
Restore an earlier version
- OneDrive or SharePoint: right-click the file and choose Version history.
- Previous Versions: right-click the file, choose Properties and open the Previous Versions tab (needs File History or restore points).
- Unsaved workbooks: File > Info > Manage Workbook > Recover Unsaved Workbooks.
Not every Excel error means corruption
"Excel cannot open the file because the file format or file extension is not valid" sometimes means the workbook really is damaged, but it can also mean the extension is wrong, for example a CSV or an old .xls renamed to .xlsx, or a file saved by another program. Our guide to that file format or extension error explains how to tell the difference. Files from email or the internet may also be blocked; right-click, choose Properties and tick Unblock if it is shown, as covered in "the file is corrupt and cannot be opened".
When Excel's repair isn't enough
Excel's repair is designed to get you a file that opens. When a part of the workbook is broken, it often removes that part entirely: a whole sheet, all the formulas on a sheet, or the formatting. Extract Data can lose everything except plain values. That may be acceptable for a simple list, but not for a financial model built on hundreds of formulas.
An .xlsx workbook is a ZIP container with a separate XML part for each sheet, plus shared strings, styles and the list that tells Excel which sheets exist. Damage to the container or to that list can make Excel reject the whole workbook even though every sheet is still inside.
Rebuild the workbook with File Repairer
File Repairer rebuilds damaged Excel workbooks rather than stripping them down. It salvages the ZIP container, recovers broken XML and rebuilds the sheet list and the links between parts, recovering sheets, formulas, formatting, tables and images. Older .xls workbooks are repaired and saved as .xlsx, with their formulas kept as working formulas, not just the values.
- Drag the workbook, or a folder of them, into File Repairer and click Repair All.
- Preview the repaired spreadsheet sheet by sheet, with a panel showing what was recovered.
- Save the copy. It is named with " (repaired)" and your original stays exactly as it was.
If a workbook is too damaged to rebuild, Tools > Extract Text & Data pulls out every readable piece of data into a new file. All of this runs on your PC, so confidential spreadsheets are never uploaded. Checking, repairing and previewing are free; saving the repaired workbook needs an Installation Key.
Some limits to know: data that was never written to disk, for example because a save was interrupted, cannot be rebuilt, so some repairs are partial. File Repairer does not remove workbook or sheet passwords, and it does not recover deleted files.
Protecting your workbooks
- Store important workbooks in OneDrive or SharePoint for automatic version history.
- Turn on Always create backup in File > Save As > Browse > Tools > General Options for critical files.
- Avoid working on large workbooks directly from USB sticks or unreliable network drives.
- After Excel repairs a file, save a clean new copy and work from that.
Frequently asked questions
What is the difference between Repair and Extract Data in Excel?
Repair tries to fix the whole workbook so it opens normally. Extract Data is a fallback that pulls out cell values, and optionally formulas, but leaves behind formatting, charts and other objects.
Can I recover formulas from a corrupted .xls file?
Often, yes. Excel's Extract Data can try to recover formulas, and File Repairer converts damaged .xls workbooks to .xlsx with their formulas kept as working formulas.
Why did Excel remove a sheet when it repaired my file?
Excel removes parts it cannot read so the rest of the workbook opens. The sheet's data may still be inside the damaged file, so keep the original and try a deeper repair before giving up on it.
