Open and Repair in Excel: How to Recover a Workbook

To use Open and Repair in Excel for Microsoft 365 on Windows, go to File > Open > Browse, select the workbook, click the arrow beside Open, and choose Open and Repair. Try Repair first; if that fails, run the command again and choose Extract Data. This built-in recovery tool can help when a workbook is damaged or Excel will not open it normally. Make a copy of the file first so you can keep the original unchanged.

What You’ll Need

Excel for Microsoft 365 on Windows. The Open and Repair command described below is in the Windows desktop app. Excel for the web does not offer it, and Excel for Mac does not provide the same command.
The workbook file. Know where it is saved and make sure you can access the folder, shared drive, or cloud account that contains it.
A safe place to save a recovered copy. Choose a folder you can write to, preferably separate from the original file.
The password, if the workbook is encrypted. Open and Repair is not a way to bypass a password or other access restrictions.

Step-by-Step

Make a separate copy of the workbook. Close Excel if the file is open, then use File Explorer to copy and paste the workbook into a different folder, or give the copy a distinct name. Keep the original untouched. If the file is on OneDrive, SharePoint, or a network drive, copy it to a local folder you can access before attempting recovery. This protects the source in case a repair attempt changes or removes workbook content.
Start the Windows desktop version of Excel. Open Excel itself rather than double-clicking the workbook. If Excel opens to a start screen or a blank workbook, that is fine. The important point is to use the desktop app, because the browser version does not have the same recovery command.
Open the Browse dialog. Select File > Open > Browse. In some layouts, you may first need to select Open in the File screen before choosing Browse. Browse opens the Windows file picker, where you can locate and select the copied workbook. Do not double-click it yet.
Open the command menu beside Open. With the workbook selected in the file picker, find the Open button near the bottom of the dialog. Click the small arrow beside that button, not the main button itself. A short menu appears with the Open and Repair command.
Choose Open and Repair. Excel may display a confirmation message before proceeding. If it does, confirm that you want Excel to attempt recovery. The command can take a little time, especially for a large workbook, so avoid repeatedly clicking the button or closing Excel while the process is running.
Try Repair first. If Excel displays a dialog offering Repair and Extract Data, choose Repair for the first attempt. Repair tries to restore the workbook structure so the file can open with as much of its original content and functionality as possible. It may not restore every damaged item, and it may report that some content was removed.
Review the result before saving. If the workbook opens, check important worksheets, formulas, charts, tables, and links. Look for an Excel recovery report or message that identifies content Excel could not restore. Do not assume that a workbook is complete just because it opens; compare key totals and inspect the areas you rely on.
Save the recovered workbook under a new name. Use File > Save As, choose a safe folder, and give the recovered file a different name from the original. Select an appropriate Excel format, such as Excel Workbook (.xlsx) for a standard workbook or Excel Macro-Enabled Workbook (.xlsm) if it contains macros you need to preserve. Keep the damaged source until you have checked the recovered copy.
Use Extract Data if Repair does not work. If the first attempt fails, repeat the steps on the copy and choose Extract Data when the recovery options appear. This option is aimed at retrieving cell values and formulas when Excel cannot restore the workbook normally. It may not preserve the original layout, formatting, charts, or other workbook features. Save any recovered result as a new file and review it carefully.

Common Mistakes

Clicking Open instead of its arrow. The main Open button tries to open the file normally. The Open and Repair option is in the small menu attached to that button. Select the file first, then click the arrow.

Trying the command in Excel for the web. The browser version does not show the Windows desktop Open and Repair menu. Download or copy the workbook and use Excel for Microsoft 365 on Windows. If you only have a Mac or browser access, use the alternatives in Troubleshooting.

Working on the only copy. Repair attempts can alter a workbook, and recovery may omit damaged content. Make a separate copy before starting, then save the recovered result under a new name.

Choosing Extract Data too soon. Extract Data is a fallback, not usually the first choice. It can recover useful values and formulas, but it may not reproduce the complete workbook. Try Repair first unless you specifically need to salvage data from an otherwise unusable file.

Assuming a password or permissions problem is corruption. A password-protected workbook still requires the correct password. A file you cannot access because of account permissions, encryption, or a locked location may need access restored before repair can help.

Tips

Keep the source file and recovered file distinct. Add a word such as recovered or a date to the new filename so you can tell it apart from the original. Avoid saving over the source until you have verified the replacement and made another backup.
Check the most important information first. Compare totals, recent entries, named ranges, and worksheets used for reporting. If formulas refer to other files, check whether those links still point to the right locations.
Preserve the right file type. Saving a macro-enabled workbook as .xlsx removes VBA macros. If the workbook contains macros, choose .xlsm when saving the recovered copy. If Excel warns about features that are not supported in the selected format, stop and choose a format that retains the features you need.
Try a local copy when the file is on a shared location. A network interruption or syncing conflict can prevent Excel from reading a file reliably. Copy it to a local folder, then use Open and Repair on that copy. Do not overwrite a shared team file until you have confirmed with its owner that the recovered version should replace it.
Use version history as another recovery route. For files stored in OneDrive or SharePoint, check the file’s version history for a healthy earlier copy. This can be more useful than repairing a file if corruption began after a recent edit or synchronization problem.

Troubleshooting

Open and Repair is not listed. Confirm that you are in the Windows desktop app and have selected a workbook in the Browse dialog. The option is in the arrow menu beside Open; it is not a command on the worksheet ribbon. If you are using Excel for Mac, Excel for the web, or another spreadsheet program, switch to Excel for Microsoft 365 on Windows if possible.

Excel says the workbook cannot be repaired. Try the command again on a fresh copy and select Extract Data. If you have access to another computer with desktop Excel, try opening the copy there. Also check for an earlier version in OneDrive or SharePoint version history, a backup on your computer, or a copy sent as an email attachment. If the file came from someone else, ask them to send a new copy.

The file picker cannot find the workbook. Confirm the folder path and filename, and check whether the file is actually downloaded to your computer. For a cloud-only file, use the cloud service to download it first. If the file is on a network drive, check that the drive is connected and that you have permission to open the folder.

Excel asks for a password. Enter the correct password if the workbook is encrypted. Open and Repair cannot remove encryption or recover a password. If the file opens but a sheet or workbook structure is protected, that is a different restriction from file corruption; contact the owner or use the authorized password.

The recovered workbook opens but some content is missing. Review any recovery messages Excel showed, then compare the affected sheet with a backup or prior version. If Repair omitted important content, try Extract Data on a separate copy to see whether it can recover cell values or formulas. Some elements, such as formatting or charts, may need to be rebuilt from a good copy or recreated manually.

You are on a Mac or cannot use a Windows PC. Excel for Mac does not offer the same Open and Repair command. Try opening a copy in the current Excel for Mac release, check cloud version history or backups, and ask someone with Excel for Microsoft 365 on Windows to run Open and Repair on a copy. Excel for the web can be useful for viewing a healthy workbook, but it is not a substitute for this repair command.

Frequently Asked Questions

Does Open and Repair delete the original workbook?
It is intended to open or recover a workbook, but you should not rely on it as a no-change operation. Make a copy first and save the result under a new name. That leaves the original available if the repair is incomplete.

Should I choose Repair or Extract Data?
Choose Repair first when you want Excel to restore a usable workbook. Choose Extract Data if Repair fails or if recovering cell values and formulas matters more than preserving the full layout and features.

Can I use Open and Repair for a workbook that will not open because I forgot its password?
No. The command addresses workbook damage, not password recovery. You need the correct password for an encrypted file, or help from the person or organization that controls access.

Can I use Open and Repair in Excel for Mac or Excel for the web?
The Windows desktop version has the command described here. Excel for the web does not provide it, and Excel for Mac does not have the same Open and Repair option. Use backups or version history, or ask someone with Windows desktop Excel to try it on a copy.

Will Repair restore every formula, chart, and formatting detail?
Not necessarily. The result depends on what is damaged. Check important sheets and calculations after recovery, and compare them with a backup. If some content is missing, try Extract Data on another copy or restore an earlier version.

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.