If you are dealing with an Excel File Not Opening problem, don’t assume the spreadsheet is gone. First, find out whether the problem is with the workbook or with Excel itself. Try opening another Excel file. If other files work, focus on the damaged workbook. If nothing opens, the problem may be Excel, an add-in, Office, Windows, or your computer.
The good news is that you can try several recovery steps before giving up on the file.
Start With This Quick Test
Before changing anything, open Excel and try these three things:
- Create and save a new blank workbook.
- Open another Excel file that you know works.
- Try opening the problem file.
| What happens? | What it probably means |
|---|---|
| Other files open normally | The problem may be with one workbook |
| No Excel files open | Excel, Office, Windows, or an add-in may be involved |
| Excel freezes on one file | The workbook may contain damaged or problematic content |
| The file opens on another computer | Your computer or Excel installation may be the issue |
| The file fails everywhere | The workbook or its format may be damaged |
Microsoft recommends troubleshooting Excel problems systematically rather than changing several things at once. Microsoft’s Excel troubleshooting guide also explains how Safe Mode can help identify add-in and startup problems.
Before You Try Anything, Make a Copy
If the workbook contains important information, protect the original first.
This is especially important for:
- Business accounts
- Invoices
- Budgets
- Salary records
- Customer information
- School results
- Research data
- Tax records
For example:
2026 Business Expenses.xlsx
Create a backup:
2026 Business Expenses - Backup.xlsx
Use the copy for your recovery attempts. Don’t keep overwriting the only original.
1. Move the File to Your Computer
If the workbook is on a USB drive, external hard drive, network folder, or cloud-synced location, make a copy and move it to your computer’s internal storage.
Then try opening the copy.
Microsoft recommends moving a workbook to a local disk when a network or storage problem may be preventing it from opening. See Microsoft’s workbook recovery guidance.
If the local copy opens, the spreadsheet may be fine. The problem could be the USB drive, network, synchronization, or permissions.
If you regularly have problems with your internet connection, our guide on why your internet keeps going out may also help.
2. Check the File Extension
Look at the end of the filename.
Common Excel formats include:
- .xlsx — standard Excel workbook
- .xlsm — macro-enabled workbook
- .xlsb — Excel binary workbook
- .xls — older Excel format
- .xltx — Excel template
- .csv — text-based data file
Microsoft explains that Excel supports several file formats, but features can vary between them. See Microsoft’s Excel file format guide.
Don’t just rename the extension
Changing:
report.xls
to:
report.xlsx
doesn’t actually convert the file.
If you need to convert it, open it in a compatible version of Excel and use Save As. Keep the original copy because some features can be lost during conversion.
3. Try Open and Repair
If other Excel files open but this one does not, try Excel’s built-in recovery tool.
How to use it
- Open Excel.
- Go to File > Open > Browse.
- Select the problem workbook.
- Click the arrow beside Open.
- Choose Open and Repair.
- Select Repair.
Microsoft provides official Open and Repair instructions.
If Repair fails, try Extract Data. This may recover values and formulas even when Excel cannot fully restore the workbook’s formatting.
If the recovery works, save the recovered file under a new name.
4. Try Manual Calculation
A large workbook with complicated formulas or external references can sometimes have trouble loading.
You can try opening Excel without automatic calculation.
- Open a blank workbook.
- Go to File > Options > Formulas.
- Under Calculation options, select Manual.
- Click OK.
- Try opening the problem workbook.
Microsoft includes manual calculation among the possible recovery methods for damaged workbooks. See the workbook recovery guidance.
If it opens, save a new copy immediately.
5. Open Excel in Safe Mode
If several files are affected, an Excel add-in could be causing the problem.
On Windows:
- Press Windows + R.
- Type:
excel /safe
- Press Enter.
Now try opening the workbook.
If it works in Safe Mode but not normally, an add-in or startup component may be responsible.
To test this, open Excel normally and go to:
File > Options > Add-ins > COM Add-ins > Go
Temporarily disable the add-ins and restart Excel.
Then test the workbook again.
6. Try the File on Another Computer
This is one of the easiest ways to narrow down the problem.
Copy your backup file to another trusted computer and try opening it.
If it opens there, the workbook may be fine and the problem could be your Excel installation, add-ins, permissions, or computer configuration.
If it fails on several computers, pay more attention to the workbook itself.
7. Try Excel for the Web
If the file is stored in OneDrive or SharePoint, try opening it through Excel for the web.
The result can give you another useful clue:
- Works online but not in desktop Excel: investigate the desktop installation.
- Fails online and on desktop: the workbook may need recovery.
- An older version works: consider using that version instead.
Different versions of Excel can support different features, so this test is a clue rather than absolute proof that the file is damaged.
8. Check Version History
If your workbook is stored in OneDrive or SharePoint, don’t forget about older versions.
An earlier copy may be much easier to recover than a damaged current version.
Microsoft explains how to view and restore previous versions through Excel Version History.
Before restoring an old version
Make a copy of the current file first.
Then:
- Find the workbook in OneDrive or SharePoint.
- Open Version history.
- Look for a version from before the problem started.
- Open or review it.
- Restore it only when you’re sure it is the version you need.
9. Check Whether the File Is Locked
If the workbook is stored in a shared location, another person or another Excel session may still have it open.
Try:
- Closing Excel on your other devices.
- Asking coworkers whether they have the file open.
- Restarting Excel.
- Waiting a few minutes before trying again.
Don’t delete temporary or shared files unless you know what they are and have permission to do so.
10. Check Protected View
Sometimes Excel opens a file but blocks editing because the document came from an unfamiliar location.
This can happen with files downloaded from the internet, received as email attachments, or copied from another computer.
Before disabling security features, ask:
- Do I know who sent the file?
- Was I expecting it?
- Is the source trustworthy?
- Does it contain macros?
If you don’t trust the source, don’t disable security simply to make the spreadsheet open.
11. Check File Permissions
If Excel works normally but one file doesn’t, Windows permissions could be involved.
Right-click the workbook and select Properties.
Check its location and whether Windows indicates that the file is blocked.
If the file belongs to a company, school, or another person, don’t change permissions without authorization.
12. Check Excel Compatibility
An older workbook may behave differently depending on the version of Excel or the device you’re using.
This is especially relevant when opening files on phones and tablets.
Microsoft explains that Excel’s support for formats such as .xls, .xlsx, .xlsb, and .xlsm can vary between platforms. See Microsoft’s Excel compatibility information.
For example, if an old .xls file will not open properly on your phone, try opening it with desktop Excel before assuming the workbook is corrupted.
13. Update Microsoft Excel
If several workbooks are affected, check whether Microsoft 365 or Office has an available update.
An outdated installation can cause compatibility and software problems.
If Excel itself is too unstable to update normally, move on to repairing Office.
14. Repair Microsoft 365 or Office
If several Excel files refuse to open, repairing Office may make more sense than trying to repair each workbook.
This is worth considering if:
- Excel crashes with different files.
- Excel freezes frequently.
- Other Office apps are also having problems.
- Excel worked normally before a recent change.
On Windows, the general path is:
Start > Installed apps > Microsoft 365/Office > Modify
Depending on your installation, you may see Quick Repair or Online Repair.
15. Recover the Data Instead of the Whole Workbook
Sometimes the formatting is less important than the information inside the spreadsheet.
If normal repair fails, concentrate on recovering the actual data.
You may still be able to recover:
- Text
- Numbers
- Formulas
- Worksheet data
- Other useful workbook information
A recovered spreadsheet that looks slightly different is still much better than losing months of important records.
A Simple Example
Imagine you have a workbook called Sales 2026.xlsx containing a year’s worth of sales records.
One day Excel freezes while you’re editing it. After restarting the computer, the workbook refuses to open.
Instead of repeatedly clicking the file, try this:
- Make a backup copy.
- Move the copy to your local drive.
- Test another Excel file.
- Try Open and Repair.
- Try Extract Data if Repair fails.
- Try manual calculation.
- Test the file on another computer.
- Check OneDrive or SharePoint Version History if applicable.
If an older version opens normally, you may have already recovered most of what you need.
The important lesson is simple: protect the original before you start experimenting.
What You Shouldn’t Do
When an Excel file won’t open, avoid making the situation worse.
Don’t randomly rename the extension
Changing .xls to .xlsx doesn’t convert the file.
Don’t overwrite the original
Always keep a backup while troubleshooting.
Don’t immediately install recovery software
Some recovery services require you to upload your spreadsheet. If it contains financial, business, customer, or personal information, understand how the service handles your file before using it.
Don’t disable security blindly
A security warning may be protecting you from a dangerous document.
Don’t assume the workbook is damaged
If every Excel file fails, the problem may be Excel itself.
Is the Problem the File or Excel?
Use this quick guide:
| What you see | What to investigate |
|---|---|
| One workbook fails | Workbook, format, location, or permissions |
| Every workbook fails | Excel, Office, add-ins, or Windows |
| Safe Mode works | Add-ins or startup components |
| Another computer opens the file | Your computer or Excel installation |
| Excel for the web opens it | Desktop Excel or local configuration |
| File fails everywhere | Workbook, format, or storage copy |
| Older version works | Recent workbook version |
How to Prevent It Happening Again
Once you’ve recovered the workbook, take a few simple precautions.
Keep another copy
Important spreadsheets should not exist in only one location.
Use Version History
If you use OneDrive or SharePoint, version history can give you another way to recover an earlier copy.
Keep Office updated
Updates can improve compatibility and fix software problems.
Avoid editing important files directly from USB drives
Copy important workbooks to your computer before doing major work on them.
Make a backup before major changes
For example:
Sales 2026 - Before Formula Changes.xlsx
That extra copy could save you a lot of work later.
If Other Things on Your Computer Are Also Going Wrong
If Excel isn’t the only application causing problems, look beyond the workbook.
For example, network problems can interfere with cloud-saved files and synchronization.
If you’re also dealing with an older computer that struggles with demanding software, our guide to the best laptops for software development explains what to look for in RAM, storage, processors, and other hardware.
If you’re learning programming, you can also check our guide to the best coding apps for beginners.
Quick Excel Recovery Checklist
If you just want the steps, use this order:
- Make a copy of the workbook.
- Try another Excel file.
- Move the copy to your local drive.
- Check the file extension.
- Try Open and Repair.
- Try Extract Data if Repair fails.
- Try manual calculation.
- Open Excel in Safe Mode.
- Disable add-ins if Safe Mode works.
- Try the workbook on another computer.
- Check Excel for the web.
- Check Version History.
- Update Office.
- Repair Microsoft 365 or Office.
- Focus on recovering the data if the workbook itself cannot be restored.
Frequently Asked Questions About Excel File Not Opening
Why is my Excel file not opening?
The workbook may be damaged, incompatible, locked, stored somewhere with access problems, or affected by an Excel or Office issue. Testing another workbook is the quickest way to see whether the problem is limited to one file.
What should I do first?
Make a copy of the workbook, then try opening another Excel file. If other files work, move a copy of the problem workbook to your local drive and try Open and Repair.
Can Excel repair a corrupted file?
Sometimes. Excel’s Open and Repair feature can attempt to recover a damaged workbook. If that fails, Extract Data may recover some values and formulas.
How do I open Excel in Safe Mode?
Press Windows + R, type excel /safe, and press Enter. If the workbook opens in Safe Mode but not normally, investigate Excel add-ins.
Why does the file open on another computer?
The workbook may be fine. Your original computer could have an Excel installation issue, add-in conflict, permission problem, or another configuration issue.
Can I recover an older version?
Yes, if the workbook is stored somewhere that provides Version History, such as OneDrive or SharePoint. Check for a version from before the problem occurred.
Should I rename .xls to .xlsx?
No. Renaming the extension does not convert the file. Use Excel’s Save As feature to properly convert the workbook.
Why does Excel freeze when I open one workbook?
The workbook may be large or contain damaged formulas, external references, or other problematic content. Try Safe Mode, manual calculation, Open and Repair, or an earlier version.
What if Open and Repair doesn’t work?
Try Extract Data, manual calculation, another computer, Excel for the web, and Version History. If the information is extremely important, consider professional data recovery rather than repeatedly modifying the only copy.
Can an Excel add-in prevent a workbook from opening?
Yes. If the workbook opens in Safe Mode but not normal Excel, temporarily disable your add-ins and test again.
Why won’t an old Excel file open on my phone?
Excel’s mobile apps don’t support every file format and feature in exactly the same way as desktop Excel. Try opening the file with desktop Excel or Excel for the web before assuming it is corrupted.
Final Thoughts On Excel File Not Opening
When you have an Excel File Not Opening problem, don’t start by trying every fix you can find. First ask a simpler question: Does Excel work with other files?
If other workbooks open normally, protect the problem file, move a copy to your local drive, and try Open and Repair. If that doesn’t work, move on to Extract Data, manual calculation, another computer, Excel for the web, or Version History.
If no Excel files open, focus on Excel itself. Safe Mode, add-in troubleshooting, updates, and Office repair are more appropriate places to start.
Most importantly, keep the original file safe while you troubleshoot. A backup or older version can make the difference between a quick recovery and losing hours of work.
1 thought on “Excel File Not Opening? Find the Cause & Recover It”