Excel cannot open the file, recovery steps in order
"Excel cannot open the file" with wording about corruption or unreadable content means Excel started reading the workbook and hit damage it cannot work around. The damage is usually confined to one part: a worksheet, the styles table, or a chart. That is why the recovery ladder below works so often: each rung asks Excel to read less of the file, or to read it in a more forgiving way, until the data comes out.
The fix, in order
- Copy the file and try Open and Repair. File, Open, select the copy, click the arrow beside Open, choose Open and Repair, then Repair. If Excel says it cannot repair, repeat and choose Extract Data, which recovers cell values and formulas while dropping formatting, charts, and macros.
- Open with calculation set to manual. In a blank workbook: File, Options, Formulas, set Workbook Calculation to Manual, then open the damaged file. Broken calculation chains are a frequent hidden cause of open failures, and manual mode skips them.
- Check for a lock or a zero-length shadow. A file that will not open while a same-named file starting with ~$ sits beside it may just be flagged as in use by a crashed Excel session. Close Excel fully, delete the ~$ owner file, and retry. Also confirm the file size is not 0 KB.
- Pull the data out with external references. In a new workbook, type a formula pointing at the closed file, like ='C:\Folder\[file.xlsx]Sheet1'!A1, and copy it across the used range. This reads cell values without opening the damaged workbook's structure at all.
- Recover an earlier copy. Check File, Info, Manage Workbook for AutoRecover saves, Previous Versions in the file's Properties, and the folder it came from (email attachment, download, or sync service version history). Any intact earlier copy is a better outcome than a partial repair.
- Save what you recovered into a fresh file. Whatever route worked, paste or save the recovered data into a brand-new workbook rather than continuing in the repaired one; leftover damage in styles and unused parts causes repeat failures.
If it still happens
If the workbook contains VBA macros, note that Extract Data and the external-reference route do not recover code. The last resort for code is opening the file as a zip archive (an xlsx is one) and reading the surviving parts directly, a job for someone comfortable with the format; the worksheet XML often survives even when Excel refuses the package.
Common questions
Does Open and Repair recover everything? It recovers what is readable. Formatting, charts, and some features may be dropped, and Excel lists what it removed in a log. Values and formulas have the best survival rate, which is why Extract Data exists as the fallback.
Why does Excel call a file corrupt when it opened yesterday? Because the damage usually happened after yesterday: an interrupted save, a sync conflict, a failing drive, or a crash while the file was open. The error describes the file as it is now.
Related errors