How to Repair and Recover a Corrupted Excel File

Quick answer: Work on copies. Try Excel’s Open and Repair first, then use version history (OneDrive/SharePoint), then fall back to backups (File History) and safe extraction methods.

A “corrupted” Excel file can mean a lot of things: Excel won’t open it, it opens with missing data, formulas behave strangely, or it crashes on open. The goal is to recover the most complete, trustworthy version while minimizing the risk of making the file worse.

Do This First (Safety Rules)

1. Make a copy of the file and work only on the copy.
2. Stop auto-saving behavior while you test. If it’s in a synced folder, consider pausing sync until you have a good copy.
3. Create a recovery folder like `Excel Recovery - Candidates` so you don’t lose track of versions.
4. Write down what changed right before the corruption (update, add-in, power loss, sharing change, new macro, etc.).

The most common failure is repeatedly opening and saving the same broken file until every fallback version also becomes “the broken one”.

Step 1: Try Excel “Open and Repair”

Excel’s Open and Repair is the best first attempt because it is designed for workbook-level repair.

Workflow:

1. Open Excel (don’t double-click the file).
2. Use File → Open and select the workbook.
3. Choose the option to Open and Repair.
4. If prompted, try Repair first; if that fails, try Extract Data.

If you get a repaired file open, save it with a clear name like `RECOVERED - repaired.xlsx` rather than overwriting the original.

Step 2: Use Version History (If It’s in OneDrive or SharePoint)

If the workbook is in OneDrive or SharePoint, version history can be your safest “undo”.

1. Open the file location in OneDrive/SharePoint.
2. Open Version history for the workbook.
3. Preview versions around the last known-good time.
4. Download the best candidate(s) to your recovery folder.

If multiple people edit the workbook, do not “restore” immediately. Download candidates first, confirm the recovered data looks correct, then restore only if needed.

Step 3: Remove “One Moving Part” and Try Again

If the file opens but behaves oddly, the corruption may be triggered by an add-in, a calculation state, or a particular sheet.

Try these in a copy (one at a time):

• Open Excel in a reduced-feature state if available in your environment (for example, with add-ins disabled).
• If it opens, save as a new workbook name and test stability.
• Copy sheets into a new workbook one-by-one to identify the failing sheet.

The point is to isolate the workbook content from the environment or from a specific sheet that triggers a crash.

Step 4: Recover What You Can From a Partially Working File

If the file opens but isn’t trustworthy:

1. Save a “read-only” copy you promise not to edit.
2. Copy the most valuable data ranges into a new workbook.
3. Rebuild critical formulas gradually, testing as you go.

For many real-world workbooks, a “partial recovery” that gets the core tables back is more valuable than a perfect repair attempt that risks losing everything.

Step 5: Check File History / Backups (Windows)

If you use Windows File History, it can preserve earlier versions.

1. Locate the workbook in File Explorer.
2. Open File History / previous versions options.
3. Restore older versions to a separate folder and compare.

Treat this like cloud version history: compare first, restore only when you’re confident.

Common Causes (So You Don’t Repeat the Problem)

These are common triggers (not diagnoses):

• Sudden power loss or forced restart while the workbook was saving.
• Sync conflicts (two devices saving competing versions).
• Add-ins or macros that crash Excel during open/save.
• Network drive disconnects mid-save.
• Interrupted “Save As” to a different location.

After recovery, reduce risk by making the workbook easier to back up: fewer surprise save locations, more predictable naming, and a simple weekly backup habit.

Related Guides

If you need adjacent recovery paths:

• [Recover an unsaved Excel file](/en/recover-unsaved-excel-file/)
• [Excel AutoSave not working](/en/excel-autosave-not-working/)
• [Restore files with File History](/en/restore-files-with-file-history/)
• [Restore a previous OneDrive version](/en/restore-previous-version-onedrive-file/)

What a Helpful Image Should Show

Show a minimal step sequence: copy → Open and Repair → version history → recovered workbook, plus a reminder to rename outputs (`RECOVERED - ...`) so candidates stay safe.

When to Pause

Pause if the workbook is used for financial reporting, legal records, or regulated work. In those cases, preserve read-only copies of every candidate and document what you recovered and from where.

Editorial Check Before Publishing

The article should clearly answer:

• What to do first to avoid making corruption worse.
• How to run Open and Repair safely.
• How to use version history and backups without overwriting the only good file.

If it doesn’t, cut steps and sharpen the order.

Reader Takeaway

Excel corruption recovery works best when you treat every attempt as a test on a copy. Start with Open and Repair, then use version history, then backups. The win is the most complete reliable version, not the fastest open.

Why This Page Is Different

This guide is built around copy-first recovery and version comparison, not “try random fixes until it opens”. That prevents the common outcome: a workbook that opens, but the data you needed is gone.

Sources

• Microsoft Support: Repair a corrupted workbook
• Microsoft Support: Restore a previous version of a file in OneDrive
• Microsoft Support: Back up and restore with File History