Repair Corrupted Excel File: 5 Recovery Methods

Fix a corrupted Excel file: 5 recovery methods

If you need to repair a corrupted Excel file, start by making a copy of the damaged workbook so you do not overwrite the original. Then try Excel’s built-in Open and Repair feature. If that fails, you can try extracting data, restoring an earlier version, opening the workbook with manual calculation, or using an online Excel repair tool. Microsoft specifically recommends Open and Repair for damaged workbooks and provides additional recovery methods when automatic repair does not work.

What causes an Excel file to become corrupted?

An Excel workbook can become unreadable for several reasons.

Common situations include:

• Excel or Windows crashes while saving
• Unexpected power loss
• A storage device is disconnected while the file is open
• Network or disk errors
• Damaged workbook components
• Problems with the file structure
• An incomplete or unsuccessful save
• File transfer problems

Microsoft notes that file corruption can occur when a storage device such as a USB drive is disconnected while a file is open. It also recommends backups and recovery features to reduce the risk of losing work.

A corrupted workbook may show symptoms such as:

• Excel cannot open the file
• Excel displays an error when opening the workbook
• The workbook opens but contains missing data
• Formulas or formatting appear damaged
• Excel freezes while opening the file
• A worksheet appears blank
• The file reports that its format or extension is invalid

If the file came from an unknown source, do not open it simply because Excel displays an error. Microsoft recommends verifying that the source is trusted when a file’s format or extension appears suspicious.

Method 1: Use Excel’s Open and Repair feature

The first method to try is Excel’s built-in repair function.

Microsoft recommends Open and Repair when a workbook is corrupted and cannot be opened normally.

Step 1: Open Excel

Start Microsoft Excel and open a blank workbook.

Do not double-click the damaged file yet.

Step 2: Open the file browser

Go to:

File → Open → Browse

Navigate to the folder containing the corrupted workbook.

Step 3: Select the damaged file

Click the workbook once to select it.

Do not open it normally.

Step 4: Select Open and Repair

Click the arrow next to the Open button.

Choose:

Open and Repair

Step 5: Choose Repair

Excel will provide repair options.

Choose Repair first to attempt to recover as much of the workbook as possible.

If Excel successfully opens the workbook, immediately save the recovered file under a new name.

Do not overwrite your original damaged copy.

Method 2: Extract data instead of repairing the workbook

Sometimes Excel cannot fully repair a workbook but can still recover its values and formulas.

This is where the Extract Data option can help.

Step 1: Repeat Open and Repair

Go to:

File → Open → Browse

Select the corrupted workbook.

Choose the arrow next to Open and select:

Open and Repair

Step 2: Choose Extract Data

If normal repair fails, choose Extract Data.

Excel can attempt to recover:

• Values
• Formulas

Microsoft specifically provides Extract Data as an alternative when the repair attempt does not succeed.

Step 3: Save the recovered information

If the data opens successfully, save it into a new workbook.

You may need to rebuild some formatting, charts, tables, or other workbook elements.

This method is useful when the data itself is more important than preserving the original workbook structure.

Method 3: Restore an earlier version

If your Excel file is stored on OneDrive or another location that provides version history, restoring an earlier copy may be easier than repairing the damaged file.

Microsoft’s version-history guidance allows you to select an earlier version of a file and restore it.

Step 1: Locate the workbook

Find the Excel file in OneDrive or the location where its previous versions are stored.

Step 2: Open Version history

Right-click the file and choose:

Version history

You should see previously saved versions with dates and times.

Step 3: Select an earlier version

Choose a version from before the corruption occurred.

Step 4: Restore it

Select Restore.

Be careful: restoring an earlier version replaces the current version, so changes made after that version can be lost. Microsoft explicitly warns about this consequence.

If possible, download or copy the older version first so you can compare it with the current file.

Method 4: Open the workbook with manual calculation

If Excel cannot open the workbook because recalculating its formulas causes a problem, changing the calculation setting to manual can sometimes allow the workbook to open.

Microsoft lists this as one of its recovery methods for a workbook that cannot be opened normally.

Step 1: Create a blank workbook

Open Excel and create a new blank workbook.

Step 2: Change calculation settings

Go to:

File → Options → Formulas

Under Calculation options, select:

Manual

Click OK.

Step 3: Try opening the corrupted file

Go to:

File → Open → Browse

Select the damaged workbook.

Because Excel is not immediately recalculating the workbook, it may be able to open it.

Step 4: Save a recovered copy

If the workbook opens, immediately use Save As and create a new copy.

Then inspect formulas, tables, charts and other content carefully.

Method 5: Use an online Excel repair tool

If the built-in Excel methods do not recover your workbook, an online Excel repair tool can be another option.

This approach can be useful when you want a simple process without working through Excel’s recovery settings.

Step 1: Open the Excel repair tool

Visit the Repair Corrupted Excel File tool on uLoveOffice.com.

Step 2: Upload the corrupted workbook

Select the damaged Excel file from your computer.

Depending on the tool, the workbook may be processed automatically after upload.

Step 3: Start the repair

Click the Repair Excel File button.

The tool attempts to process the workbook and recover usable spreadsheet content.

Step 4: Download the repaired file

If the repair is successful, download the recovered workbook.

Step 5: Check the recovered workbook

Open the repaired file in Excel.

Check:

• Worksheets
• Formulas
• Values
• Formatting
• Charts
• Tables
• Images
• Named ranges
• Links

Do not assume that every component has been recovered simply because the file opens.

Worked example with AED figures

Suppose a Dubai property management company has an Excel workbook containing monthly rental collections.

The workbook contains:

The total monthly rent represented by these three records is:

AED 8,000 + AED 12,500 + AED 10,000 = AED 30,500

After an unexpected computer shutdown during a save, the workbook no longer opens.

The accounting team should not immediately delete the file.

Instead, they can:

1. Make a copy of the corrupted workbook.
2. Try Open and Repair.
3. If repair fails, try Extract Data.
4. Check whether an earlier version exists.
5. Try manual calculation if appropriate.
6. Use an online Excel repair tool as another recovery option.

If the workbook is successfully recovered, the team should verify that the AED 30,500 collection data, formulas and supporting worksheets are correct before relying on the recovered file.

The AED figures in this example are illustrative.

What to do if Excel still cannot repair the file

If all five methods fail, don’t keep repeatedly modifying the original file.

Create another working copy and investigate whether you can recover individual sheets or data from:

• Previous versions
• Backups
• AutoRecover files
• OneDrive version history
• Network backups
• Exported CSV files
• Previously generated reports

Microsoft also documents methods for using external references to retrieve data from a workbook that cannot be opened normally. This can help when the goal is to recover the underlying values rather than the complete workbook structure.

For particularly important financial, accounting or business records, keep the original corrupted file untouched while attempting recovery.

How to prevent Excel file corruption

Recovery is useful, but prevention is better.

Save regularly

Frequent saving reduces the amount of work that can be lost after a crash.

Keep backup copies

Microsoft recommends maintaining backup copies so you have a good version available if the original becomes corrupted.

Use AutoRecover

Excel can periodically save recovery information.

Go to:

File → Options → Save

Check that Save AutoRecover information is enabled and choose an appropriate interval.

Microsoft provides AutoRecover as a way to help recover work after unexpected problems.

Avoid disconnecting storage devices while Excel is running

If an Excel workbook is stored on a USB drive, network location or other external storage, make sure the file is closed before disconnecting the device.

Microsoft identifies improper removal of storage devices while files are open as one possible cause of corruption.

Keep important versions

For important financial or business workbooks, don’t rely on a single copy.

Keep separate versions or use a storage service with version history.

Frequently asked questions

How do I repair a corrupted Excel file?

Start with Excel’s Open and Repair function. If that fails, try Extract Data, restore an earlier version, use manual calculation, or try an online Excel repair tool.

Can a corrupted Excel file be repaired?

Often, yes, but recovery is not guaranteed. The result depends on the nature and extent of the corruption. Excel provides built-in recovery methods, including Open and Repair and Extract Data.

How do I recover data from an Excel file that won’t open?

Try Open and Repair first. If repair fails, use Extract Data, restore a previous version, or try other recovery techniques documented by Microsoft.

Can I repair a corrupted Excel file online for free?

Some online Excel repair tools offer free processing. Check the individual tool’s file-size limits, supported formats, privacy policy and usage restrictions before uploading a business or confidential workbook.

Will repairing an Excel file delete my data?

A repair attempt can potentially recover only part of a workbook. For this reason, always keep the original file untouched and work from a copy. If Excel offers Repair and Extract Data, try both when appropriate.

Conclusion

If you need to repair a corrupted Excel file, don’t give up after Excel fails to open it normally. Start with Open and Repair, then try data extraction, an earlier version, manual calculation, or an online repair tool. Always preserve the original file before attempting recovery and carefully check the repaired workbook afterward. For a quick online option, visit uLoveOffice.com and use the Excel repair tool as often as the service allows.