A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
A single Excel file that will not open while most others do usually points to one of these causes:
- The file format is unsupported or limited
- Some file types can only be opened read-only, and some cannot be opened at all.
- For example,
.xlsxcan be opened and edited, but formats such as.xls,.xltx,.xlsb,.csv, and.odsmay open only as read-only in some Excel experiences. - Some older formats are no longer supported in Excel, including
.xlc,.wk1,.wk2,.wk3,.wk4,.wks,.dbf,.wq1,.wb1, and.wb3.
- The file may be corrupted or not actually be a valid Excel file
- If Excel reports that the format or extension is not valid, the file may be damaged or the extension may not match the actual file content.
- In VBA scenarios, Microsoft states that if the format cannot be interpreted or the file is corrupt, the file cannot be loaded.
- The file is being blocked because it came from an untrusted location
- This applies to
.IQY,.OQY,.RQY, and.DQYfiles. - To fix that:
- Close the file.
- In File Explorer, right-click the file and select Properties.
- If the security message appears at the bottom, select Unlock and then Apply.
- Another option is to move the file to a trusted location.
- This applies to
- Excel file association may be broken
- If the file does not open correctly when double-clicked, reset the file association:
- Copy the file to the desktop.
- Right-click it and select Properties.
- On the General tab, check the file type and the app listed under Opens with.
- Select Change and choose Excel, then enable Always use this app.
- If the file does not open correctly when double-clicked, reset the file association:
- Office installation may need repair
- If Excel files are not opening correctly, run a repair:
- Open Control Panel.
- Go to Programs > Programs and Features.
- Select the Office product.
- Select Change.
- Run Quick Repair.
- If Excel files are not opening correctly, run a repair:
- An Excel add-in may be interfering
- Test by disabling add-ins one at a time:
- In Excel, go to File > Options > Add-Ins.
- In Manage, select COM Add-Ins, then Go.
- Clear one add-in, select OK, and restart Excel.
- Try opening the workbook again.
- Repeat for other COM add-ins, then test Excel Add-Ins the same way.
- If the file opens after one add-in is disabled, that add-in is the cause.
- Test by disabling add-ins one at a time:
- If Excel opens but shows a blank screen instead of the workbook
- Try these in order:
- Go to View > Unhide and see whether the workbook was saved with hidden sheets.
- Minimize and then maximize the Excel window.
- Try these in order:
- If the issue is the known .xlsx Grant Access hang
- This issue was fixed in version 16.34.
- Update Excel to 16.34 or later.
If only one file is affected, the most likely causes are an invalid or unsupported format, corruption, or that the file is blocked or associated with the wrong app.
- Why can't I open my Excel file?
- Excel prompts you to grant access to files and then hangs or shows a warning that it cannot open the .xlsx file because the format or extension is not valid
- Troubleshoot opening a blank screen when you double-click a file icon or file name in Excel
- External data connection disabled
- Double-clicking an Office file fails to open it in the correct Office program
- The specified file could not be loaded.
- File formats that are supported in Excel