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

SituationMethod
The workbook will not openFile > Open, select it, arrow next to Open, then Open and Repair
Repair did not workOpen and Repair again and choose Extract Data
The workbook is open but behaving badlyRevert to the last saved version
Recalculation seems to cause the failureSet calculation to Manual, then open the file
You only need the cell dataLink 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

  1. Open Excel and select File > Open.
  2. Go to the folder that has the workbook and select the file once.
  3. Click the arrow next to the Open button.
  4. Select Open and Repair.

Excel then offers two choices.

ChoiceWhat it does
RepairTries to recover as much of the workbook as possible
Extract DataPulls 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.

  1. Select File > Open.
  2. Double-click the name of the workbook that is open.
  3. 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.

  1. Select File > New and choose Blank workbook.
  2. Select File > Options > Formulas.
  3. Under Calculation options, select Manual and select OK.
  4. 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.

This method recovers cell data only, not formulas or formatting.

  1. Select File > Open, go to the folder, right-click the corrupted workbook, select Copy, then select Cancel.
  2. Select File > New > Blank workbook.
  3. In cell A1, type an equals sign, the workbook name without the file extension, and !A1, then press Enter.
  4. If the Update Values box appears, select the corrupted workbook and select OK.
  5. 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

  1. Select cell A1 and copy it.
  2. Select an area starting at A1 that is roughly the size of the original data, then paste.
  3. With the range still selected, copy it again.
  4. 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.

  1. Paste the GetChartValues macro from Microsoft’s page into a module.
  2. Insert a worksheet and rename its tab ChartData.
  3. Select the chart, whether it is embedded or on its own chart sheet.
  4. Run the macro.

The chart’s data then appears on the ChartData sheet.

What each method brings back

MethodBest forKeeps formatting and objects
RepairMost damaged workbooksAs much as can be recovered
Extract DataWhen Repair failsNo, values and formulas only
Manual calculationFailures during recalculationYes, if the file opens
External linkRaw cell valuesNo, data only
Chart macroData behind a chartNo, 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.

ProtectionWhat Microsoft says
Safely Remove HardwareUse it before unplugging a USB drive that has an open file
AutoRecoverCan restore a previous version after a crash or power loss, only if it was turned on
AutoSaveHelps protect changes for Microsoft 365 files stored on OneDrive
Open from the Recent listNot 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

  1. Select File > Save As > Browse.
  2. In the dialog, click the arrow next to Tools and select General Options.
  3. Check Always create backup.

Excel then keeps the previous saved version beside the current one.

Turn on AutoRecover

  1. Select File > Options > Save.
  2. Check Save AutoRecover information every, and enter the minutes.
  3. Set the AutoRecover file location.
  4. Make sure Disable AutoRecover for this workbook only is not checked.

Microsoft lists 10 minutes as the default interval.

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.

Sources

Leave a Reply

Your email address will not be published. Required fields are marked *