Excel Cannot Open the File: Causes, Checks, and Fixes

Yes—Excel may be able to open a file that it says is corrupted, but the message does not always mean the workbook itself is damaged. First make a copy of the file, check that its format and location are valid, and then try Excel’s Open and Repair command on Windows.

What the error means

Excel uses several messages when it cannot read a workbook. One common warning says that Excel cannot open the file because the file format or file extension is not valid. Others say the workbook is corrupted, unreadable, or cannot be accessed. These messages describe a failure to open the file; they do not identify one guaranteed cause.

A workbook can be damaged if saving was interrupted, a transfer stopped early, or a storage device developed a fault. But Excel may also reject an intact file when the extension does not match its contents, the file is incomplete, access is restricted, or the file is in a format the installed Excel version cannot read. A password prompt or a Protected View warning is a separate issue, not proof of corruption.

The distinction matters because the right response depends on the cause. Repair tools may help with damaged workbook contents, while a wrong extension calls for finding the original format. If the problem is permissions, changing file access may be enough. Avoid repeatedly saving over the only copy while you investigate.

Check the file and its location first

Before attempting a repair, preserve the original. In File Explorer, copy the workbook to a local folder such as Documents and give the copy a different name. If the workbook is on a network drive, removable disk, or cloud-synced folder, this also helps separate a file problem from a connection or synchronization problem.

Then check these basic points:

Confirm the download or transfer finished. Compare the file size with the sender’s copy if possible. A surprisingly small file or a download that stopped early may be incomplete.
Check the extension. In Windows 11 File Explorer, use View > Show > File name extensions. An extension such as .xlsx should match the actual file format; changing the letters at the end does not convert the contents.
Try a local copy. If the copy opens locally but the network or cloud version does not, investigate synchronization, connectivity, or access permissions rather than repairing the workbook.
Ask for a fresh copy. If someone sent the file, request that they reopen and resave it, then send it again. This is often safer and quicker than reconstructing a damaged workbook.
Check whether another copy exists. Look in email, backups, OneDrive, or the folder where the workbook was previously saved before using recovery tools.

Do not assume that a file is an Excel workbook just because its name ends in .xlsx. For example, renaming a PDF or a text file to .xlsx will not make Excel able to interpret it as a workbook. If the sender can identify the program that created it, ask for a genuine Excel export or the original file.

Use Open and Repair in Excel for Windows

For a damaged workbook, Excel for Microsoft 365 on Windows includes an Open and Repair option. Work on the copy, not the only original, because a repair can remove unreadable parts of a workbook.

Open Excel, then select File > Open > Browse.
In the Open dialog, select the workbook once. Do not double-click it.
Select the arrow beside the Open button, then choose Open and Repair.
Choose Repair first. If Excel cannot repair the workbook, repeat the process and choose Extract Data if that option is offered.

Repair attempts to restore the workbook structure and as much content as possible. Extract Data is a fallback for retrieving usable values or formulas when a full repair fails; it may not preserve the original layout, formatting, charts, or every formula. The result should be inspected carefully, especially if the workbook contains multiple sheets, external links, pivot tables, or macros.

If the workbook opens, immediately use File > Save As to save it under a new name and, if possible, in a fresh .xlsx or .xlsm file. Keep the original copy until you have checked the recovered workbook. Look at several sheets, verify important totals, and test any formulas or links that matter. A workbook that opens is not necessarily a complete or accurate recovery.

Check the format and extension

Excel workbooks use different formats for different purposes. Common formats include .xlsx for standard workbooks, .xlsm for workbooks that can contain VBA macros, .xlsb for binary workbooks, and .xls for older Excel files. CSV files contain text data rather than a full workbook: they do not retain multiple sheets, most formatting, or workbook features. Opening a CSV and saving it as an Excel workbook can be appropriate, but it does not restore features that were never stored in the CSV.

An extension mismatch can happen when a file is renamed manually, exported by another program, or incorrectly labeled by a website or email system. If you know the source, obtain a new copy in its actual format. Do not try a series of guessed extensions. Renaming changes the label, not the underlying file structure, and may make it harder to identify what the file really is.

Some older or non-Microsoft spreadsheet formats may require a conversion or a newer application. If the file came from another spreadsheet program, ask the sender to export it as an Excel workbook. If it came from an older Excel version, a current Microsoft 365 installation generally supports common legacy Excel formats, but unusual or damaged files can still fail to open.

Recover an earlier or unsaved copy

If repair fails, recovery may be possible from a version saved before the error occurred. For a workbook stored in OneDrive or SharePoint, check version history: in Excel for Windows, select File > Info > Version History when available. You can also use the file’s Version history option in OneDrive or SharePoint. Review dates before restoring or opening an earlier version, so you do not replace newer work unintentionally.

If Excel closed unexpectedly before you saved, open Excel and check File > Info > Manage Workbook for a recovered or unsaved version. The exact recovery entries depend on whether AutoRecover was enabled and whether Excel retained a usable recovery file. AutoRecover is not a substitute for saving regularly, and it may not contain the most recent edits.

For files stored only on a computer, check the organization’s backup system, Windows backup tools, or any folder where you keep copies. If the workbook was an email attachment, save the attachment again rather than working from a temporary preview. In every case, open a recovered version separately and compare it with what you remember; recovery can restore an earlier state rather than the latest one.

Separate corruption from passwords and security warnings

A workbook that asks for a password is not necessarily corrupted. If the file is encrypted, you need the correct password to open it; a repair command cannot bypass that protection. Ask the file’s owner for the password or an authorized unencrypted copy. Similarly, a workbook that opens read-only may be protected, marked read-only, or already in use by another person.

Files downloaded from the internet or received by email may open in Protected View. That is a security feature intended to reduce risk from untrusted files; its warning is not the same as a corruption message. Only choose Enable Editing when you trust the source and expected the file. Do not disable Protected View or broadly lower Trust Center protections just to open one workbook.

If a file came from a trusted source and Windows has blocked it, check with your organization’s IT administrator before changing security settings, particularly on a work computer. A macro-enabled .xlsm file deserves extra care: macros can run code, so do not enable them simply because the workbook will not open normally.

Try another platform carefully

Excel for the web can be a useful check if the workbook is stored in OneDrive or SharePoint and the desktop app cannot open it. Open the file from its cloud location in a browser. If it opens there, save a separate copy or use the available download option, then check whether that copy opens in desktop Excel. The web version has feature limitations, so a workbook that behaves differently online is not automatically repaired.

On Mac, first make a duplicate, then try opening it from Excel using File > Open. The Windows Open and Repair command is not available in the same way in Excel for Mac, so do not look for the same arrow-menu workflow. If Excel for Mac cannot open the copy, try a clean version from backup or a cloud version history, or ask the sender to resave it from a supported Excel installation.

Another spreadsheet program may open some files, but using one is a recovery attempt, not a guarantee. It may omit or alter Excel-specific features such as macros, external connections, advanced charts, or formulas. If you use another application to retrieve data, save it as a new file and compare critical values before relying on it.

Reduce the chance of losing workbook data

For important workbooks, keep more than one recoverable copy. Store files in a reliable location with version history or backups, and allow cloud synchronization to finish before shutting down or disconnecting. Save periodically with Ctrl+S on Windows; on Mac, use Command+S. For major changes, use Save As to create a dated copy rather than overwriting the only known-good version.

When sending a workbook, attach the saved file rather than a temporary preview or an unfinished download. For large workbooks, give the transfer time to complete and confirm the recipient can open the attachment. If a workbook contains macros or sensitive data, follow your organization’s sharing and security rules rather than removing protections to make transfer easier.

Finally, do not treat a successful repair as proof that every figure is correct. Compare key totals with a trusted source, check formulas in important cells, and confirm that the expected worksheets and records are present. When the file supports accounting, operational, or other consequential decisions, retain the original and have a knowledgeable person validate recovered data before using it.

Frequently Asked Questions

Does Excel saying the file is corrupted mean it is permanently damaged?
No. The message can also result from a wrong extension, an incomplete download, a permission issue, or an unsupported format. Keep a copy of the file and check those possibilities before concluding that the contents are lost.

Will Open and Repair recover every worksheet and formula?
No. It may restore much of a workbook, but some content or features can be missing. Extract Data may recover information when full repair fails, but formatting, links, charts, or formulas can be lost. Verify important results against a reliable source.

Can I fix the file by changing .xlsx to .xls?
Usually not. Renaming changes the extension, not the file’s internal format. Use the format the workbook was actually saved in, or ask the sender to export a valid Excel copy.

Why does the same workbook open on another computer?
The other computer may have a newer or different Excel installation, access to a synced copy, or different permissions. Compare the exact file, its size, and its location. If only one computer fails, updating Office or checking local access and security settings may help.

Can Excel for the web repair a corrupted workbook?
It can sometimes open a cloud-stored workbook that desktop Excel cannot, but it is not a general replacement for Windows Open and Repair. If it opens, save a separate copy and inspect the contents; do not assume the file has been fully repaired.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.