How to Repair an Excel File in Windows 11

How-to basics · Updated November 20, 2026

To repair an Excel file in Windows 11, first make a copy of it, then open Excel and use File > Open > Browse. Select the copy, click the arrow beside Open, choose Open and Repair, and select Repair. If that fails, try recovering an earlier version or extracting the workbook’s data. These steps apply to the Microsoft 365 desktop version of Excel for Windows.

What You’ll Need

  • The damaged workbook, or a copy of it. If possible, keep the original unchanged.
  • Excel for Microsoft 365 installed on a Windows 11 computer. You may need to sign in or have permission to modify the file.
  • Enough free space to make a duplicate and save a repaired workbook. If the file is stored in OneDrive, SharePoint, or another shared location, access to its version history may also help.

Step-by-Step

  1. Make a safe copy. Close the workbook if it is open. In File Explorer, browse to the file, right-click it, select Copy, then right-click in a safe folder and select Paste. Give the copy a clear name such as Workbook-repair-copy.xlsx. Work on the copy first so that repair attempts do not overwrite your only version. If the file is on a shared drive, save the copy to a folder where you have permission to edit it.
  2. Check that the file is local and complete. If it is on a network drive, USB device, or cloud folder, copy it to a local folder such as Documents and try the local copy. A failed download or interrupted transfer can look like workbook damage. Check that the file size is not zero and that the extension is one Excel can open, such as .xlsx, .xlsm, or .xls. Do not rename an unfamiliar file extension to .xlsx; changing the name does not convert the file format.
  3. Start Excel without opening the damaged file. Open Excel from the Start menu and choose Blank workbook, or open Excel without selecting the problem file from its recent list. Starting from the application gives you access to the recovery command even if double-clicking the workbook causes Excel to hang or display an error.
  4. Open the file using the repair command. In Excel, select File > Open > Browse. In the Open dialog, navigate to the repair copy and select it once. Click the small arrow beside the Open button, then choose Open and Repair. If you do not see the arrow, maximize the dialog or click the Open button’s drop-down area. Do not double-click the file in this dialog, because that may try a normal open rather than offer the repair options.
  5. Choose Repair first. When Excel asks whether to repair or extract data, select Repair. Wait for the operation to finish; a large workbook can take some time. Excel may report that it repaired or removed unreadable content. Read the message, then inspect the workbook rather than assuming every sheet, formula, or object was restored exactly as it was.
  6. Save the recovered workbook under a new name. If the workbook opens, choose File > Save As > Browse, select a folder, enter a new name, and save it. Keep the repaired copy separate from the original. If Excel asks for a file type, use the existing format when it is appropriate—for example, retain .xlsm for a workbook that needs macros. Saving a macro-enabled file as .xlsx removes its VBA macros, so do not choose that format if you need them.
  7. Check the contents carefully. Look through each worksheet and check key formulas, totals, named ranges, charts, formatting, external links, and any macros the workbook relies on. Compare important values with a known-good report or another copy if available. Repair can restore a file that will open without restoring every item. If Excel lists removed records or damaged features, note what is missing before you continue using the workbook.
  8. Try data extraction if Repair does not work. Repeat File > Open > Browse, select the copy, click the arrow beside Open, and choose Open and Repair. This time select Extract Data if Excel offers it. Extraction is an attempt to recover cell values and formulas when a full repair cannot open the workbook. It may not preserve layout, charts, formatting, or other features. Save the result as a new file, then check it before replacing any working copy.

The Open and Repair option is part of desktop Excel for Windows. Excel for the web does not provide this same repair command. On a Mac, the Windows Open and Repair menu path may not be available; use a backup or version history, or try the file in desktop Excel on a Windows computer.

Common Mistakes

  • Repairing the only copy. Repair may remove unreadable elements or change the workbook. Make a duplicate before trying it, and keep the original until you have checked the recovered file.
  • Opening by double-clicking. Double-clicking the file in File Explorer usually starts a normal open and bypasses the Open and Repair choice. Open Excel first and use File > Open > Browse.
  • Assuming a successful open means full recovery. A workbook can open while still missing a sheet, formula, chart, style, or macro. Check the parts that matter to your work before relying on it.
  • Changing the extension to force a repair. Renaming .xls, .xlsm, or another file to .xlsx does not repair or convert its contents and can make it harder to identify the correct format.
  • Saving over the original too soon. Use Save As to create a separate recovered file. This is especially important when repair reports that it removed content or when macros are involved.

Tips

  • Use version history before repeated repair attempts. If the file is stored in OneDrive or SharePoint, open its version history and look for a version from before the problem started. In Excel, you can also check File > Info for Version History when that option is available. Restore or download an earlier version to a separate location so the current file remains available.
  • Check Windows backups if the file is local. In File Explorer, right-click the file and select Properties > Previous Versions. This only helps if Windows or your organization has kept an applicable previous version; the tab may be empty or unavailable.
  • Keep Excel and Windows updated. An update will not reconstruct a damaged workbook, but it can address application problems that prevent files from opening. In Excel, check File > Account > Update Options > Update Now if the option is available.
  • Use AutoRecover as a separate recovery route. If Excel closed unexpectedly while you were editing, reopen Excel and look for the Document Recovery pane. You can also check File > Info for Manage Workbook or Recover Unsaved Workbooks, depending on what is available. AutoRecover is not a guaranteed backup and may not contain the latest edits.
  • Preserve macro-enabled files in the correct format. If a repaired workbook contains macros, confirm that it is saved as .xlsm or another appropriate macro-enabled format. Only enable macros if you trust the file and its source.

Troubleshooting

Open and Repair is missing. Confirm that you are using desktop Excel for Windows, not Excel for the web or a file preview. Open the workbook through File > Open > Browse, select it once, and look for the arrow next to Open. If the file is on a network or removable drive, first copy it to a local folder and try again.

Excel says the file format or extension is not valid. Make another copy and check that the file finished downloading or copying. Ask the sender to resend it, or download it again from its original location. Do not change the extension to make Excel accept it. If it was created in a different spreadsheet program, ask for a fresh export in an Excel format such as .xlsx.

Excel freezes or closes during the repair. Restart Windows and try a local copy with other large applications closed. You can also test whether an add-in is interfering: press Windows key + R, type excel /safe, and press Enter. If Excel starts in Safe Mode, try opening the copy there. If it works only in Safe Mode, an add-in or startup setting may be involved. In Excel, check File > Options > Add-ins; use the Manage list and Go button to review add-ins, and disable them cautiously. Restart Excel normally and retry.

Several workbooks fail to open, not just one. This may indicate an Excel installation issue rather than damage to a single file. In Windows 11, open Settings > Apps > Installed apps, find Microsoft 365, select the three-dot menu, and choose Modify. Run Quick Repair first. If the issue continues, try Online Repair; it may require an internet connection and can take longer. Close Office applications before starting, and follow any prompts to sign in again.

The repaired file opens but important content is missing. Do not continue editing that copy as if it were complete. Check the repair message, try Extract Data on another duplicate if you have not already, and look for a cloud version, Windows previous version, email attachment, or backup. If the data is business-critical and no backup exists, avoid repeated edits to the damaged original and ask your organization’s IT support or a data-recovery professional about the options.

Frequently Asked Questions

Can I repair an Excel file without opening Excel first?
For Open and Repair, start desktop Excel and use File > Open > Browse. Double-clicking the workbook generally attempts a normal open. You can also try a backup or cloud version history without using the repair command.

Will Open and Repair keep all formulas and formatting?
Not necessarily. Excel attempts to recover the workbook, but damaged content may be removed or altered. Check formulas, formatting, charts, links, and other important items, and compare critical results with a reliable source.

Does Open and Repair work with .xlsm files?
Desktop Excel for Windows can attempt to open and repair supported Excel workbook formats, including macro-enabled workbooks. Make a copy first, save in a macro-enabled format if you need the VBA project, and inspect the macros and workbook after recovery.

Can I repair a workbook in Excel for the web?
Excel for the web does not offer the same Open and Repair command as desktop Excel for Windows. Download a copy and try it in desktop Excel, or recover an earlier version from OneDrive or SharePoint.

What if the recovered workbook still will not open?
Try Extract Data on a separate copy, then check backups and version history. If other workbooks also fail, repair Microsoft 365 from Windows Settings. If only this file is affected and it contains irreplaceable information, avoid overwriting it and seek qualified technical help.

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.