An Excel file becomes corrupted when its stored data or internal workbook structure is damaged or incomplete, so Excel cannot read it reliably. Common causes include interrupted saves, storage or transfer failures, software crashes, and conflicting file changes; a formula error or an incorrect number in a cell, by itself, is not file corruption.
What “corrupted” means in an Excel workbook
An Excel workbook is more than the values shown in its cells. Depending on its format, it can contain worksheets, formulas, styles, charts, tables, links, macros, images, and other workbook settings. Excel must be able to interpret the file’s structure as well as its contents. If a required part is missing, damaged, or inconsistent, the application may fail to open the workbook, display a repair warning, or open it with some content unavailable.
Modern .xlsx and .xlsm workbooks use a package format made up of related components, including XML files and, where needed, media or other data. Older .xls workbooks use a different binary format, while .xlsb workbooks store workbook content in a binary format. Because the formats differ, the symptoms and recovery options can vary. Changing a file’s extension does not convert it: renaming an .xlsx file to .xls, for example, cannot repair it and may simply make it harder for Excel to identify.
Damage can affect a small part of a workbook or prevent Excel from reading the file at all. A workbook that opens after repair may still have lost a chart, formatting, a sheet, or other content. Conversely, an unreadable file is not always corrupted: an unsupported format, permission restriction, or incorrect file extension can also prevent it from opening.
How an interrupted save can damage a file
Saving a workbook means writing changes to storage. If Excel or the computer stops unexpectedly during that process, the saved file may be incomplete or inconsistent. Examples include a power failure, a forced shutdown, a system crash, or ending Excel while it is still saving. The risk depends on what had already been written and how the application and storage handled the interruption; an interruption does not guarantee damage, but it can leave a file unusable or missing recent changes.
Similar problems can arise if a laptop sleeps, loses power, or is disconnected from a storage device while a workbook is being written. A removable drive that is unplugged too soon, a failing disk, or an unstable network connection can interrupt access to data. A workbook may then contain only its last successfully saved state, or it may fail to open because a write did not finish cleanly.
Excel’s AutoRecover feature can help restore unsaved work after some unexpected closures, but it is not a substitute for saving and keeping backups. AutoRecover information may be incomplete or unavailable, and it may not restore the exact state of a workbook. For important files, use ordinary saves as well as a separate backup or a storage service with version history.
Storage, transfer, and synchronization problems
Errors can occur outside Excel while a workbook is stored or moved. A failing hard drive or solid-state drive, damaged removable media, filesystem errors, or a faulty storage controller can affect file data. Copying a workbook over a network that disconnects midway may leave an incomplete destination copy. Transfers through email, messaging services, or file-conversion tools can also change a file or fail before the transfer is complete.
Cloud storage and synchronization deserve careful explanation. Services such as OneDrive can keep version history and support recovery, but a sync interruption or competing edits can still create a stale copy, a conflict copy, or confusion about which version is current. That is not the same as saying cloud storage routinely corrupts Excel files. Coauthoring and synchronization are designed to support shared work, but users should wait for syncing to finish before shutting down or moving a file and should check for conflict notifications when several copies exist.
For example, suppose two people edit separate downloaded copies of the same workbook and later upload one over the other. The likely problem is lost or conflicting changes, not necessarily structural corruption. If a sync client or transfer is interrupted while writing the workbook, however, a particular copy could be incomplete. Keep the original and any conflict copies until you identify which version contains the needed data.
Other causes: add-ins, tools, and security incidents
Excel add-ins and third-party applications can read or modify workbook files. A bug, incompatible tool, or failed conversion may save malformed or incomplete content. The same can happen when a program generates an Excel-compatible file but does not correctly implement the format. Opening a file in another spreadsheet application and saving it back may also alter features that the other application does not support. This may remove or change content without making the workbook wholly unreadable.
Malware or other unauthorized software may modify, encrypt, or delete workbook files. Ransomware commonly makes files inaccessible by encrypting them; that is a security incident, not simply a routine Excel save error. If files have suddenly changed names, become encrypted, or many documents are affected, disconnecting from shared storage and contacting the organization’s IT or security team is safer than repeatedly opening or repairing files. Restore from a known-clean backup only after the security issue has been addressed.
Excel’s Protected View, a password prompt, or a warning that a file came from the internet does not by itself mean the workbook is corrupted. Those are security controls. Likewise, a blocked macro, disabled external link, or formula error such as #REF! concerns workbook behavior or content, not necessarily the integrity of the file structure.
What corruption looks like—and what it is not
Excel may show a message that it found a problem with the file, that it cannot open or read the workbook, or that it repaired or removed some content. Other signs include a workbook that hangs while opening, missing sheets or objects after a repair, or a file whose size unexpectedly becomes zero or much smaller. None of these signs proves corruption on its own. A damaged installation, access restrictions, an unsupported format, or a file that is still syncing can produce similar symptoms.
Distinguish file damage from a mistake inside a workbook. Wrong values, broken formulas, accidental deletion, and incorrect formatting can happen in a perfectly healthy file. These are content or calculation problems. File corruption refers to damage that affects Excel’s ability to interpret the saved workbook correctly. A workbook can also have both issues at once—for instance, an intact workbook might contain a mistaken formula, while a separate interrupted save damages a later copy.
Before troubleshooting, note the exact message, the file extension, and whether the problem affects one workbook or many. If only one file fails, suspect that copy, its storage location, or its format first. If many workbooks fail, consider a wider issue such as a storage device, Excel installation, add-in, or security incident.
How to try recovery without risking the only copy
Start by preserving the file. Do not overwrite it with a repaired version or repeatedly save changes into the only copy. Make a duplicate on reliable local storage, and keep the original untouched. If the workbook is on a network or removable drive, copy it only after confirming the source is accessible and the copy completes.
- Look for a known-good version. Check the organization’s backup system, OneDrive or SharePoint version history, or another location where an earlier copy may have been saved. Compare dates and file sizes, and preserve the damaged version in case it contains newer recoverable work.
- Use Excel’s repair option on Windows. In Microsoft Excel for Microsoft 365, choose File > Open > Browse, select the workbook, click the arrow beside the Open button, and choose Open and Repair. Try Repair first. If Excel cannot repair the workbook, the option to extract data may recover some values or formulas, but it may not preserve every feature.
- Check the result carefully. If the file opens, inspect sheet names, key values, formulas, charts, tables, formatting, and links. A successful opening is not proof that every component survived. Save a recovered workbook under a new name and retain the original.
- Use platform-appropriate recovery options. Excel for Mac has a different interface and recovery behavior from Excel for Windows, so the Windows Open and Repair steps may not be available in the same form. On Mac, check AutoRecovery and any cloud or organizational version history, and work from a copy. Excel for the web may handle some files differently; download a copy before trying changes if the original is important.
Third-party repair utilities may claim to rebuild a workbook, but they require access to sensitive file contents and can produce incomplete results. For confidential or business-critical files, follow your organization’s approved recovery process. Avoid uploading sensitive workbooks to an unknown website just to test a repair claim.
Ways to reduce the chance of damage
No storage method can eliminate every failure, but a few habits make both corruption and data loss less likely. The most useful protection is keeping recoverable copies separate from the working file.
- Save important work regularly, and wait for Excel or the sync service to finish before closing the workbook or shutting down.
- Keep backups or use a service with version history. A second copy on the same failing device is not a reliable backup.
- Use stable storage for active workbooks. Avoid unplugging external drives during saves, and move files only after a copy operation completes.
- Install Excel and operating-system updates through trusted channels, and use reputable security software to reduce malware risk.
- Be cautious with unfamiliar add-ins, file converters, and tools that rewrite workbooks. Keep a copy before converting a file or testing a new tool.
- For shared workbooks, agree on a single location and workflow. Check sync status and resolve conflict copies rather than assuming all copies contain the same edits.
Large or complex workbooks can take longer to save and use more system resources, making interruptions more consequential. That does not mean a large file is inherently corrupt. If saving becomes unusually slow, investigate available disk space, workbook complexity, add-ins, and storage reliability rather than repeatedly forcing Excel to close.
Frequently Asked Questions
Can an Excel file become corrupted just by opening it?
Ordinarily, opening a workbook does not corrupt it. A file may already be damaged, or an add-in, security incident, or failure during a later save may affect it. If Excel displays a repair prompt, preserve a copy before proceeding.
Do formula errors mean my workbook is corrupted?
No. Errors such as #VALUE! or #REF! usually indicate a formula or reference problem within the workbook. They can appear in a structurally healthy file. Corruption is more likely when Excel cannot read the workbook or reports that it repaired or removed file content.
Can I repair a corrupted Excel file without losing data?
Sometimes, but there is no guarantee. Excel may repair a workbook or extract some data, while a backup or version history may provide a more complete copy. Work on a duplicate, then compare recovered sheets and important content with other available versions.
Does changing .xlsx to .xls fix a file that will not open?
No. Renaming changes the filename extension, not the file’s internal format. It can cause Excel or another program to interpret the file incorrectly. Use Excel’s repair or recovery options, or restore a valid copy, instead of treating a rename as a conversion.
Is a file that will not open always corrupted?
No. The file may be in an unsupported format, have the wrong extension, be inaccessible because of permissions, or still be syncing. Check the file’s source and format, confirm that you can access it, and try a known-good copy before concluding that its contents are damaged.
Related
- Excel ZIP Code Heat Maps: How to Build and Read Them
- Heat Map in Excel: How to Create One
- Group Rows in Excel by Cell Value
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Microsoft Word Styles and Formatting: A Practical GuideMicrosoft Word styles are named sets of formatting—such as font, size, spacing, and paragraph alignment—that you can apply…
- Excel Lock Slicer in Place? Position and Protect ItYes. In Excel for Microsoft 365 on Windows, select the slicer, open Size and Properties, and under Properties…
- Track Changes in Word Anonymously Without Exposing NamesTo track changes in Word without showing your personal name, first set Word’s author information to a neutral…
- How to Make a Flowchart in Microsoft Word Step by StepTo make a flowchart in Microsoft Word, use Insert > Shapes to add and label flowchart symbols, then…
- Excel Notched Box Plot: What It Shows and How to Make OneExcel for Microsoft 365 can make a standard Box & Whisker chart, but it does not have a…
- Google Sheets Merge Cells Command and How to Use ItTo merge cells in Google Sheets, select the cells, then choose Format > Merge cells > Merge all.…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.