iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
An old Excel workbook usually opens without trouble. If it is a legacy .xls file, supported desktop versions of Excel open it in Compatibility Mode. If a workbook really will not open, or it was damaged, or you closed it before saving your latest edits, Excel has built-in repair and recovery tools that you should try in a set order. Start by working out which of those problems you have, because each one has a different first move.
Identify which problem you have
Most failed attempts happen because the wrong fix is applied to the wrong problem. Match your situation to the first move below before changing anything.
| What you see | Likely cause | First move |
|---|---|---|
| An old .xls file opens with “Compatibility Mode” in the title bar | Normal behavior for the Excel 97–2003 format, not damage | Work in the file as it is, or convert it later (see below) |
| Excel reports that the workbook is corrupted | File damage | Open and Repair, then Extract Data if needed |
| A disk or network error appears when opening | Storage or connection problem | Copy the file to a local drive or another disk, then try again |
| You closed a saved workbook without saving later edits | Unsaved changes | Check Manage Workbook for the recovered version |
| You never saved a new workbook | No file on disk yet | Check Recover Unsaved Workbooks |
| You need an earlier version of a file in OneDrive or Excel for the web | Work was overwritten or lost after saving | Use Version history |
Opening an old .xls file
The .xls extension is the Excel 97–2003 Binary file format, known as BIFF8. Microsoft lists this format among the file types that current desktop Excel releases can open. A valid .xls workbook opens automatically in Compatibility Mode, which limits some newer features but does not mean the file is broken.
The Tool Desk
Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →The Compatibility Mode behavior described in Microsoft’s current support article applies to Microsoft 365 and to Excel 2016, 2019, 2021, and 2024. If you have an older Excel installation, check which version you are running before assuming the file itself has a problem.
#1 Best Overall
- The Microsoft Office 365 Bible: The Most Updated and Complete Guide to Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Teams, Access, and Publisher from Beginners to Advanced
- ABIS BOOK
On a phone or tablet, check the app’s support for the file type first. Microsoft’s Android support table lists .xls as read-only rather than editable, so a file that looks uneditable on mobile may be behaving as designed.
Repairing a corrupted workbook
When Excel says a workbook is corrupted, use its repair process. Microsoft’s instruction is: “To recover as much of the workbook data as possible, click Repair.” That wording comes from Microsoft Support’s corrupted-workbook guidance, which does not name an individual author.
- Open Excel and choose File > Open.
- Browse to the file and select it.
- Click the arrow beside Open, then select Open and Repair.
- Select Repair to recover as much of the workbook as possible.
- If Repair does not recover the file, select Extract Data to try to retrieve values and formulas.
Excel may also start File Recovery on its own when it detects a problem. Let that run, but keep the original file untouched in case you need to try another method.
Rank #2
If repair fails, these salvage options are sometimes worth trying. None of them is guaranteed to work, and each can lose information:
- Revert to the last saved version. If the damage came from unsaved changes made while the workbook was open, Microsoft documents reopening the workbook to return to the last saved version. Those unsaved changes are discarded.
- Set calculation to manual before opening. A workbook with heavy formulas can fail to load cleanly; manual calculation sometimes gets it open.
- Use external references when you only need cell data. If you only need the values, referencing the damaged file from a new workbook can pull the data out without opening the file directly.
- Save as SYLK. SYLK can filter out some corrupt elements, but it keeps only the active worksheet, so you must repeat it for each sheet, and workbook features may be lost.
Recovering unsaved or overwritten work
Unsaved work and a corrupted saved file need different routes. Check which one you have.
A saved file closed without saving later edits
Open File > Info and look under Manage Workbook for the item marked “(when I closed without saving).” Restoring that version overwrites the latest saved copy, so open the recovered file first and confirm it has the content you need before you save over anything.
A workbook you never saved
Go to File > Info > Manage Document > Recover Unsaved Workbooks, open the file you want, and then use Save As to store it under a permanent name.
After an unexpected closure
When Excel restarts after a crash or power loss, Document Recovery may offer the latest saved, AutoSaved, or AutoRecovered copy. Which of these appears depends on where the file was stored and how Excel was running, so check each option that is listed.
What AutoRecover can and cannot do
AutoRecover creates recovery files only if it was enabled. Microsoft’s AutoRecover settings page gives 10 minutes as the default save interval; you can change it in Excel Options > Save. Treat AutoRecover as a safety net, not a substitute for saving. A short interval reduces how much work you can lose, but it does not protect edits made between saves.
Rank #4
Restoring an earlier version from OneDrive or Excel for the web
If the workbook is stored in OneDrive or opened in Excel for the web, you can restore an earlier copy from Version history. Select a version saved before the problem started, then choose Restore.
Restoring replaces the current version, so any edits made after that version are lost. Before restoring, consider saving the current version under a new name so you can compare the two. If you cannot find Version history, the file is probably not stored in a location that keeps earlier versions, so check where the file is saved.
Converting an old workbook safely
Converting a workbook to a current format is optional. It is only necessary if you need features that the old format does not support. Conversion is available through File > Info > Convert.
Best Value
Keep the original file until you have checked the converted copy. Microsoft warns that changing file formats can lose features or formatting. The key difference for macros is this:
- .xlsx is the default XML-based workbook format from Excel 2007 onward, but it cannot store VBA macros.
- .xlsm is macro-enabled and preserves VBA code.
- .xlsb is a binary workbook format that Microsoft also lists among current workbook types.
If the old file contains VBA, convert to .xlsm, not .xlsx.
Preventing the next problem
- Save a copy of any important old workbook to a second location before you open, repair, or convert it.
- Keep AutoRecover turned on and check its interval in Excel Options > Save.
- Store workbooks in OneDrive or another location with version history, so you can roll back if a later save causes trouble.
Limits of these methods
Microsoft’s repair and format-support pages cover Excel for Microsoft 365 and releases from 2016 through 2024. Some related recovery pages have their own version or platform scope, and menu wording can differ between desktop, web, and mobile apps. Microsoft’s repair guidance mentions third-party software only in general terms and does not recommend any product, so this article does not assess one. No method can be guaranteed to recover every workbook, and a severely damaged file may only yield partial data.
Do these 3 things before closing this tab:
1Fix the driver behind crashes, sound loss and screen glitches2Repair Windows errors before they cause bigger problems3Scan for outdated or missing drivers - takes under a minuteThe Bottom Line
For a legacy .xls file, open it in Compatibility Mode before assuming it is damaged. For a corrupted file, use File > Open > Open and Repair, then Extract Data if repair fails. For lost edits, check Manage Workbook or Recover Unsaved Workbooks first, and use Version history for cloud-stored files. Always keep an untouched copy of the original.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
