Excel

Excel File Won't Open: Diagnosis and Fix Path

A spreadsheet that won’t open is a stressful find when there’s a deadline attached. The good news: most cases resolve in under five minutes with built-in tools, and the file isn’t usually as damaged as Excel’s error messages suggest. Work through the strategies below in order — they’re ranked by likelihood of success and effort, easiest first.

Quick fix

Try Excel’s built-in Open and Repair before anything else. It resolves most “won’t open” cases without third-party tools.

  1. Open Excel, but do not double-click the file.
  2. Go to File > Open > Browse and navigate to the file.
  3. Click the file once to select it. Do not double-click.
  4. Click the small arrow next to the Open button at the bottom of the dialog.
  5. Choose Open and Repair.
  6. Pick Repair if offered. If Repair fails or isn’t available, run the dialog again and choose Extract Data.

Repair attempts to fix the file and open it normally. Extract Data salvages the cell values and formulas (or just values) into a new workbook when full repair fails — you lose formatting, charts, pivot tables, and macros, but get the data.

If that didn’t work

Open the file in LibreOffice

LibreOffice Calc is more tolerant than Excel of certain XLSX and XLS damage. Files that Excel refuses outright often open in Calc with no intervention.

Install LibreOffice from libreoffice.org if you don’t have it. Then open the file in Calc directly. If it opens, save it as a new XLSX — File > Save As > choose Excel 2007–365 (.xlsx). The re-saved file usually opens in Excel without further work.

For batch processing, LibreOffice’s headless mode does the same job from the command line:

soffice --headless --convert-to xlsx broken.xlsx --outdir ./recovered/

The output file in ./recovered/ should open cleanly in Excel.

Unblock files from email or the internet

If the file came from an email attachment, a web download, or a network share, Windows may be blocking it via Mark of the Web. The symptom is identical to corruption — Excel refuses to open, sometimes silently, sometimes with a Protected View bar that won’t dismiss.

To unblock:

  1. Right-click the file in File Explorer.
  2. Select Properties.
  3. At the bottom of the General tab, look for an Unblock checkbox or button.
  4. Tick Unblock and click OK.

If the Unblock option isn’t there, the file isn’t blocked and this isn’t your problem. If it is there, ticking it usually resolves the issue immediately.

Disable Protected View temporarily

If unblocking doesn’t help and you trust the file’s origin, disable Protected View for the file’s source category:

  1. In Excel, go to File > Options > Trust Center > Trust Center Settings > Protected View.
  2. Untick the relevant boxes — typically “Enable Protected View for files originating from the Internet” or “Enable Protected View for Outlook attachments.”
  3. Click OK and try opening the file again.

Re-enable Protected View afterward if you only needed it off for one file. Leaving it disabled across all categories meaningfully weakens Office’s defenses against malicious documents.

Disable hardware graphics acceleration

If the file opens partially before Excel hangs or closes, the rendering layer may be the problem. Turn off hardware acceleration:

  1. In Excel, go to File > Options > Advanced.
  2. Scroll to the Display section.
  3. Tick Disable hardware graphics acceleration.
  4. Click OK, close Excel completely, and reopen the file.

This trades render performance for stability and resolves a meaningful share of open failures on machines with mismatched graphics drivers.

Advanced recovery

If none of the above worked, the file’s internal structure is likely damaged. Two paths remain.

Rebuild the XLSX from its ZIP container

XLSX files are ZIP archives containing XML parts. When the file as a whole won’t open but most internal parts are intact, you can extract the contents, identify the damaged part, and rebuild.

  1. Make a copy of the file with a .zip extension: broken.xlsx → broken.zip.
  2. Open the ZIP with 7-Zip, WinRAR, or any archive tool. Do not extract with Windows Explorer’s built-in ZIP support — it’s less tolerant of malformed archives.
  3. Extract the contents to a folder. Inspect for missing or zero-byte files.
  4. The most commonly damaged parts are xl/workbook.xml, xl/sharedStrings.xml, and individual xl/worksheets/sheet*.xml files.
  5. If a sheet file is intact, you can sometimes recover its data by opening the raw XML and copying cell values out manually.
  6. Repackaging the modified contents back into a working XLSX requires the ZIP structure to match Office’s expectations precisely. In most cases it’s faster to extract the data values from the XML and rebuild the workbook by hand than to try to repair the original.

This is invasive, time-consuming, and usually loses formatting and formulas. Worth trying when the data is irreplaceable and other paths have failed.

Commercial repair tools

Stellar Repair for Excel and DataNumen Excel Repair automate what the strategies above do manually. Stellar is straightforward and works on most modern XLSX files. DataNumen has a particular strength on legacy XLS (binary format) recovery that the free alternatives don’t match.

Both are paid. For a single urgent file with no other path forward, the licence cost may be justified. For repeated use, learning the free tools is more economical.

Why this happens

Excel files fail to open for one of a handful of reasons. Knowing which one applies determines which fix path is fastest.

File structure damage. XLSX files are ZIP containers with strict internal layout requirements. A single damaged XML part — typically workbook.xml or sharedStrings.xml — can prevent Excel from opening anything. The data is usually still present in the other parts, which is why Open and Repair often succeeds: it rebuilds the references rather than the data.

Mark of the Web blocks. Windows attaches metadata to files downloaded from the internet or extracted from email attachments. Office uses this metadata to apply Protected View. When Protected View can’t initialise correctly — which happens when the file has unusual structure, or when Office’s security telemetry flags something — the file appears to fail to open. The file itself is fine.

File association problems. Less common but worth ruling out — if .xlsx files are associated with the wrong application, double-clicking does nothing or opens the wrong program. Right-click the file, choose Open with, and confirm Excel is the default.

Protected View deadlock. A file that opens in Protected View but gets stuck there indefinitely is usually a Protected View bug rather than a file problem. Toggling the relevant Protected View setting off and on, or unblocking the file via Properties, breaks the deadlock.

Add-in conflict. If Excel hangs or crashes during open rather than refusing outright, an add-in is often the cause. Launch Excel in safe mode with excel /safe from a Run dialog (Win+R) and try opening the file. If it opens in safe mode, an add-in is the culprit — disable them via File > Options > Add-ins > Manage > COM Add-ins > Go.

Corrupt Office installation. Rare but possible. If multiple Excel files won’t open and behaviour is erratic across files, repair the Office installation: Settings > Apps > Microsoft 365 (or Microsoft Office) > Modify > Quick Repair (then Online Repair if Quick Repair doesn’t help).

Preventing this in future

Most won’t-open failures trace back to two avoidable patterns.

Save and version regularly. Excel’s auto-recovery is genuinely good, but only if you’ve allowed it time to checkpoint. Set the auto-recovery interval to five minutes or less in File > Options > Save. Pair this with version-control discipline for important workbooks — even just saving dated copies before major edits.

Mind the source. Files from email and untrusted downloads carry MOTW metadata that creates friction. If you regularly receive Excel files from a known-safe source, configure that source as a trusted location in Trust Center > Trusted Locations to skip Protected View entirely. Don’t blanket-disable Protected View — that disables a meaningful security layer.

If the file opens but shows nothing, see Excel opens but shows empty sheets — that’s a different problem with different fixes. If Excel itself crashes when you try to open the file rather than refusing, Excel crashes when opening a file covers the diagnostic sequence. For a deeper background on Excel’s structural model and the broader tool landscape, see the Excel repair guide.

Last verified: April 2026