Excel Repair: Fix Errors and Recover a Damaged Workbook

Errors & fixes · Updated November 20, 2026

If Excel reports a problem with a workbook, first make a copy of the file, then use Excel for Microsoft 365 on Windows: select File > Open > Browse, select the workbook, open the arrow beside Open, and choose Open and Repair. Try Repair first; if it fails, repeat the process and choose Extract Data. If Excel itself will not start or keeps crashing, use the separate Office repair steps below.

What You’ll Need

  • A copy of the affected workbook, stored somewhere you can find it. Do not experiment on the only original.
  • Excel for Microsoft 365 desktop on Windows for the built-in Open and Repair command. Excel for the web and the Mac version do not offer that same repair command.
  • Access to the folder, network drive, or cloud service where the workbook is stored. If it is on OneDrive or SharePoint, check that your account can open it and that syncing has finished.
  • Enough free disk space to save a repaired copy. If you are unsure whether a file is trustworthy, do not enable macros or other active content just to open it.

Step-by-Step

  1. Identify whether the problem is the workbook or Excel. Note the exact message and when it appears. If one file fails but other workbooks open normally, the file may be damaged or have an unsupported feature. If Excel will not open any workbook, freezes at startup, or crashes with several files, troubleshoot the Office app as well. This distinction matters: repairing Office does not necessarily repair a damaged workbook, and vice versa.
  2. Make a separate copy before trying recovery. Close the workbook if it is open. In File Explorer, copy the file and paste it into another folder, then work on that duplicate. If it is in OneDrive or SharePoint, check its sync status first; you can also use the file’s version history to restore an earlier version. Avoid repeatedly opening and saving the only copy, because a failed recovery or an accidental overwrite can make the situation harder to reverse.
  3. Check the file location, size, and extension. Make sure the file has finished downloading and is not still syncing. If it is on a network share, copy it to a local folder such as Documents and try that copy. A file that is unusually small, has a size of zero, or has an unexpected extension may be incomplete or may not actually be an Excel workbook. Do not simply rename an unrelated file to .xlsx: changing the extension does not convert its contents.
  4. Use Open and Repair in Excel for Windows. Start Excel without opening the problem file. Select File > Open > Browse, find the duplicate, and select it once in the file picker. Open the arrow beside the Open button and choose Open and Repair. In the dialog, select Repair and wait for Excel to finish. This command attempts to recover workbook structure and content; it is not a guarantee that every formula, chart, macro, or formatting detail will survive.
  5. Try Extract Data if Repair does not work. Repeat the Open and Repair process on the duplicate, but choose Extract Data when the dialog offers it. This option can recover values and formulas when a normal repair cannot restore the workbook as a usable file. Check the extracted result carefully: it may omit formatting, charts, objects, or other workbook features. Save the result under a new name and keep the original copy unchanged.
  6. Save the recovered workbook as a new file. If the workbook opens, immediately use File > Save As and choose a different name and a local folder. Keep the file type appropriate to the content. For example, use Excel Workbook (*.xlsx) for a standard workbook, or Excel Macro-Enabled Workbook (*.xlsm) if it contains VBA macros that you need to preserve. Do not save a macro-enabled workbook as .xlsx if you need its macros, because that format does not store VBA code.
  7. Check the recovered content before relying on it. Review important sheets, formulas, named ranges, charts, tables, links, and macros. Look for blank areas, error values, missing rows, or formulas that now refer to the wrong cells. If a calculation looks stale, select Formulas > Calculation Options > Automatic, then press Ctrl+Alt+F9 to force a full recalculation on Windows. On Mac, use Excel’s Formulas tab to check calculation settings; keyboard shortcuts can differ by keyboard and macOS settings.
  8. Use a previous version if the repair is incomplete. For a file saved in OneDrive or SharePoint, open its version history from the file’s context menu or from the file details in the Microsoft 365 interface, then restore or download a known-good version. For a local file, check File > Info for Manage Workbook or available version and recovery options. The wording and availability can vary by file location and Excel build. Compare a recovered version with the damaged copy before replacing anything.
  9. If Excel itself is failing, test it without add-ins. Close Excel. On Windows, press Windows key+R, type excel /safe, and press Enter. If Excel opens in safe mode, an add-in or startup setting may be involved. In normal Excel, go to File > Options > Add-ins. At the bottom, select COM Add-ins beside Manage, choose Go, and clear add-ins to test; re-enable them one at a time to find the cause. Excel for Mac has different add-in controls and does not use this Windows safe-mode command.
  10. Repair Microsoft 365 if the app remains unstable. Close Office apps. In Windows, open Settings > Apps > Installed apps, find Microsoft 365, select the three-dot menu, choose Modify, and follow the prompts for Quick Repair. If that does not resolve the issue, repeat and choose Online Repair; it needs an internet connection and may take longer. In Windows 10, the comparable route is Settings > Apps > Apps & features. Repairing Office addresses installation problems, not the contents of a particular workbook.

Common Mistakes

Using the original as the test copy: A repair attempt can produce a partially recovered file. Preserve the original and save each result under a different name so you can compare outcomes.

Assuming every Excel error means file corruption: A formula warning, broken external link, disabled macro, or unsupported feature can appear in a healthy workbook. Read the message and test other workbooks before treating the file as damaged.

Choosing Extract Data first: It can be useful when Repair fails, but it may leave out workbook features. Try Repair first, and inspect any extracted data before using it for work.

Changing extensions or enabling content to force a file open: Renaming a file does not repair its structure. Enabling macros from an untrusted source can also create a security risk. Use only files from a source you trust, and do not bypass warnings without understanding them.

Tips

Keep one untouched backup and save each recovered version with a clear name, such as Budget-recovered-1.xlsx. If you get different results from Repair and Extract Data, keep both until you have checked the contents.

When the file is on a shared drive, ask whether another person can open it and whether anyone was editing it when the error occurred. A partially uploaded or interrupted sync can resemble corruption, so wait for syncing to complete before trying again.

After recovery, review formulas and external connections rather than assuming they are correct because the workbook opens. If the workbook is business-critical, preserve the damaged file and recovered copies for comparison, and ask your IT team or the file owner to review them before replacing a shared original.

Troubleshooting

Open and Repair is missing: Confirm you are using the Excel desktop app on Windows, not Excel for the web. In the Windows file picker, select File > Open > Browse, select the file, and look for the small arrow beside Open. The command is not available in the same way in Excel for Mac or Excel for the web. If you have access to a Windows computer with desktop Excel, try the duplicate there.

The workbook still will not open: Download or copy it to a local folder, check that it is not zero bytes, and run Open and Repair again. If the file came from email or a website, download it again from the original source. If it is stored in OneDrive or SharePoint, check version history for an earlier copy. If neither recovery option works, Excel may not have enough intact workbook data to reconstruct it.

The workbook opens but some content is missing: Compare sheets and key totals with a previous version or another source. Try Extract Data on a separate duplicate if you have not already. Recovery may not restore every object or formatting detail, so do not treat a visually plausible workbook as verified until important values and formulas have been checked.

Excel crashes before you can open the file: Start Excel in safe mode on Windows using excel /safe. If that works, disable add-ins through File > Options > Add-ins and test again. If safe mode also fails, restart Windows, install available Microsoft 365 updates, and try Quick Repair followed by Online Repair if needed.

The file opens on one computer but not another: Check that both computers use a compatible Excel version and that the second one has access to required fonts, links, or add-ins. Copying the file locally can rule out a network or sync issue. If the file depends on a newer feature, use an up-to-date Microsoft 365 desktop app rather than assuming the workbook is damaged.

Frequently Asked Questions

Can Excel repair a corrupted workbook automatically?
Sometimes. Open and Repair can recover some damaged workbooks, but it cannot guarantee a complete restoration. Keep the original and check the recovered file carefully.

Will Open and Repair delete my formulas?
It may preserve them, but a repair can also omit or alter content. Extract Data may recover values and formulas while losing other workbook features. Compare critical calculations with a trusted source or earlier version.

Can I repair an Excel file on a Mac?
Excel for Mac does not provide the same Windows Open and Repair command. Try opening a copy, check cloud version history or backups, and, if available, use desktop Excel for Windows to run Open and Repair.

Can Excel for the web repair a damaged file?
Excel for the web does not offer the Windows Open and Repair dialog. If the workbook is in OneDrive or SharePoint, check version history and try opening a downloaded copy in the Windows desktop app.

Does repairing Microsoft 365 fix a damaged workbook?
No. Quick Repair and Online Repair address problems with the Office installation. Use Open and Repair or a previous file version for workbook recovery.

What if both Repair and Extract Data fail?
Look for a backup, cloud version history, an earlier emailed copy, or an autosaved version. If no usable copy exists, contact your IT support team or the file owner. Avoid repeatedly editing the damaged original while trying recovery options.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

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

Spotted an error in this guide? Let us know.