How to fix an Excel file that won’t open: (1) try Open and Repair: in Excel > File > Open > select the file > arrow next to Open > Open and Repair; (2) unblock files downloaded from the internet: right-click the file > Properties > tick Unblock; (3) check Protected View (File > Options > Trust Center > Protected View) if it’s blocking a trusted file; (4) disable add-ins (start Excel in Safe Mode by holding Ctrl); (5) check the file format/extension is correct (.xlsx/.xls); (6) copy the file to a local drive if it’s on a network share or USB; (7) open it in Google Sheets or LibreOffice to rescue the data; (8) restore a previous version (Properties > Previous Versions) or use AutoRecover; (9) repair Office. Always keep a copy of the original before trying fixes.
An Excel file that won’t open is a common problem that disrupts work and productivity. This article explains the causes and walks you through the fixes step by step.
Why won’t an Excel file open?
When an Excel file throws an error, it may be corrupted — or the problem may lie in the software or system. Either way, you risk losing important data and having to redo work, so it’s worth fixing carefully.
Common causes
- Malware: viruses can damage Excel files.
- Software crashes: if Excel crashes while saving, the file can be corrupted.
- Storage errors: files saved or transferred incorrectly can be damaged.
- Malicious or faulty macros: badly written or malicious macros can cause errors.
- Version incompatibility: files created in newer versions may not open properly in older ones.
- Disk problems: a failing drive can corrupt the files stored on it.
- Missing fonts: these don’t usually stop a file opening, but can make it display incorrectly.
7 ways to fix an Excel file that won’t open
Method 1: Use Open and Repair
Open Excel, choose File > Open and browse to the damaged file. Instead of opening it, click the arrow next to Open and choose Open and Repair.
Method 2: Open Excel in Safe Mode
Hold Ctrl while starting Excel (or run excel /safe) to start it without add-ins.
Method 3: Check Protected View
Files downloaded from the internet open in Protected View. If you trust the file, unblock it in its Properties, or adjust the settings in File > Options > Trust Center > Trust Center Settings > Protected View. Don’t disable it permanently.
Method 4: Remove problem add-ins
Disable add-ins one by one in File > Options > Add-ins to find the one causing problems.
Method 5: Try another version or app
Opening the file in a different version of Excel, Excel for the web, Google Sheets or LibreOffice can work when the file isn’t compatible with your current version.
Method 6: Restore from a backup
If you have a backup or OneDrive/SharePoint version history, restoring is the safest fix.
Method 7: Use dedicated repair software
Tools such as Stellar Repair for Excel or Excel Repair Toolbox can recover badly damaged files.
Fixing font display problems
Install the missing fonts, or open the file on a computer that has them.
How to avoid Excel file errors
- Back up regularly, especially after major changes.
- Scan for malware regularly.
- Keep Excel up to date for compatibility and security.
- Be careful with Excel files from unknown sources, especially those with macros.
Summary
Fixing an Excel file that won’t open isn’t as hard as it seems once you know the cause. If nothing works, contact an IT professional for help.
Contact IT Systems Vietnam
Contact IT Systems at hotline 028.3995.03.59 or contact@itsystems.com.vn. Follow us on Facebook and YouTube.
Need a technician to check your computer on site?
IT Systems repairs desktops and laptops on site in Ho Chi Minh City, offers remote support within 30 minutes and quotes for your approval before any repair.




