Excel File Won’t Open? 7 Fixes That Actually Work

Match the Symptom to the Cause

Fix 1: Open from Inside Excel, Not by Double-Click

1. Launch Excel first (a blank start screen is fine).
2. Use File ▸ Open ▸ Browse and pick the file from the dialog.
3. If that works, the file is fine and only the Windows file association is broken — right-click the file ▸ Open with ▸ Choose another app ▸ Excel ▸ tick “Always”.

This two-second test splits every “won’t open” case in half: Excel-side problems versus file-side problems. Everything below depends on knowing which side you are on.

Fix 2: Check What the File Really Is (and Unblock It)

• Turn on file extensions in Explorer (View ▸ Show ▸ File name extensions). A file renamed from .csv or .txt to .xlsx is not an Excel workbook — rename it back or convert it properly.
• For files from email or the internet: right-click ▸ Properties ▸ tick Unblock at the bottom ▸ OK. Windows silently blocks many downloaded files.
• If the file opens in Protected View with a yellow banner, click Enable Editing. Only lower Protected View settings (File ▸ Options ▸ Trust Center) for sources you trust.

Real .xlsx files are ZIP archives: rename a copy to .zip and open it. If Windows shows folders like xl/ and _rels/, the package is intact and the problem is elsewhere. If the ZIP itself is unreadable, jump to Fix 4.

Fix 3: Rule Out Excel Itself (Safe Mode) — or Skip Excel Entirely

• Press Win+R, type excel /safe and press Enter. If the file opens in safe mode, an add-in is the culprit: File ▸ Options ▸ Add-ins ▸ Manage COM Add-ins ▸ Go, and disable them one by one.
• Blank grey window when opening? File ▸ Options ▸ Advanced ▸ Display ▸ tick “Disable hardware graphics acceleration”.
• No Excel installed, or Excel itself will not start? You do not need it to read the file — open it in the browser viewer and see every sheet immediately.

• Excel ViewerOpen xlsx/xlsm/csv in the browser — no Excel, no install, no upload.

Fix 4: The File Is Corrupted — Repair It

“File format or extension is not valid” on a file that was fine yesterday usually means package-level damage: a crash during save, a bad sync, or a sloppy third-party export. Two honest options, in order:

1. Excel’s built-in Open and Repair: File ▸ Open ▸ select the file ▸ arrow on the Open button ▸ Open and Repair.
2. The free online repair: unpacks the workbook in your browser, fixes illegal XML characters and missing parts, and repacks it. Files never leave your device.

• Excel RepairFix package-level corruption locally, batch supported.

Fix 5: Legacy and Foreign Formats — Convert, Then Open

• Very old .xls files (Excel 95 / 5.0 era) are rejected by modern Excel for security reasons. Converting them to .xlsx sidesteps the block entirely.
• .ods files from LibreOffice/OpenOffice open poorly or not at all in older Excel — convert to .xlsx first for full fidelity.
• After conversion, open the new .xlsx normally — styles, formulas and multiple sheets carry over.

• XLS to XLSX ConverterModernize legacy .xls into .xlsx in the browser.
• ODS to XLSX ConverterTurn OpenOffice/LibreOffice .ods into native .xlsx.

Fix 6: It Wants a Password You Don’t Have

A password prompt before anything appears means real AES encryption. There is no legitimate shortcut around it — any tool claiming otherwise is either scam or malware. The honest paths:

• Ask whoever sent the file for the password, or for an unprotected copy.
• If it is your own file, try the passwords you habitually use — Excel gives unlimited attempts.
• Once you are in with the correct password, you can remove the protection permanently so it never prompts again.

Still stuck after everything above? Get a fresh copy from the source: re-download the export, ask for the attachment again, or pull the OneDrive/SharePoint version history. A clean original beats every fix.