Microsoft Excel Repair Tool: Fix Damaged Workbooks

Errors & fixes · Updated November 20, 2026

Microsoft Excel’s built-in repair tool is called Open and Repair. In Excel for Microsoft 365 on Windows, go to File > Open > Browse, select the damaged workbook, click the arrow beside Open, and choose Open and Repair; make a copy of the file first, because repair may remove damaged content.

What the Excel repair tool does

Open and Repair is a recovery option built into the Windows desktop version of Excel, not a separate program you need to download. Excel checks a workbook it cannot open normally and attempts to repair its structure so it can be opened. If it cannot fix the file, Excel may offer to extract recoverable data instead.

A workbook can contain more than cell values. It may also include formulas, formatting, charts, PivotTables, links, macros, queries, and other features. Damage to one part of the file can prevent Excel from opening the whole workbook, or it can leave the workbook open but cause errors or missing content. A repair can preserve some components while removing others that Excel cannot recover safely.

Repair is not the same as recovering an earlier version. It works on the file you provide; version history or a backup may let you return to a healthy copy saved before the problem occurred. If one exists, that copy is often the best route to a complete workbook.

How to use Open and Repair on Windows

Use the desktop Excel application on Windows. Do not open the problem file by double-clicking it first; use the Open dialog so you can select the repair command.

  1. In File Explorer, make a duplicate of the workbook and keep the original unchanged. If the file is on a network drive or removable device, copy it to a local folder first.
  2. Open Excel, then select File > Open > Browse.
  3. In the Open dialog, locate and select the workbook. Do not open it yet.
  4. Select the arrow beside the Open button, then choose Open and Repair.
  5. If Excel offers a choice, try Repair first. If that does not work, repeat the process and choose Extract Data, if available.
  6. Review the recovered workbook carefully, then use File > Save As to save it under a new name and in a new location.

Repair may take a little time for a large file. If Excel reports that the workbook is already open, close other Excel windows and check whether another person or process is using it. If the command is unavailable or Excel cannot find the file, confirm that you selected a workbook in the Open dialog and that you have permission to read it.

Repair versus Extract Data

The Repair option aims to make the workbook usable as a workbook. When it succeeds, it may retain formulas, formatting, and other features, but the result still needs checking. Compare key totals and important sheets with a trustworthy source if possible. Look for blank areas, error values, missing charts, broken links, or warnings that appear when you open the repaired copy.

Extract Data is a fallback when normal repair fails. It prioritizes retrieving cell values and formulas rather than preserving every workbook feature. Formatting, charts, objects, macros, and other components may be missing or altered. It is useful when the underlying data matters more than the original layout, but it should not be treated as a complete restoration.

Neither choice guarantees recovery. If the file is truncated, overwritten, encrypted without the password, or badly damaged, Excel may not be able to reconstruct its contents. Avoid repeatedly saving over the only copy: a partial recovery can replace the original data with an incomplete version.

Check backups and version history first

Before spending time on repair, look for another copy. A backup or previous cloud version can restore the workbook exactly as it existed at an earlier point, including features that a repair might discard.

  • OneDrive or SharePoint: Find the workbook in OneDrive or the SharePoint library and open its version history. Choose a version from before the damage. You can review or restore it, but consider downloading a copy first so the current file is preserved.
  • Excel recovery: If Excel or Windows closed unexpectedly, reopen Excel and check for a Document Recovery pane. In Excel for Windows, you can also look under File > Info > Manage Workbook for available recovered or unsaved versions. Availability depends on whether recovery data was saved.
  • Local or organization backups: Check your backup service, company file server, or Windows backup setup. Ask an IT administrator whether the folder is backed up.
  • Email and shared folders: Search for an attachment or a copy sent to a colleague. Confirm its date before replacing the damaged file.

AutoRecover is intended to help restore work after an unexpected shutdown; it is not a general-purpose tool for repairing any damaged workbook. It may not contain the latest edits, and it may not help if the file was corrupted before Excel had a chance to save recovery data.

Common reasons a workbook will not open

A corruption warning does not always mean the workbook’s contents are permanently damaged. First rule out simpler causes. The file may still be downloading or copying, a network connection may have dropped, or a removable drive may have been disconnected. Copy the file to a local folder and try again. Check that the file size is plausible and that the filename extension matches the actual file type.

Other clues can point to different problems:

  • Access or sharing message: The file may be locked by another user, stored in a folder you cannot access, or blocked by a permission setting. Resolve access before attempting repair.
  • Password prompt: A password-protected workbook is not necessarily damaged. Excel cannot decrypt it without the correct password.
  • Protected View or security warning: This can indicate that the file came from an untrusted location, not that it is corrupt. Only enable editing or content if you trust the file and its source.
  • Errors after opening: Add-ins, external connections, or unsupported features can cause trouble even when the workbook itself opens. Testing a copy with add-ins disabled can help distinguish an Excel setup issue from file damage.
  • Wrong file extension: Renaming a file does not convert its format. A file labelled .xlsx may actually be another file type, or may have been incompletely saved.

Make a copy before changing extensions or trying another application. Renaming is not a repair method, and opening a file in a different spreadsheet program may change formulas, layout, or features when it is saved again.

Excel for Mac and Excel for the web

The Windows desktop instructions above refer to Open and Repair, a command in Excel for Windows. Excel for Mac does not provide the same Open and Repair command in its standard File > Open workflow. On a Mac, preserve a copy, install available Office updates, and try opening the copy in Excel. If the workbook is stored in OneDrive or SharePoint, check version history. You can also test a copy in Excel for the web, but the web app is not a replacement for the Windows repair command.

Excel for the web may open a workbook that has trouble in the desktop app, or it may show a message that the file cannot be opened. If it opens, inspect the contents and download or save a separate copy before making changes. Some features are not fully supported in the browser, so an altered appearance or missing capability does not by itself prove that the original file was corrupt. For a workbook that remains inaccessible, use a Windows computer with desktop Excel or ask your organization’s support team to assess it.

Third-party repair tools, safety, and cost

Search results include downloadable programs and online services that claim to repair Excel files. They are not Microsoft’s built-in tool, and their results vary. Some require payment, and an online service may require uploading the workbook to a company’s servers. A spreadsheet can contain payroll, customer, health, or business data, so check your organization’s rules and the provider’s privacy and retention terms before sharing it.

Start with backups, version history, and Open and Repair before considering paid software. If a third-party tool is necessary, check who publishes it, whether its price and refund terms are clear, what formats it supports, and whether it can work locally without uploading your file. Avoid programs that demand unnecessary system permissions or promise guaranteed recovery. Keep the damaged original untouched and save any recovered result separately.

Open and Repair is included in the Windows desktop Excel application; it is not a separately priced Microsoft download. Access to desktop Excel depends on the license or subscription available to you. Third-party products set their own prices, which can change, so check current terms directly rather than assuming that a particular tool is free.

What to do after recovering a workbook

Do not assume a file is sound just because it opens. Compare important figures against a reliable source, inspect each sheet, and test formulas that feed reports or decisions. Check named ranges, data validation, conditional formatting, charts, PivotTables, external links, and macros if the original workbook used them. A repair can affect components that are not obvious on the first worksheet.

When the recovered copy looks correct, save it with a new filename. Use the appropriate format for its contents: for example, an .xlsx workbook cannot store VBA macros, while .xlsm is the macro-enabled format. If the workbook contains macros, do not enable them unless you trust the source. Keep the original and a separate backup until you have confirmed that the repaired version works for its intended purpose.

To reduce the chance of future loss, keep important workbooks in a backed-up location, allow cloud synchronization to finish before disconnecting, and use version history where available. For critical files, maintain a separate backup rather than relying on a single synced copy. Synchronization can reproduce a deletion or unwanted change across devices, whereas a recoverable backup gives you another source.

Frequently Asked Questions

Is Microsoft Excel repair tool free?
Open and Repair is a feature of desktop Excel for Windows, not a separate paid utility. Whether you can use desktop Excel depends on your Microsoft Office license or subscription. Third-party repair tools may charge fees.

Where is Open and Repair in Excel?
In Excel for Windows, select File > Open > Browse, select the workbook in the dialog, click the arrow beside Open, and choose Open and Repair. Selecting the file is not enough; use the arrow menu before opening it.

Can Excel repair a corrupted file without losing data?
Sometimes, but there is no guarantee. Excel may repair the workbook, extract some values and formulas, or be unable to recover it. Work on a copy and compare recovered information with a trustworthy source.

Why can’t I see Open and Repair on my Mac?
The Windows desktop version has the documented Open and Repair command; the standard Mac workflow does not offer that same option. On a Mac, try a preserved copy, check cloud version history, update Excel, or use Windows desktop Excel if available.

Should I use an online Excel repair website?
Only after considering privacy and security. Uploading a workbook may expose its contents to the service, and recovery is not guaranteed. Try a backup, version history, or Excel’s built-in Windows repair option first, especially for confidential files.

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.