Excel’s Open and Repair utility is a built-in feature in the Windows desktop app that can attempt to fix a damaged workbook. In Microsoft 365 for Windows, go to File > Open > Browse, select the workbook, click the arrow beside Open, and choose Open and Repair; then try Repair first or Extract Data if repair does not work.
What the Excel Open and Repair utility does
Open and Repair is a recovery command, not a separate download or an add-in. Excel uses it when a workbook appears corrupted or cannot be opened normally. The command asks Excel to inspect the file and try to restore enough of its structure to open it. That structure may include worksheets, cell contents, formulas, formatting, charts, tables, and other workbook features.
A workbook can become damaged when a program or computer stops while the file is being written, storage has a problem, or a file transfer is interrupted. It can also be affected by an issue in a particular workbook component. A message such as Excel cannot open the file or The file is corrupt and cannot be opened may point to a damaged file, although security settings, an unsupported format, or a blocked download can sometimes produce similar symptoms.
Recovery is not guaranteed. Excel may open a workbook but report that it removed or repaired some content. In that case, formulas, formatting, charts, macros, or other features might be missing or changed. Treat any recovered file as a salvage copy: check important worksheets and compare the results with a known-good version before relying on it.
How to run Open and Repair in Excel for Windows
Start with a copy so the original remains untouched. If the file is on a network share, removable drive, or synced folder, copy it to a local folder such as Documents before trying recovery. Close any other Excel window that has the workbook open, then follow these steps in Microsoft 365 for Windows:
- Open Excel, but do not double-click the damaged file to launch it.
- Select File > Open > Browse. In some versions, Browse is the button that opens the Windows file picker.
- Navigate to the workbook and select it once. Do not open it yet.
- Click the small arrow beside the Open button, then select Open and Repair.
- When Excel offers recovery choices, choose Repair first. If Excel cannot repair the workbook, repeat the process and choose Extract Data.
- After the workbook opens, use Save As to save the recovered content under a new name and, if needed, a different location.
Saving under a new name helps preserve the original file for another recovery attempt. If Excel displays a repair log or a warning about removed records, read it rather than dismissing it. The workbook may open successfully while still having lost particular elements.
Repair or Extract Data: which option should you choose?
Choose Repair first when you want Excel to restore the workbook as fully as it can. This is the better first attempt if you need the original layout and features, such as formulas, formatting, charts, or multiple sheets. A successful repair may still omit damaged elements, so inspect the result rather than assuming every part survived.
Choose Extract Data when Repair fails or when recovering the information matters more than preserving the workbook’s full design. Depending on the damage and the choices Excel presents, it may try to recover values and formulas. Excel may offer options to convert formulas to values or to recover formulas. Values can preserve the last calculated results but no longer update when inputs change; recovered formulas may be useful but need checking for missing references or incorrect results.
For example, if a damaged monthly report contains sales figures that are also available in a database, preserving every chart may be less important than recovering the figures for comparison. If the workbook contains a carefully built forecast with formulas that cannot easily be reconstructed, try Repair first and keep every recovered version separate until you have verified the calculations.
Why a workbook may not open or repair
Not every opening failure is file corruption. Excel may be trying to open a file with the wrong extension, or Windows may have marked a downloaded file as blocked. A workbook created in a newer Excel version can also contain features that another app does not support. If the message names a file extension or format, check that the file was actually saved in that format rather than simply renamed.
Other common causes include a damaged download, an interrupted sync, a failing drive, or a workbook that is too large or complex for the available resources. An add-in or startup setting can sometimes interfere with Excel, too. If the file opens on another computer or in another current desktop Excel installation, the problem may be with the local app or environment rather than the file itself.
- Check that the file size is not zero and that the copy finished downloading or syncing.
- Make a duplicate before testing changes, and avoid repeatedly overwriting the only copy.
- Confirm the extension, such as .xlsx or .xlsm, matches the workbook type.
- If the file is on a network or removable drive, copy it locally and try the copy.
What to try if Open and Repair fails
First, try the command again on a fresh copy. If the file came from email, cloud storage, or a shared drive, download or copy it again in case the transfer was incomplete. If there is a previous version, opening that version is often safer and more complete than trying increasingly aggressive repairs.
Check for recovery options in Excel. On Windows, go to File > Info and look under Manage Workbook for available recovered or unsaved versions. The exact entries depend on whether Excel saved recovery information and on how the workbook was closed. AutoRecover may help after an unexpected closure, but it is not a substitute for a separate backup and may not contain the latest changes.
If the file is stored in OneDrive or SharePoint, check its version history and restore or download an earlier version rather than replacing the current file immediately. For files on a Windows computer, File History or another backup service may also have a copy. If Extract Data produces usable values, save them into a new workbook and rebuild essential formulas or formatting from a trusted source.
For a workbook that still will not open, try another up-to-date desktop Excel installation if one is available. This can help distinguish a local Excel problem from file damage. Avoid editing the damaged file with multiple recovery programs before preserving a copy; each tool may alter what remains recoverable.
Excel for Mac and Excel for the web
The steps above describe the Windows desktop version. Excel for Mac does not provide the same Windows Open and Repair command path. On a Mac, first duplicate the file, install available Office updates, and try opening the copy in Excel. If the workbook is stored in OneDrive or SharePoint, look for version history there. A Windows desktop copy of Excel may be needed to attempt the specific Open and Repair workflow.
Excel for the web also does not expose the Windows Open and Repair command. It can be useful for checking a workbook that the browser can open, but it is not a replacement for repairing a damaged file in desktop Excel. If it opens online, download or save a separate copy before making changes, and check whether any workbook features are unsupported in the web app.
Safety, backups, and third-party repair tools
Keep the original file and work on duplicates. A repaired workbook can contain altered formulas or missing content even when it looks normal. Compare important totals against source records, inspect key formulas, and check that sheets, named ranges, charts, links, and macros that matter are still present. For a macro-enabled workbook, preserve the .xlsm format if macros are required, and only enable macros when the file and its source are trusted.
Be cautious with websites or utilities that promise guaranteed recovery. A workbook may contain customer details, payroll information, budgets, or confidential business data. Uploading it to an online repair service can disclose that information to a third party. Before using any external tool, check who operates it, what data it receives, how files are retained or deleted, and whether your organization allows the upload. Avoid tools that ask you to disable security protections or install unrelated software.
For important records, a regular backup is more dependable than relying on repair. Keep versioned copies in a trusted storage location, especially before making major structural changes. Cloud version history can help, but it should not be the only copy of critical data.
Frequently Asked Questions
Is Excel Open and Repair a separate program?
No. It is a command built into the Windows desktop version of Excel. You access it from the arrow beside Open in the file picker; there is no separate Microsoft Open and Repair utility that you need to download.
Will Open and Repair recover every formula?
No. It attempts to recover workbook content, but damage can prevent Excel from restoring some formulas or other features. Inspect important formulas and compare their results with source data. If you choose Extract Data, check whether Excel recovered formulas or converted them to values.
Can I use Open and Repair in Excel for the web?
No. The Windows desktop workflow is not available in Excel for the web. The web app may open a file that it can read, but for the Open and Repair command, use desktop Excel for Windows.
Does Repair change my original workbook?
Excel may open a recovered version that you can save, but keeping an untouched original is still the safest approach. Make a copy before recovery and use Save As with a new filename for the result.
What if Excel says the file format or extension is not valid?
Check that the file finished downloading or syncing, confirm its extension matches its actual format, and try a fresh copy. If it still fails, use Open and Repair on a duplicate or look for a previous version in your backup or cloud storage.
Related
- Excel Number Format Brackets for Negative Numbers Explained
- Excel Number Format for Millions: Codes and Examples
- Excel Decimal Comma: Change Number Separators
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Microsoft Excel Analysis: Data Tools and How They WorkMicrosoft Excel is a spreadsheet app with several built-in ways to analyze data. For quick suggestions, select a…
- Excel Custom Number Format for Millions of DollarsTo display dollar amounts in millions in Excel without changing the stored values, apply the custom number format…
- Outlook 2013 Rules to Run a Script: Setup and SafetyYes. In classic Outlook 2013 for Windows, you can create a rule that runs a VBA procedure: add…
- Open Excel Solver Add-in: Enable and Use ItTo open Solver in Excel for Microsoft 365 on Windows, enable the Solver Add-in at File > Options…
- Excel Workbook Open: Opening Files and Fixing IssuesTo open an existing Excel workbook in Microsoft Excel for Microsoft 365 on Windows, start Excel and choose…
- How to Insert a Checkbox in Word on SharePoint OnlineTo add a clickable checkbox to a Word document stored in SharePoint, open it in the desktop Word…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.