Repair Excel File — Complete Guide (2026 October)

Repair Excel File — Complete Guide (2026)

To repair a corrupted Excel file, use File → Open, select the workbook, click the arrow next to Open, and choose Open and Repair, then pick Repair. If Repair fails, run it again and choose Extract Data to pull out values and formulas.

Microsoft documents Open and Repair as the first step for a workbook that will not open, and Excel's AutoRecover setting (10 minutes by default) is the safety net for unsaved work. The sections below cover those routes, plus an HTML round-trip and manual ZIP/XML extraction for stubborn files.

Before trying anything, make a copy of the broken file and run every method against the copy. If a recovery attempt makes things worse, you still have the untouched source. Backup first, repair second.

How to Run Open and Repair Step by Step

Launch Excel — but don't double-click your broken file. That's the mistake most people make. Instead, open Excel first with no file loaded, then go to File → Open → Browse. Navigate to your corrupted workbook but don't click it yet.

Click once on the file to highlight it. Now look at the Open button at the bottom-right of the dialog. See the tiny downward arrow on its right edge? Click that arrow, not the button. A short menu appears with options including Open and Repair. Choose it.

Excel offers Repair or Extract Data. Pick Repair first. Save the repaired file under a new name immediately, and never save over the original until you have confirmed the recovery is complete.

When Repair Fails

Run Open and Repair again and choose Extract Data, which retrieves values and formulas without other workbook elements. Microsoft also lists other fallbacks: set calculation to manual before opening the file, link to the corrupted workbook with external references to pull only the data, or use a macro to extract chart source data.

After any repair, open the result and check that your formulas, named ranges (Formulas → Name Manager) and any macros are still present before you discard the original or a backup copy.

Recovery Methods at a Glance

Method 2: AutoRecover for Unsaved Workbooks

Lost a file you never saved, or Excel crashed mid-save? AutoRecover can create recovery files at set intervals. Microsoft says the default is 10 minutes, and you control it under File → Options → Save via "Save AutoRecover information every" minutes. Make sure "Disable AutoRecover for this workbook only" is not checked.

Open Excel and look for Excel's Recover Unsaved Workbooks command under File to browse saved drafts. Open the candidate, check the contents, and save it properly with File → Save As.

Shorten the Interval

A shorter interval than the 10-minute default means less work is lost after a crash. Open Excel Options → Save to change it. For workbooks stored in OneDrive or SharePoint, use OneDrive's Version history to restore an earlier version instead.

You can also enable Microsoft's backup option: File → Save As → Tools → General Options → Always create backup, so a previous version remains if a file becomes corrupted.

Method 3: The HTML Export Trick

This is a community technique, not one Microsoft documents, so treat it as an experiment on a copy. The idea is that saving in a different format can rewrite the workbook cleanly when the original opens partly.

Open what you can (for example via Open and Repair), choose File → Save As, and save as Web Page (*.htm; *.html). Close Excel, open the saved .html file in Excel, and then Save As → Excel Workbook (*.xlsx). Charts and pivot tables may not survive the round trip, so verify the result.

Method 5: When Built-In Methods Fail

If Open and Repair, Extract Data, and Microsoft's other fallbacks do not recover the file, check whether your file lives in OneDrive or SharePoint and try Version history to restore an earlier copy, or restore from a backup you made yourself. Microsoft's own documented routes should come before any outside software.

Third-party repair services exist, but this guide does not recommend a specific product because Microsoft does not endorse one.

Uploading Files to Online Services

Never upload sensitive financial, HR, or proprietary workbooks to an unknown online service, since you cannot verify how the file is stored or handled. For confidential files, stick to local methods and your organization's IT support.

If you want to learn more Excel troubleshooting techniques, our guide on recovering excel files goes deeper on AutoRecover edge cases, and the macros are disabled excel walkthrough covers a related class of opening errors that look like corruption but aren't.

Preventing Excel File Corruption

Most lost work is preventable with a few habits that cost nothing.

Start with AutoSave. For workbooks stored in OneDrive or SharePoint, AutoSave keeps changes synced, and OneDrive's Version history lets you restore an earlier version of a file. For files that must stay local, shorten the AutoRecover interval under File → Options → Save (the default is 10 minutes) and consider the Always create backup option.

Unreliable network connections can interrupt a save and leave a file partly written. A safer habit is to edit a local copy, save it, and then copy the finished file to the share. Avoid using Open in Excel against a slow network path for large files.

Watch File Size

Very large workbooks are slower to save and harder to work with. If yours keeps growing, look for unused formatting on whole columns (Ctrl+End shows the last used cell), unused defined names (Formulas → Name Manager), and large embedded images. Splitting one massive workbook into linked files is often easier to manage.

Add-Ins, Stability, and the Final Diagnostic Step

If Excel crashes at consistent moments, try disabling add-ins one at a time. Go to File → Options → Add-ins, change Manage to COM Add-ins or Excel Add-ins, click Go, and uncheck items one at a time, restarting Excel between toggles.

Another diagnostic step is Safe Mode, which starts Excel and without add-ins. If the file opens there, the problem is likely an add-in or setting rather than the file. If it still will not open, the file itself may be damaged and the repair methods above apply.

For repeated corruption, check your disk health and free space, since a full or failing drive can interrupt saves.

When you recover a file, save the recovered copy in at least two places before further editing, and check formulas, formatting, and sheet protection afterward. Treat backup discipline as the real solution: AutoSave, OneDrive sync, and a short AutoRecover interval make corruption a minor inconvenience.