Excel File Won’t Open: How to Repair It

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 workbook, click the arrow beside Open, and choose Open and Repair. Select Repair; if that fails, try Extract Data. The steps below also cover damaged downloads, add-ins, sync problems, and cases where Excel itself needs repair.

What You’ll Need

  • A Windows computer with Excel for Microsoft 365 or a recent desktop version of Excel.
  • The affected workbook and enough disk space to make a separate backup copy. If it is stored in OneDrive, SharePoint, or another synced folder, you may need an internet connection to download it again.
  • Permission to access the file. If it belongs to someone else or is on a work network, ask the owner or administrator before changing its location or settings.

On a Mac, Excel does not offer the same Windows Open and Repair command. The safety and file-checking steps still apply, but use the Mac-specific alternatives noted below.

Step-by-Step

  1. Protect the original file. Close any error messages, then make a copy of the workbook in File Explorer. Right-click the file, choose Copy, then right-click an ordinary local folder such as Documents and choose Paste. Give the copy a clear name, such as Report-repair-copy.xlsx. Work on the copy, not the only original. If Windows says the file is in use, close Excel and other programs that may have it open before copying.

    For a file saved in OneDrive or SharePoint, use the service’s download option to save a separate local copy if possible. A local copy helps distinguish a damaged workbook from a syncing or network problem. Avoid repeatedly overwriting the cloud copy while testing.

  2. Check that the file is complete and really is an Excel workbook. In File Explorer, check the file size and its extension. An .xlsx, .xlsm, or .xls file is a workbook format; a .csv is plain text and cannot preserve workbook features such as multiple sheets, charts, or formatting. A zero-byte file, a much smaller-than-expected file, or a download that stopped early may be incomplete. Ask the sender to export or send it again, or download a fresh copy from the original source.

    Do not simply rename a different file type to .xlsx. Changing the letters after the final period does not convert the file and can make the issue harder to diagnose. If Windows hides extensions, turn on View > Show > File name extensions in File Explorer so you can inspect the actual ending.

  3. Try opening the copy from inside Excel. Start Excel first, then choose File > Open > Browse. In the Open dialog, go to the copy’s folder and select the workbook once. Click the small arrow beside the Open button and select Open and Repair. If Excel asks what to do, choose Repair first and allow it to finish.

    Opening it from Excel rather than double-clicking can reveal whether the file association or a second Excel process is causing the problem. If the command is unavailable, verify that you selected a supported workbook file and that the copy is saved locally. Excel for the web and Excel for Mac do not have this same Windows repair command.

  4. Use Extract Data if Repair cannot recover the workbook. Repeat the Open and Repair process and choose Extract Data. Excel may be able to recover cell values and formulas even when it cannot restore the workbook normally. This is a recovery attempt, not a full repair: formatting, charts, pictures, links, macros, or other workbook features may be missing. Save any recovered content under a new name and compare it with the original or a previous version before relying on it.

  5. Test whether the problem is limited to this file. In Excel, try creating a blank workbook and opening another known-good workbook. If other workbooks open normally, concentrate on the affected file: get a fresh copy, use Open and Repair, or ask the sender for an earlier version. If no workbooks open, Excel, an add-in, or the Office installation may be responsible, so continue with the next steps.

  6. Start Excel in Safe Mode on Windows. Close all Excel windows. Press Windows key + R, type excel /safe, and press Enter. In Safe Mode, try opening the local copy through File > Open. If it works only in Safe Mode, an add-in or startup setting may be interfering.

    To investigate, close Safe Mode and reopen Excel normally. Go to File > Options > Add-ins. At the bottom, next to Manage, select COM Add-ins and click Go. Clear the check boxes to disable the listed COM add-ins, then restart Excel and test again. If that fixes the issue, enable add-ins one at a time, restarting between tests, to identify the one causing the conflict. Excel for Mac does not use the Windows /safe launch command; update Excel and test the file in a separate copy or on another computer instead.

  7. Check security blocking only when the source is trusted. A workbook downloaded from the internet or received by email may be blocked by Windows or opened in Protected View. If you trust the sender and expected the file, right-click the copy in File Explorer, choose Properties, and look at the General tab for an Unblock option. If it is present, use it only after confirming the file is safe, then try opening the copy again.

    Protected View is a security feature, not proof that the workbook is damaged. Do not disable Protected View globally or enable macros just to make an unknown file open. If Excel does open the file with a warning, follow your organization’s security rules and leave macros disabled unless you have verified the source and need them.

  8. Repair the Microsoft 365 installation if Excel itself is failing. Save your work and close Office apps. In Windows, open Settings > Apps > Installed apps, find Microsoft 365, select the three-dot menu, then choose Modify. Run Quick Repair first. If the problem continues and you have a reliable internet connection, return to Modify and try Online Repair. The labels can differ slightly by Windows or Office deployment; a work-managed computer may require an administrator.

    Office repair addresses the application, not a damaged workbook, so return to the backup copy and test it afterward. On a Mac, install available Excel updates through Help > Check for Updates if that option appears, or use Microsoft AutoUpdate. The Windows Modify and Repair controls do not apply to Mac.

Common Mistakes

  • Working on the sole copy. Repair attempts or later saves can change a workbook. Keep the original unchanged and save recovered material to a different filename.
  • Renaming the extension to force a conversion. Changing .xls, .csv, or another suffix to .xlsx does not repair or convert the file. Use Excel’s supported Save As option only after you can open the workbook.
  • Assuming every opening warning means corruption. Protected View, an access restriction, an outdated file format, or a sync delay can stop normal opening without indicating that the workbook is damaged.
  • Enabling macros or turning off security controls indiscriminately. An unknown file can contain unsafe content. Confirm its source and follow your organization’s policy before allowing active content.
  • Running Online Repair before simpler checks. Office repair can take time and may require internet access. First check the file copy, its extension, and whether other workbooks open.

Tips

  • Write down the complete error message and note whether it appears when opening one workbook or every workbook. That distinction points toward either a file-specific or Excel-wide cause.
  • For OneDrive or SharePoint files, check the service’s version history or recycle bin before attempting extensive recovery. Restoring or downloading an earlier version may be safer than repairing a damaged current copy.
  • Ask the sender to resend the workbook as an attachment or provide a fresh download link. If the file came from a shared drive, check that it finished copying before trying Excel again.
  • After a successful recovery, choose File > Save As and save to a new name and location. Close and reopen that new file to confirm it is readable before replacing or deleting anything.
  • If the workbook contains macros, save a macro-enabled workbook in an appropriate format such as .xlsm only after it opens. A standard .xlsx file cannot store VBA macros.

Troubleshooting

Open and Repair says it cannot repair the file: Try Extract Data on the backup. If that also fails, obtain another copy from the sender, cloud version history, or a backup. For a critical workbook, stop repeated attempts on the original and ask your IT administrator or a reputable data-recovery specialist about next steps.

The file opens but some content is missing: Save the recovered workbook under a new name, then compare sheets and formulas with a previous copy. Extract Data may recover cell content without preserving layout or other features. Check for hidden sheets only after saving a safe copy.

Excel hangs or crashes while opening: Test another workbook and try Safe Mode. If Safe Mode works, disable add-ins and re-enable them individually. If Excel still fails for all files, update or repair Microsoft 365. Do not repeatedly force-close Excel while it may still be saving or recovering the workbook.

The workbook is online-only or shows a sync error: Check that you are signed in to the correct account and can access the folder in a browser. Wait for syncing to finish, then download a separate local copy. If you lack permission, ask the file owner to grant access rather than trying to bypass it.

You are using a Mac or Excel for the web: The Windows Open and Repair steps are not available in those versions. On Mac, update Excel and try a duplicate of the file; if possible, test it in desktop Excel on Windows. Excel for the web can be a useful way to check a cloud workbook, but it is not a substitute for repairing a damaged file. Keep a separate copy before saving any changes.

Frequently Asked Questions

Can I repair an Excel file without opening it?
On Windows, yes: start Excel, choose File > Open > Browse, select the copy, then use the arrow beside Open and choose Open and Repair. If repair fails, try Extract Data.

Will Open and Repair delete my data?
It may recover the workbook intact, but no recovery method is guaranteed. That is why you should preserve the original and run the attempt on a copy. Extract Data can leave out formatting and other workbook features.

Why does Excel open the file only in Safe Mode?
An add-in or startup component may be interfering. Disable COM add-ins through File > Options > Add-ins, then enable them individually to find the cause. Safe Mode does not itself repair workbook damage.

Can I fix a corrupted Excel file online for free?
Be cautious with online repair sites, especially for files containing personal, financial, or work information. Uploading a workbook may expose its contents. Prefer a backup, the original sender, your organization’s IT support, or Excel’s built-in recovery options.

What if only one sheet or some formulas are missing?
Save the recovered file as a new copy and compare it with a backup or version-history copy. Open and Repair may not restore every feature; if the file opens, inspect formulas, sheets, links, and charts before treating it as complete.

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.