How to Repair and Recover a Corrupted Excel Workbook

Excel corruption can affect the workbook container, a worksheet, formulas, styles, charts, external links, or macros. Make an untouched archive and use a different duplicate for each method. Opening the file is not proof that its calculations remain trustworthy.

First move: Copy the workbook to a local drive, preserve one source untouched, and run Excel's Open and Repair on a numbered working copy.

1. Separate file damage from storage trouble

1. Record the filename, extension, size, and exact error.
2. Copy it from USB, network, email, or sync storage to a local folder.
3. Open a known-good workbook in Excel.
4. Try the damaged copy on another updated machine if permitted.
5. Check OneDrive or SharePoint version history.

Microsoft recommends moving the workbook to a different hard disk or local disk when a disk or network error prevents opening. If every workbook fails, repair Excel or investigate add-ins rather than changing the source file.

2. Run Open and Repair

1. Start Excel.
2. Select File > Open and browse to the working copy.
3. Select the workbook.
4. Open the arrow beside Open.
5. Choose Open and Repair.
6. Select Repair first.
7. Save the result with a new name.

Repair aims to recover as much workbook data and structure as possible. Do not save the result over the original.

3. Use Extract Data when Repair fails

Return to Open and Repair on a fresh duplicate and select Extract Data. Excel can attempt to extract values and formulas. This is a salvage operation, not a full workbook restoration.

Expect possible loss of formatting, charts, PivotTables, macros, names, validation, and other structures. Save extracted results separately and compare them with reports, exports, or earlier versions before trusting totals.

4. Reduce calculation pressure

A workbook may fail while recalculating complex or damaged dependencies. Microsoft documents opening Excel with calculation set to Manual:

1. Create a blank workbook.
2. Open File > Options > Formulas.
3. Set workbook calculation to Manual.
4. Close the options dialog.
5. Open a fresh copy of the damaged workbook.
6. Save readable sheets before calculating.

Do not switch back to automatic calculation until the baseline copy is safe. Recalculation can expose errors or change cached values.

5. Salvage data through external references

Microsoft also documents linking from a blank workbook to the damaged workbook to retrieve data. This method can recover displayed data when the workbook cannot open normally, but it may not preserve formulas as formulas.

After linking the required range, copy it and use Paste Values in a clean workbook to break the dependency on the damaged source. Record the source sheet and range for audit purposes.

6. Recover from an earlier cloud version

If the workbook lived in OneDrive or SharePoint, inspect version history and save an earlier version separately. A healthy historical workbook is usually preferable to a partially extracted repair.

For a macro-enabled workbook, preserve the XLSM format. Saving as XLSX removes VBA. For external-data workbooks, do not click Refresh All before comparing historical results and connection definitions.

Audit every recovered workbook

1. List all visible and hidden sheet tabs.
2. Compare key input rows and totals.
3. Inspect formulas across important ranges.
4. Verify named ranges and table boundaries.
5. Test charts, PivotTables, and conditional formatting.
6. Check external links, queries, and data connections.
7. Confirm macros, buttons, and workbook protection.

Close Excel and reopen the repaired file. Calculate on a duplicate, compare the results, and document any repair log Excel produced.

Select the least lossy method

Stop before evidence degrades

Keep every successful partial result and never reuse the same repair copy. Stop when attempts repeatedly shrink the file, remove worksheets, or produce inconsistent totals. For regulated, financial, or irreplaceable data, preserve the source and involve an appropriate specialist before third-party tools receive the workbook.

Prevent the next workbook loss

Enable AutoRecover and consider Always create backup for suitable local workbooks. Store Microsoft 365 files in OneDrive or SharePoint for version history, and keep independent dated backups for high-value models. Safely remove external storage and avoid editing directly over unstable network connections.

Sources

• Repair a corrupted workbook
• Open a document after a file corruption error
• Restore a previous version stored in OneDrive