How to Repair an Excel File That Won’t Open Safely

Errors & fixes · Updated November 20, 2026

If an Excel file will not open, first make a copy of it, then use Excel for Microsoft 365 on Windows: choose File > Open > Browse, select the copy, click the arrow beside Open, and choose Open and Repair. Try Repair first; if that fails, choose Extract Data. These steps can recover a damaged workbook while helping protect the original. You will need Excel installed and access to the file; if it contains important data, also look for a backup before trying repairs.

What You’ll Need

  • The affected Excel workbook, such as an .xlsx, .xlsm, or .xls file.
  • A separate copy of the workbook saved in a different folder or with a different name. Do not experiment on the only copy.
  • Microsoft Excel for Microsoft 365 on Windows for the built-in Open and Repair command. Some repair and recovery options differ on Mac or Excel for the web.
  • If the file is stored online or came from someone else, access to its original location or sender in case you need a fresh copy or an earlier version.

Step-by-Step

  1. Make a safe working copy. Close Excel if it is already attempting to open the workbook. In File Explorer, right-click the file and choose Copy, then paste it into a separate folder. Rename the copy so it is easy to identify, for example, workbook-repair-copy.xlsx. Check that the copy has a plausible file size. A file showing 0 KB is usually empty or incompletely downloaded, and repair cannot restore data that was never saved to it. Leave the original unchanged.
  2. Check whether the file is actually complete and is an Excel workbook. If you downloaded it, download it again or ask the sender to resend it. A browser or email service may have saved an incomplete copy. Check the file extension and the source: renaming a PDF, CSV, or other file to .xlsx does not convert it into a workbook. If Excel reports that the file format and extension do not match, do not dismiss the warning unless you trust the source and know what format the file should have been. Ask the sender to confirm the correct format.
  3. Try opening the copy with Open and Repair. Start Excel, then select File > Open > Browse. In the Open dialog, go to the folder containing your copy and click the file once to select it; do not double-click it. Click the small arrow next to the Open button and choose Open and Repair. Select Repair in the prompt and wait for Excel to finish. The workbook may take time to process, especially if it contains many sheets, formulas, or large objects. If Excel opens it, immediately choose File > Save As and save a new workbook with a different name. Keep the original and the working copy until you have checked the saved result.
  4. Try Extract Data if Repair does not work. Repeat the Open and Repair steps and choose Extract Data instead. Excel may offer to convert formulas to values or recover values and formulas. This option can save cell contents even when it cannot restore the workbook’s full structure, but formatting, charts, formulas, macros, links, or other features may be missing or changed. Save the extracted result under a new name. Do not treat it as a complete replacement until you have checked the contents against another copy or source.
  5. Check whether Excel itself or an add-in is causing the failure. On Windows, close Excel, press Windows key + R, type excel /safe, and press Enter. Excel starts in Safe Mode, which limits some features and prevents many add-ins from loading. Try opening the working copy. If it opens in Safe Mode but not normally, an add-in or startup setting may be involved. In normal Excel, go to File > Options > Add-ins. Beside Manage, select COM Add-ins and click Go, then clear an add-in’s checkbox to disable it temporarily. Restart Excel and test the copy. Re-enable add-ins one at a time if the workbook opens; do not delete an add-in unless you know it is unnecessary. Safe Mode is a Windows desktop option, not an Excel for the web feature.
  6. Check for a blocked download, but only if you trust the file. In File Explorer, right-click the downloaded copy and choose Properties. On the General tab, look for an Unblock checkbox or button near the bottom. It appears only for some files. If you recognize the sender and expected the workbook, you can select Unblock, choose Apply, and try opening the copy again. Do not unblock a file from an unknown or suspicious source, and do not turn off Excel security settings just to get a file to open.
  7. Look for an earlier or automatically recovered version. If the workbook is in OneDrive or SharePoint, use its Version history to find a version from before the problem. In OneDrive on the web, right-click the file and choose Version history; review a version before restoring it, or download a separate copy if available. In Excel, File > Info may show workbook versions under Manage Workbook. Recover Unsaved Workbooks is meant for work that was not saved, not for repairing every damaged file. You can also check File > Options > Save for the AutoRecover location and settings. Availability depends on whether AutoRecover was enabled and whether Excel saved a recoverable version.
  8. Verify the recovered workbook before relying on it. Open the new saved file and check every sheet, especially the last rows and columns containing data. Look for blank sheets, missing formulas, error values, broken charts, altered formatting, and missing external links. If it is an .xlsm workbook, confirm that its macros are present before using them; Excel may warn about macro security. Save another copy after you have verified the result. If the workbook contains business-critical information, compare it with a backup or ask the file’s owner to validate the recovered data.

Common Mistakes

Working on the only copy: Repair attempts, format conversions, or accidental saves can make recovery harder. Preserve the original and perform each test on a duplicate. When a repair succeeds, save to a new name rather than overwriting the source.

Changing the file extension: Replacing .xlsx with .xls or another extension does not repair the file and may cause Excel to interpret it incorrectly. Use Save As from Excel only after the workbook opens, and choose a format that supports the features you need. For example, saving a macro-enabled workbook as .xlsx removes its VBA macros.

Repeatedly clicking through security warnings: A workbook can be damaged and still be unsafe. Do not enable macros, unblock a download, or lower security protections just because the file will not open. Confirm that you trust the sender and expected the file first.

Assuming Extract Data restores everything: It is a fallback for recovering some contents, not a full-fidelity repair. Compare formulas, charts, formatting, named ranges, and macros before treating the result as complete.

Confusing an unsaved-workbook recovery with file repair: Recover Unsaved Workbooks can help when a workbook was never saved or Excel closed unexpectedly. It usually will not fix a damaged file that already exists on disk.

Tips

  • Keep a backup before using Open and Repair, and save every recovered version under a new name. A clear filename such as budget-recovered-2026-11-03.xlsx helps distinguish it from the source.
  • If the workbook arrived by email or a shared drive, ask the sender to open their copy and send a fresh version. A working copy from the source can be faster and more complete than repairing a damaged transfer.
  • When a recovered workbook opens, check formulas as well as visible values. A cell can display a plausible number even if its formula was lost or replaced by a fixed value.
  • Excel for Mac does not present the same Windows Open and Repair workflow in every version. Make a duplicate and try File > Open in Excel for Mac, update Office if an update is available, and check for a cloud version or backup. If the Windows repair dialog is needed, use a trusted Windows computer with desktop Excel. Excel for the web may preview a workbook or report an error, but it does not provide the same desktop repair command.
  • If the workbook opens but behaves strangely, use File > Save As to make a fresh copy in the appropriate Excel format, then close and reopen that copy. This can help with some file-structure issues, but it is not a substitute for a backup or a successful repair.

Troubleshooting

Excel says the file is corrupt and cannot be repaired: Try Open and Repair once on a separate copy, then try Extract Data. If both fail, retrieve a previous version from OneDrive, SharePoint, Windows File History, or your organization’s backup system. If another computer has the same problem, the file itself is more likely to be damaged than your Excel installation.

Excel does nothing or closes when opening the file: Start Excel in Safe Mode as described above and test the copy. If Safe Mode works, temporarily disable COM add-ins and try again. If it still fails, install available Office updates and restart Windows. Avoid repeatedly opening a file that causes Excel to crash before you have preserved another copy.

Excel opens the file but shows blank or missing content: Check all worksheet tabs, hidden rows and columns, and whether the workbook opens in Protected View. Use Extract Data on a separate copy if the normal repair did not recover the contents. A blank-looking workbook may also be a valid but empty file, so compare the file size and ask the sender to confirm what should be present.

The repair option is missing: Confirm that you are using desktop Excel for Windows and opening the file through File > Open > Browse. The arrow beside Open appears in the file picker after you select a file. Excel for Mac and Excel for the web may not provide this same option; use a backup, cloud version history, or Windows desktop Excel for that repair workflow.

The file opens on another computer but not yours: This points toward a local Excel, add-in, or permissions issue. Try Safe Mode, make sure you have permission to read and write the file, and save a local copy before opening it. If the local copy works, check the shared drive or synchronization service rather than repeatedly changing the workbook.

Frequently Asked Questions

Can I repair an Excel file without losing data?
Sometimes. Open and Repair can restore a workbook, but it cannot guarantee every formula, chart, macro, or formatting detail will survive. Use a duplicate, save the result under a new name, and verify it against a backup or source.

Should I choose Repair or Extract Data?
Choose Repair first because it attempts to restore the workbook itself. Choose Extract Data if Repair fails; it may recover values or formulas, but the result can lose workbook features.

Why will a workbook open in Safe Mode but not normally?
An add-in or startup setting may be interfering with normal opening. Disable COM add-ins temporarily through File > Options > Add-ins, then test the workbook and re-enable add-ins one at a time to identify the cause.

Can I use Excel for the web to repair a damaged workbook?
Excel for the web may open or preview some files, but it does not provide the Windows desktop Open and Repair command. Use desktop Excel on Windows, or recover a cloud-stored earlier version.

What if the file is 0 KB?
A zero-byte file contains no workbook data for Excel to repair. Download it again, copy it from the original device or storage location, or ask the sender for a new copy. Check that the replacement has a nonzero size before opening it.

Does changing .xlsx to .xls fix a workbook?
No. An extension change does not convert or repair the file and can make it harder to identify. Obtain a valid copy or use Excel’s repair options on a duplicate instead.

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.