How To Fix A Corrupt Excel File That Won’t Open (2026)
If Excel says a workbook is corrupted, or the file will not open at all, you can often still get your data back.
Excel has a built-in repair tool, and Microsoft documents several backup methods for files that repair cannot fix.
The steps below follow Microsoft’s page on repairing a corrupted workbook, starting with the easiest.
Quick answer: which method to use
| Situation | Method |
|---|---|
| The workbook will not open | File > Open, select it, arrow next to Open, then Open and Repair |
| Repair did not work | Open and Repair again and choose Extract Data |
| The workbook is open but behaving badly | Revert to the last saved version |
| Recalculation seems to cause the failure | Set calculation to Manual, then open the file |
| You only need the cell data | Link to the file from a new workbook, then paste as values |
Copy the damaged file to a safe folder first, so you never work on your only copy.
Move the file to a local drive first
Microsoft says that if a disk or network error stops the workbook from opening, you should move it to a local drive first.
That covers files on a USB drive, a network share or a synced folder that has not finished downloading.
Copy the file to your Desktop or Documents folder and try opening that copy.
Method 1: Open and Repair
- Open Excel and select File > Open.
- Go to the folder that has the workbook and select the file once.
- Click the arrow next to the Open button.
- Select Open and Repair.
Excel then offers two choices.
| Choice | What it does |
|---|---|
| Repair | Tries to recover as much of the workbook as possible |
| Extract Data | Pulls out values and formulas only, if Repair fails |
Try Repair first, and use Extract Data only when Repair cannot finish.
When to use Extract Data
Extract Data gives you the numbers and formulas but not the full workbook.
Expect to rebuild formatting, charts and other objects by hand.
Save the recovered result under a new name so you can compare it with the original.
Method 2: Revert to the last saved version
This applies when the workbook is open in Excel and has become unusable.
- Select File > Open.
- Double-click the name of the workbook that is open.
- Select Yes to reopen it.
Microsoft warns that changes made since the last save are discarded.
If you lost changes you never saved, see how to recover an unsaved Excel workbook.
Method 3: Open with calculation set to Manual
Use this when the workbook fails during recalculation.
- Select File > New and choose Blank workbook.
- Select File > Options > Formulas.
- Under Calculation options, select Manual and select OK.
- Select File > Open and double-click the corrupted workbook.
Microsoft says this recovers the data without recalculating the formulas.
Once the data is safe, copy it into a new workbook and set calculation back to Automatic.
If formulas still show text instead of results, see how to fix Excel formulas not calculating.
Method 4: Pull the data in with an external link
This method recovers cell data only, not formulas or formatting.
- Select File > Open, go to the folder, right-click the corrupted workbook, select Copy, then select Cancel.
- Select File > New > Blank workbook.
- In cell A1, type an equals sign, the workbook name without the file extension, and !A1, then press Enter.
- If the Update Values box appears, select the corrupted workbook and select OK.
- If the Select Sheet box appears, choose the sheet and select OK.
Microsoft’s example is =Budget!A1 for a workbook named Budget.
Copy the linked data as values
- Select cell A1 and copy it.
- Select an area starting at A1 that is roughly the size of the original data, then paste.
- With the range still selected, copy it again.
- On the Home tab, select the arrow under Paste and choose Values.
The last step removes the links and keeps only the data, which is what you want to save.
Recover data behind a chart
If a chart is the only thing you can reach, Microsoft documents a macro that extracts the chart’s values.
- Paste the GetChartValues macro from Microsoft’s page into a module.
- Insert a worksheet and rename its tab ChartData.
- Select the chart, whether it is embedded or on its own chart sheet.
- Run the macro.
The chart’s data then appears on the ChartData sheet.
What each method brings back
| Method | Best for | Keeps formatting and objects |
|---|---|---|
| Repair | Most damaged workbooks | As much as can be recovered |
| Extract Data | When Repair fails | No, values and formulas only |
| Manual calculation | Failures during recalculation | Yes, if the file opens |
| External link | Raw cell values | No, data only |
| Chart macro | Data behind a chart | No, chart data only |
If nothing works
Microsoft’s page says third-party recovery software is another option after these methods.
If the file is in OneDrive, open it from the website, since Excel for the web may behave differently from the desktop app.
If Excel itself crashes on many files, repair Office instead; how to repair Microsoft 365 apps on Windows 11 has the steps.
Common causes and how to avoid them
Microsoft’s file corruption page names unplugging a USB drive while a file is open as a common cause of damaged Office files.
Use Safely Remove Hardware in the Windows taskbar before you unplug a drive, and open the hidden icons arrow if the icon is not showing.
| Protection | What Microsoft says |
|---|---|
| Safely Remove Hardware | Use it before unplugging a USB drive that has an open file |
| AutoRecover | Can restore a previous version after a crash or power loss, only if it was turned on |
| AutoSave | Helps protect changes for Microsoft 365 files stored on OneDrive |
| Open from the Recent list | Not for Open and Repair, because those files do not open through the Open dialog box |
Keep a second copy of important workbooks on another drive or in OneDrive, so one damaged file is never your only version.
Always create a backup copy
- Select File > Save As > Browse.
- In the dialog, click the arrow next to Tools and select General Options.
- Check Always create backup.
Excel then keeps the previous saved version beside the current one.
Turn on AutoRecover
- Select File > Options > Save.
- Check Save AutoRecover information every, and enter the minutes.
- Set the AutoRecover file location.
- Make sure Disable AutoRecover for this workbook only is not checked.
Microsoft lists 10 minutes as the default interval.
Related guides
If the file opens but is locked, see how to fix an Excel file locked for editing.
If Excel hangs while the file is open, see how to fix Excel not responding or freezing.