Why Is My Excel File Corrupted? Causes and Fixes

How-to basics · Updated November 21, 2026

An Excel file is usually described as corrupted when Excel cannot read its contents reliably, or when part of the workbook has been damaged. Common causes include an interrupted save, a failing drive, a cloud-sync conflict, or a damaged file transfer; sometimes the file is not corrupted at all, but has the wrong extension, permissions, or an incompatible format.

What Excel file corruption means

An Excel workbook contains more than the values visible in its cells. It can also store formulas, formatting, charts, tables, links, names, macros, and other workbook features. The modern .xlsx and .xlsm formats package workbook components in a structured file; .xlsb uses a binary format, while the older .xls format uses a legacy binary structure. If required data or structure is missing or inconsistent, Excel may show an error, fail to open the file, or open it with some content missing.

Corruption does not necessarily mean every sheet and value is gone. Damage may affect one component, such as a chart, a style record, or a worksheet, while other data remains readable. Excel may be able to repair a workbook, but a repair can remove damaged elements. A recovered file therefore needs checking rather than assuming that everything is intact.

Common reasons an Excel file becomes corrupted

Many cases trace back to a problem while a workbook was being saved, copied, or stored. A file is especially vulnerable if the process stops before all of its contents have been written or transferred.

  • Interrupted saving: Excel, Windows, or the computer may close unexpectedly during a save. A power loss, forced restart, application crash, or full disk can interrupt the write.
  • Storage problems: A failing hard drive, SSD, USB flash drive, or memory card can return incomplete or damaged data. Repeated errors with several files on the same device are a reason to check the storage, not just the workbook.
  • Sync or network interruptions: A network share or cloud service may not finish uploading or downloading a file. If a workbook is edited in more than one place, conflicting copies can also result. Sync services often preserve versions, but they do not guarantee that every copy is complete or conflict-free.
  • Transfer or download errors: A browser download, email attachment, removable drive, or file-copy operation can be interrupted. The copy may be smaller than expected or different from the original.
  • Third-party software: Another spreadsheet program, a conversion utility, or an automated process may rewrite a workbook and mishandle a feature or file component. This is more likely with complex files, macros, external connections, or newer Excel features.
  • Security software or permissions: Security tools can quarantine or block access to a file, and restrictive permissions can prevent Excel from reading or saving it. These situations often resemble corruption but may be access problems instead.

Workbook size alone does not prove corruption, and a large file is not automatically unsafe. However, a workbook with many formulas, embedded objects, links, or macros can take longer to save and transfer, increasing the chance that an interruption matters.

Errors that can look like corruption

An Excel error message is a clue, not a diagnosis. For example, a message that the file format or extension is not valid may mean the extension does not match the actual file type, the download is incomplete, or the file is damaged. Renaming .csv to .xlsx does not convert a CSV into a workbook; open the CSV in Excel and use Save As to create an Excel workbook instead.

Other apparent failures have different explanations. A workbook may open read-only because it is already open elsewhere, marked as read-only, or stored where you lack write permission. A password prompt can indicate encryption, not corruption. Protected View is a security feature for files from potentially untrusted locations; it is not evidence that the file is damaged. A file created in a newer Excel version may also contain features that an older version cannot fully display.

Try to distinguish a workbook problem from an application or device problem. If one file fails but other workbooks open normally, the issue is more likely specific to that file. If Excel cannot open several known-good files, investigate Excel, Windows, or the storage device before attempting repeated repairs.

Why file type and compatibility matter

Check the full file name and extension, but do not treat changing the extension as a repair. An .xlsx file cannot store VBA macros, while .xlsm is the macro-enabled workbook format; saving a macro-containing workbook in a format that does not support macros can remove them. Older .xls workbooks have format limits, and some features may change or be lost when saving to that format.

Compatibility issues can produce warnings or altered content without the file being corrupt. If possible, open a copy in a current version of Excel for Microsoft 365 on Windows. If the file came from another spreadsheet application, ask the sender to export or save a fresh copy in an Excel format. A fresh export may resolve a compatibility problem, but it is not a substitute for preserving the original.

What to do before trying a repair

Protect the original first. Repeatedly opening, saving, or converting the only copy can overwrite recoverable content or make it harder to compare versions. Use these checks before trying more involved recovery:

  1. Make a copy of the file and work on the copy. If it is on a USB drive or a network location, copy it to a local folder before troubleshooting.
  2. Check that the file has finished downloading or syncing. Compare its size with the sender’s copy or another known-good version, if available.
  3. Ask whether someone else has a working copy, or check the folder for a duplicate, an email attachment, or a version created before the problem.
  4. Open another workbook in Excel. If other files also fail, restart Excel and Windows, then consider whether an Office or device issue is involved.
  5. Confirm that the file type is plausible and that you have permission to access it. Avoid changing the extension to make an error disappear.

If the file is on a device that is making unusual noises, disconnecting, or reporting read errors, avoid repeated recovery attempts on that device. Copying a failing drive over and over can worsen data loss. For valuable files, consider professional data-recovery help before continuing.

Use Excel’s Open and Repair option

For a workbook that will not open, Excel for Microsoft 365 on Windows includes a built-in repair attempt. In Excel, select File > Open > Browse, navigate to the workbook, select it, and click the arrow beside the Open button. Choose Open and Repair. If prompted, choose Repair first. If that does not work, try Extract Data, which may retrieve values and formulas even when Excel cannot restore the workbook structure.

Save any successfully opened or recovered content under a new name and in a new location. Then check every sheet, formula, chart, table, named range, and macro that matters. Repair may discard damaged components, and extracting data is not the same as restoring a complete workbook. On Mac or Excel for the web, menus and available recovery options differ; if Open and Repair is unavailable, use a Windows desktop copy of Excel or restore an earlier version from the storage service.

Look for a previous or autosaved version

A backup or earlier version is often more complete than a repaired file. If the workbook is stored in OneDrive or SharePoint, check its version history through the file’s context menu or Excel’s File information. The exact route can vary with the account and interface, but version history may let you open or restore a prior saved version. Confirm that the version is old enough to precede the damage and save a separate copy before replacing anything.

For a file stored only on the computer, check Windows File History or another backup system if one was configured. Excel’s AutoRecover is intended to help after an unexpected closure, but it is not a guaranteed backup and may not contain the latest edits. In Excel for Windows, recovery options can appear under File > Info after a crash, and AutoRecover settings are under File > Options > Save. An unsaved-workbook recovery option may help with an unsaved file, but it cannot restore data that was never captured.

How to reduce the chance of corruption

No prevention measure eliminates every failure, but a few habits make recovery much easier and reduce avoidable interruptions:

  • Keep important workbooks in a reliable, backed-up location. For cloud files, wait for the service to finish syncing before shutting down or disconnecting.
  • Use version history or regular backups for work that changes frequently. A synchronized folder is useful, but synchronization alone is not the same as an independent backup.
  • Save before closing Excel or restarting the computer, and avoid disconnecting removable storage while a file is being saved or copied.
  • Keep enough free disk space and pay attention to repeated storage or Windows errors. Replace unreliable drives rather than trusting them with the only copy.
  • Use the appropriate format: .xlsx for ordinary workbooks, .xlsm when VBA macros must be retained, and other formats only when their limitations suit the task.
  • When a workbook is important, retain the original and save major revisions as separate versions rather than repeatedly overwriting the only copy.

When to use caution with recovery tools

Third-party repair programs vary in quality, and uploading a workbook to an online repair site can expose confidential business, personal, or financial data. Review the provider’s privacy and retention terms before sharing a file. Avoid tools that demand disabling security protections or installing unrelated software. If a workbook contains sensitive information, prefer a trusted local recovery method or your organization’s IT support.

Macros and external links also deserve care. A damaged workbook recovered from an unknown source should not be trusted simply because it opens. Keep macros disabled unless you know the file and its source are trustworthy, and review links or connections before refreshing them. Repairing a file is about recovering data; it does not establish that the workbook is safe or that its contents are accurate.

Frequently Asked Questions

Can I recover an Excel file that will not open?
Often, at least some content can be recovered. Work on a copy, try Excel’s Open and Repair option on Windows, and check backups or cloud version history. Recovery is not guaranteed, and a repaired workbook may be missing features or data.

Does changing .xlsx to .xls fix a corrupted file?
No. Renaming changes the label, not the file’s internal format or damaged contents. Use Excel’s Save As command to convert a workbook, and keep a copy of the original before converting.

Why does Excel say the file format or extension is not valid?
The file may be damaged or incomplete, but its extension may also be wrong or the file may not actually be an Excel workbook. Check the source, download or copy it again, and ask for a fresh file before assuming corruption.

Can Excel AutoRecover restore the latest version?
Not necessarily. AutoRecover may provide a version from before the crash, but its contents depend on when recovery information was saved. Check it alongside backups and version history, and compare the recovered file with what you remember changing.

Why is only one workbook affected?
That points toward a problem with that file, its transfer, or its storage location, although it does not identify the exact cause. If many unrelated workbooks fail, look instead at Excel, permissions, storage, or the device.

Related

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.