Excel File Corrupted? How to Recover and Repair It

How-to basics · Updated November 19, 2026

If Excel says a file is corrupted, first make a copy of it and leave the original untouched; then, in Excel for Microsoft 365 on Windows, try File > Open > Browse, select the file, use the arrow beside Open, and choose Open and Repair. If that does not work, try Extract Data, restore an earlier version or backup, and check whether the problem is really a damaged workbook rather than a file-format or access issue.

What an Excel corruption warning means

A corrupted workbook is one Excel cannot reliably read or interpret. Damage can affect the workbook’s internal structure, worksheets, formulas, formatting, charts, links, or other stored features. Excel may refuse to open the file, show a repair notice, open it with missing content, or stop responding while loading it. The message is a warning to investigate, not proof that every item in the workbook is lost.

Corruption can happen after an interrupted save, a computer crash, a storage or sync problem, or a transfer that did not finish correctly. A workbook may also become damaged after being handled by software that does not preserve all of Excel’s file features. In other cases, the file is healthy but Excel cannot open it because it has the wrong extension, is blocked, is password-protected, or is stored somewhere you cannot currently access.

Excel workbooks commonly use .xlsx, .xlsm, .xlsb, or the older .xls format. Their extensions identify different file formats and capabilities. For example, .xlsm is used for macro-enabled workbooks. Renaming a file from one extension to another does not convert its format and can make the problem harder to diagnose.

Protect the original before trying repairs

Repairs can remove damaged content, and some recovery actions create a different version of the workbook. Keep an untouched copy so you can retry a different method or compare results. If the file is on a network drive, removable disk, or cloud-synced folder, copy it to a local folder before troubleshooting. Do not overwrite your only copy with a recovered file.

  • Make a duplicate in File Explorer and give it a clear name, such as Budget-recovery-copy.xlsx. Keep the original extension unless you have confirmed it is wrong.
  • If a colleague sent the workbook, ask them to resend it or save and share a fresh copy. A new transfer can rule out an incomplete download or attachment.
  • Record the exact warning and note whether Excel opens the workbook at all. That information helps distinguish a repair issue from a permissions or password problem.
  • If the workbook contains sensitive information, use trusted storage and approved recovery tools. Avoid uploading confidential data to an unknown online repair service.

Use Open and Repair in Excel for Windows

Open and Repair is Excel’s built-in option for trying to open a workbook that will not load normally. In Microsoft 365 for Windows, open Excel first, rather than double-clicking the damaged file, and follow these steps on a copy:

  1. Select File > Open > Browse. In the file picker, locate and select the workbook.
  2. Select the arrow beside the Open button, then choose Open and Repair.
  3. When Excel offers a choice, select Repair first. Let Excel complete the attempt and inspect the resulting workbook before saving.
  4. If Repair does not recover a usable workbook, repeat the process on the copy and choose Extract Data if Excel offers it. This option is intended to recover available values and formulas when a full repair is unsuccessful; it may not preserve the original layout or every workbook feature.

If a workbook opens after repair, use File > Save As to save the recovered result under a new name and in the appropriate format. Check that the extension matches the workbook type. Keep the original and the recovery copy until you have verified the contents and any important formulas, macros, charts, and links. If Excel does not show Open and Repair, make sure you are using the Windows desktop app and the Browse file picker; Excel for the web and Excel for Mac do not necessarily present the same Windows commands.

Try other ways to open or recover the workbook

If Open and Repair fails, avoid repeatedly opening and saving the only copy. Try these alternatives one at a time, using a duplicate where possible:

  • Copy the file locally. A workbook on a network, removable drive, or synced folder may be affected by a connection or file-lock issue. Copy it to a folder on the computer and try again.
  • Check the file size and transfer. A file that is unexpectedly tiny, empty, or different in size from the sender’s copy may not have transferred completely. Download or request it again.
  • Check the extension and format. Ask the sender what format they saved. Do not simply change .xlsx to .xls or .xlsm; use Excel’s Save As command to convert a workbook that opens successfully.
  • Try another trusted copy of Excel. Opening a copy on a different computer with an up-to-date desktop version can help identify whether the issue is local to one installation. It is not a guaranteed repair.
  • Consider a different spreadsheet application cautiously. Another application might open some readable data, but it may not preserve Excel-specific formulas, macros, formatting, or other features. Work on a copy and check the results in Excel.

Excel for the web can be useful when a workbook is stored in OneDrive or SharePoint and the desktop app is having trouble, but it cannot be treated as a universal repair tool. If the workbook will not open there either, look for an earlier cloud version or a separate backup.

Recover an earlier version or unsaved workbook

A clean earlier copy can be more complete than a repair attempt. For a workbook saved in OneDrive or SharePoint, check its version history. In desktop Excel, select File > Info > Version History when that option is available. You can also locate the file in its cloud storage and use the service’s version-history controls. Review the date and contents before restoring an older version, because restoring it may replace or supersede newer work. If possible, save or download the older version as a separate copy first.

If Excel closed unexpectedly before you saved recent changes, open Excel and look for recovered files or use File > Info > Manage Workbook > Recover Unsaved Workbooks. The available recovery depends on whether AutoRecover or unsaved-file recovery had a usable copy; it cannot recreate changes that were never saved or captured. Check the recovered file’s date and contents, then save it under a new name.

Also check ordinary backups: Windows File History or an organization’s backup system may retain a prior version if it was configured to do so. A copy in email, a downloaded attachment, or a colleague’s folder may be an earlier valid version too. Compare dates carefully so you do not mistake a stale workbook for the latest one.

Tell corruption apart from common look-alikes

Some Excel problems sound like corruption but have a different cause. A Protected View banner or a disabled editing button usually concerns file safety or permissions; it does not by itself mean the workbook is damaged. If you trust the file and its source, review the warning before enabling editing. Do not disable security protections just to force open an unknown attachment.

A password prompt is also different from corruption. Excel cannot use Open and Repair to bypass workbook encryption or supply a forgotten password. Ask the owner for the password or an authorized, unprotected copy. Similarly, a message that the file format or extension is invalid may indicate a mismatched extension, an incomplete download, or a file that is not actually an Excel workbook.

If Excel itself crashes when opening several unrelated workbooks, the application or an add-in may be involved rather than one damaged file. Close Excel and reopen it; install available Office updates through the Microsoft 365 update controls available to your account. On Windows, you can also try launching Excel in Safe Mode by holding Ctrl while starting Excel and confirming the prompt. If the same workbook fails on multiple computers but other workbooks open normally, the individual file is a more likely focus for recovery.

Check the recovered workbook before relying on it

A workbook that opens is not automatically a complete workbook. Compare its sheets and key totals with a known source or a previous version. Look for blank or missing ranges, formula errors, unexpected values, broken charts, and missing formatting. If the workbook uses external links, refresh or inspect them only after confirming their sources are still available and appropriate.

For macro-enabled workbooks, confirm that the file still has the intended .xlsm format and that required macros are present. Excel may block macros for security reasons; do not enable them unless you trust the file and understand what they do. If the workbook contains PivotTables, data connections, or embedded objects, check those features specifically because a basic visual inspection of the cells may not reveal a problem.

When a formula or total matters, compare it with an independent source or recalculate it from known inputs. Do not assume that a repaired value is correct just because it looks plausible. Once you have checked the recovered copy, save it with a new name, and retain the damaged original until the replacement has been reviewed and backed up.

Reduce the risk of workbook damage

Regular saving and independent copies reduce the impact of corruption, although no single safeguard prevents every failure. Turn on AutoSave for files stored in OneDrive or SharePoint when appropriate, and make sure your organization’s backup or version-history settings meet your needs. AutoSave and AutoRecover serve different purposes: AutoSave updates supported cloud files, while AutoRecover can help preserve work after an unexpected closure. Neither should be treated as a substitute for a separate backup.

  • Use a stable power source and allow saves or cloud uploads to finish before shutting down or disconnecting storage.
  • Keep important workbooks in a location with version history or a managed backup, and periodically confirm that copies can be accessed.
  • Use Save As to create a new file when changing formats, and verify that macros or other features are supported by the chosen format.
  • Avoid editing the same file simultaneously through conflicting copies or unreliable removable media; coordinate shared editing through supported cloud storage where practical.
  • Keep Microsoft 365 and Windows updated, and investigate recurring storage, sync, or application crashes rather than relying on repeated repairs.

Frequently Asked Questions

Can I repair a corrupted Excel file without losing data?

Sometimes. Make a copy, try Open and Repair, and choose Repair before Extract Data. Excel may recover most or all usable content, but a damaged workbook can have missing formulas, formatting, or other features. Compare the result with a backup or trusted source before relying on it.

Why does Excel say the file format or extension is not valid?

The extension may not match the file’s actual format, the download may be incomplete, or the file may not be an Excel workbook. Ask the sender to confirm the format and provide a fresh copy. Renaming the extension alone does not convert the file.

Can Excel for Mac use Open and Repair?

The steps above describe the Windows desktop command. Excel for Mac may not show the same Open and Repair option. Start with a duplicate, check cloud version history or backups, and try opening it in an available trusted Excel version. Avoid overwriting the only copy.

Does Open and Repair recover a password-protected workbook?

No. Repair is not a way to bypass workbook encryption or recover a forgotten password. You need the correct password or an authorized copy from the workbook owner.

Is a repaired workbook safe to use for important calculations?

Not until you verify it. Check key sheets, formulas, totals, links, and any macros or data connections that matter. Compare important results against a reliable source, save the checked file separately, and keep the original until the replacement is confirmed.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.