Why Excel Files Get Corrupted and How to Prevent It

How-to basics · Updated November 21, 2026

An Excel file usually gets corrupted when its data cannot be written or read correctly—for example, after a crash, interrupted save, storage failure, or sync conflict. The file may also be damaged by incompatible software or a faulty transfer; corruption does not automatically mean the workbook’s formulas or calculations are wrong.

What Excel file corruption means

A workbook is a structured file, not simply a picture of a spreadsheet. An .xlsx or .xlsm file contains packaged components, including worksheet data, formulas, formatting, workbook settings, and, where applicable, macros. Excel must be able to interpret those components to open the workbook normally. If a necessary part is missing, incomplete, or inconsistent, Excel may report that the file is damaged, refuse to open it, or open it after removing content it cannot read.

Corruption can affect an entire workbook or just one component. A worksheet, chart, style, connection, or embedded object might be damaged while other sheets remain usable. It is also important to distinguish file corruption from ordinary spreadsheet problems. A broken formula, a #VALUE! error, an incorrect number format, or a missing link can be frustrating without meaning that the file itself is corrupted.

How a save can go wrong

When Excel saves a workbook, it has to write changes to a destination and finish the file structure correctly. If the application or computer stops during that process, some changes may not reach the storage device, or a file component may be left incomplete. A sudden power loss while saving is one example. A full drive, failing storage device, disconnected external drive, or unstable network connection can also interrupt the write.

The risk is not limited to the moment someone clicks Save. A workbook may be copied, uploaded, downloaded, emailed, or synchronized between devices. If one of those operations is interrupted, the copy at the destination might be incomplete even though the original is fine. With cloud storage, another device or user may update the same file at nearly the same time, creating a conflict or leaving someone with an older or inconsistent copy.

Common reasons Excel workbooks become damaged

  • Excel or Windows closes unexpectedly: A crash, forced shutdown, power outage, or restart during a save can leave the latest version incomplete. An interruption is more concerning if the workbook was actively being saved.
  • Storage problems: A failing hard drive, SSD, USB stick, or memory card can return incomplete or unreadable data. Low free space can also prevent a save from finishing. If several unrelated files show errors, investigate the device rather than assuming each workbook failed independently.
  • Network or cloud interruptions: Saving directly to a shared network location depends on a stable connection and the server’s availability. Services such as OneDrive or SharePoint can also produce version or synchronization conflicts when the same workbook is edited in multiple places.
  • Unsafe removal or interrupted transfers: Unplugging a storage device while a file is being written, or closing a browser before a download finishes, can leave a damaged copy. The source file may still be intact, so compare copies before replacing anything.
  • Other programs changing the file: Non-Excel software that imports, converts, or rewrites a workbook may not preserve every Excel feature. This can affect complex formatting, charts, macros, external connections, or newer features, even if the file still opens.
  • Workbook complexity or unusual content: Large workbooks with many formulas, links, objects, add-ins, or macros can be more demanding to process. Complexity alone does not mean a workbook is corrupt, but it can expose problems when a computer is short on resources or a third-party component behaves incorrectly.

Malware can damage or alter files, but it should not be assumed to be the cause just because Excel reports a problem. If other warning signs appear—such as unexpected file changes or security alerts—scan the computer with reputable security software and follow your organization’s security procedures.

Why file type and compatibility matter

Excel formats have different capabilities. The modern .xlsx format supports most ordinary workbooks but does not store VBA macros. A macro-enabled workbook should generally be saved as .xlsm if its macros need to remain available. The older .xls format has different limits and may not preserve features introduced in newer Excel versions. Saving in an unsuitable format can discard features or prompt a compatibility warning; that is not necessarily corruption, but it can look like missing or damaged content afterward.

Renaming a file extension does not convert the workbook. Changing a name from report.xlsx to report.xls, for example, does not transform its internal structure and may make Excel less able to identify it. Use Excel’s Save As options to convert formats, and read any compatibility messages before confirming. When a workbook came from another application, ask for a fresh export in a format that application officially supports.

Signs that a workbook may be corrupted

Excel may display a message that it found a problem with the file, cannot open it, or cannot read some content. Other clues include a workbook that suddenly becomes much smaller or larger than expected, a sheet that disappears, formatting or charts that vanish after opening, or an error that occurs only with one copy of the file. None of these clues proves corruption on its own: a blocked download, wrong extension, access-permission issue, or incompatible format can produce similar symptoms.

Check whether the problem follows the file. Try opening another workbook, and if practical, try the affected workbook on another trusted computer with a current version of Excel. Compare the file size and modified date with a known-good copy. If only a network or cloud copy fails, download or copy it to a local folder and test that copy; do not overwrite the original while diagnosing the issue.

How to recover a damaged workbook

Start by preserving the evidence. Make a copy of the damaged file and work on the copy. If a backup or earlier cloud version exists, keep it too. Repeatedly saving over the only copy can remove options for recovery, especially if Excel opens the workbook after dropping unreadable content.

  1. Try Excel’s repair command on Windows: In Microsoft 365, choose File > Open > Browse. Select the workbook, select the arrow beside the Open button, and choose Open and Repair. Try Repair first. If that does not work, reopen the dialog and choose Extract Data, if offered, to try to retrieve values and formulas.
  2. Review what Excel recovered: If the workbook opens, inspect every sheet, formulas, charts, formatting, links, and macros that matter. Excel may remove damaged records or features during repair. Do not assume that an opened file is complete; save the recovered result under a new name and compare it with a known-good version.
  3. Check backups and version history: Look for a previous copy on a backup drive or in your organization’s backup system. For a file stored in OneDrive or SharePoint, use its version history to inspect or restore an earlier version. Check the available versions before replacing the current file.
  4. Look for recovered or unsaved work: In Excel for Windows, File > Info may show workbook management or recovery options, including Recover Unsaved Workbooks when available. AutoRecover can help after an unexpected closure, but it is not a substitute for saving and does not guarantee that every recent change is available.
  5. Try a fresh copy or another opening method: If the file arrived by email or download, obtain it again from the sender or source. If the workbook opens in Excel for the web but not the desktop app, or vice versa, use the working version to make a separate copy and check for features that may not be supported in that environment.

Open and Repair is a Windows desktop Excel command. Excel for Mac and Excel for the web have different recovery options and interfaces, so do not rely on Windows menu instructions appearing identically there. If the workbook contains business-critical data and the built-in recovery options fail, preserve the original and consult your IT team or a reputable data-recovery specialist. Recovery is not guaranteed, and third-party repair tools should be treated cautiously, especially if they require uploading confidential data.

Ways to reduce the chance of corruption

  • Save regularly, especially before major edits or changes to macros and connections. Use a clear filename or a dated copy when making a risky change.
  • Keep more than one backup. A second copy on another device or an approved cloud service can help if the main storage fails. Confirm that backups can actually be opened; a backup that was never checked may not be useful.
  • Allow saves and uploads to finish before closing Excel, shutting down, or disconnecting a drive. Avoid editing a file while it is still downloading or synchronizing.
  • Use a stable storage location for shared workbooks. Follow your organization’s guidance for OneDrive, SharePoint, or network folders, and resolve sync conflicts rather than casually choosing one version.
  • Maintain free disk space and keep Windows, Excel, and storage-device software appropriately updated. If repeated corruption occurs, check the drive and connection for faults.
  • Keep the workbook in a suitable format. Use .xlsm when VBA macros must be retained, and avoid repeated conversions through applications that do not support the workbook’s features.

For a shared workbook, agree on who edits it and where the authoritative copy lives. A simple example is a team member editing a local download while a colleague changes the cloud copy: both versions may be valid, but the team can mistake a conflict or stale copy for corruption. Clear file ownership and version history reduce that confusion.

Common misconception: a warning does not always mean permanent damage

An Excel error can point to a damaged workbook, but it can also reflect an incomplete download, a file that was renamed with the wrong extension, access restrictions, or a format that Excel does not support as expected. Conversely, a workbook that opens is not necessarily fully healthy: repair may have removed a chart, object, or other component. Verify the data and features that matter before relying on a recovered file.

Frequently Asked Questions

Can a corrupted Excel file be repaired?
Sometimes. Excel’s Open and Repair command may restore a workbook or extract some data, and a backup or earlier version may be more complete. Success depends on what was damaged, so preserve the original and check recovered content carefully.

Does Excel corrupt files automatically?
Excel is not normally expected to damage a workbook during ordinary use. A crash, interrupted save, storage fault, problematic add-in, or incompatible file operation can cause a failure around the time Excel is being used, but the exact cause may require checking the file and device.

Can OneDrive cause an Excel file to become corrupted?
A sync interruption or conflicting edits can leave users with an incomplete, conflicting, or outdated copy. That is not the same as proving that OneDrive damaged the workbook. Check sync status and version history, then compare copies before restoring or overwriting anything.

Why does Excel say the file format or extension is not valid?
The extension may not match the file’s actual format, the download may be incomplete, or the file may be damaged. Confirm the sender’s intended format and obtain a fresh copy before changing the extension. Renaming alone does not convert a workbook.

Will changing .xlsx to .xls fix a corrupted file?
No. Changing the extension only changes the filename, not the workbook’s internal format or damaged content. Use Excel’s Save As command for a real format conversion, and only after you can open the workbook and understand which features the target format may not preserve.

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.