Excel file not opening means the application launches but a specific spreadsheet fails to load — you see an error message such as “Excel cannot open the file because the format or extension is not valid,” a blank screen, or the file appears to open but shows no content. According to Microsoft’s Office support documentation, this problem is almost always caused by file corruption, a Protected View restriction, or a format mismatch between the file’s extension and its actual content.
What causes Excel files not to open
Protected View blocking the file — Excel quarantines files from the internet, email attachments, and untrusted locations in Protected View. These files open in a read-only sandbox and display a yellow warning bar. Clicking Enable Editing exits Protected View and opens the file normally.
Corrupted file structure — Incomplete downloads, abrupt power loss during save, or storage media errors can corrupt an .xlsx file’s internal ZIP structure. Excel cannot read a damaged file and displays an error instead of opening it.
Format and extension mismatch — Files created by third-party software and labeled as .xlsx sometimes use an incompatible internal format. Excel detects the mismatch and refuses to open the file.
Outdated Excel version — Microsoft regularly introduces new Excel features and functions. A file created with a newer Excel version may use functions or formatting that an older version cannot parse, resulting in an error on open.
How to fix Excel file not opening
Start with step 1 (Protected View) — this resolves the majority of cases involving downloaded or emailed files. If no Protected View bar appears, proceed directly to step 2 (Open and Repair).
How to verify the fix
After applying each step, try opening the file and check that all sheets, data, and formatting are visible and intact. If the file opens but some data appears missing, use File > Open > Open and Repair > Extract Data to recover the full content.
Frequently Asked Questions
Why does Excel say 'cannot open the file because the format or extension is not valid'?
This error means the file's internal format does not match its extension, or the file is corrupted. The most common cause is a file that was renamed by changing the extension without actually converting the format. Try opening the file with Open and Repair (File > Open > click the dropdown next to Open > Open and Repair). If that fails, try opening the file in Google Sheets or LibreOffice Calc — these applications are more tolerant of format inconsistencies.
Why does Excel open but show a blank screen instead of my spreadsheet?
A blank screen in Excel usually means the worksheet is hidden, the window is minimized behind the Excel frame, or the file opened in Protected View and is waiting for you to click Enable Editing. Check View > Unhide to see if the workbook window is hidden. Also check View > Window > Arrange All to bring all open windows into view.
Can I recover data from an Excel file that won't open?
Yes. Use File > Open > Open and Repair, then select Extract Data when Repair fails. This recovers cell values and basic formulas. For more severely corrupted files, copy the file to a different folder first (sometimes the file path length causes issues), then try opening from the new location. Google Sheets can also open corrupted .xlsx files and recover data that Excel cannot access.
Why can't Excel open a file sent by email?
Email attachments open in Protected View by default, which blocks editing. Click Enable Editing in the yellow bar. If the file still won't open, save the attachment to your Desktop first (do not open directly from the email), then open it from File Explorer. Files opened directly from email clients sometimes remain in a temporary folder with restricted permissions.
Why does a large Excel file open very slowly or appear to freeze while opening?
Excel processes all formulas, external links, and conditional formatting rules during file load. A file with thousands of formulas or links to external workbooks can take several minutes to open. Switch Excel's calculation mode to Manual (File > Options > Formulas > Manual) before opening large files — this prevents Excel from recalculating everything on load and dramatically reduces open time.
