How to Repair a Corrupted Workbook? Check Your Full Guide

Theo Lucia updated Jul 07, 26

5 min(s)

TL;DR:

Repair a corrupted Excel workbook by first creating a backup copy, then utilizing Excel's built-in Open and Repair tool to either fix the file or extract its underlying values and formulas.
    ● Always run repair attempts on a copy of the damaged file, as consecutive recovery actions can further alter the data, and avoid manually changing file extensions.
    ● If the workbook crashes Excel upon opening, launch the application in Safe Mode to bypass faulty add-ins, external links, or damaged embedded objects.
    ● Severe file header corruption or repairing password-protected workbooks may limit recovery strictly to text values and formulas, permanently losing original formatting and VBA macros.

Ask AI for a summary

ChatGPT

Perplexity

Gemini

Claude

Grok Free Download Free Download Free Download

A corrupted Excel workbook can often be repaired by opening the file with Excel’s built-in Open and Repair tool, restoring an earlier version, or extracting data into a new workbook. If the workbook is badly damaged, recovery may only restore values, formulas, or sheet structure instead of full formatting and macros.

Try these methods in order, starting with Excel’s built-in repair options.

Step 1
Use Open and Repair in Excel. Open Excel, go to File > Open, select the damaged file, click the arrow next to Open, and choose Open and Repair. Select Repair first. If repair fails, select Extract Data to recover values and formulas.
Step 2
Open the workbook in Safe Mode. Start Excel in Safe Mode to disable add-ins that may block the file from opening. If the workbook opens, save a copy with a new name and disable problematic add-ins.
Step 3
Restore a previous version or backup. Check File History, OneDrive version history, AutoRecover, or temporary files. A previous version is often the fastest way to fix a damaged Excel workbook with minimal data loss.
Step 4
Move sheets into a new workbook. If Excel opens part of the file, copy usable sheets into a blank workbook and save it as a new file. Save first as .xlsx, then create another copy if macros are needed in .xlsm.
Step 5
Try another compatible spreadsheet app. Some workbook corruption affects Excel-only elements, while cell data may still be readable in a different spreadsheet program; if it opens elsewhere, copy the readable data into a clean workbook.

Common Issues and Fixes

Issue	Likely cause	Fix
Workbook will not open at all	Severe file header corruption	Use Open and Repair, then try Extract Data or restore a previous version.
Excel crashes when opening the file	Faulty add-ins, external links, or damaged objects	Open Excel in Safe Mode and remove links, charts, or embedded items.
Formatting is missing after repair	Partial recovery only restored content	Save recovered data in a new file and rebuild styles, charts, or conditional formatting manually.
Macros no longer work	VBA project corruption or saving into .xlsx	Check for an older .xlsm backup and reimport usable sheets into a macro-enabled workbook.
Workbook opens blank	Hidden sheets, display issues, or damaged view settings	Unhide sheets, change view settings, and copy visible data into a new workbook.

Quick Tips

Use these tips to reduce data loss and avoid making the corruption worse.

Save the corrupted file as a copy before attempting repair. Multiple repair attempts can change the file further.
Avoid renaming random file extensions unless the original format is known. Wrong extensions rarely repair workbook corruption.
If formulas recover but values look wrong, recalculate after opening and check broken external references.
Password-protected or shared workbooks can be harder to repair because encryption and permissions may block partial recovery.

💡Protip:

Before repairing a corrupted Excel workbook, save a copy of the damaged file and run repair attempts on the copy. This helps protect the original workbook in case some repair methods only recover partial data.