Why Did My Excel File Get Corrupted? Causes and Fixes

Your Excel file most likely became corrupted because Excel or another program could not finish saving it correctly, or because the file was damaged while being stored, transferred, or synchronized. The exact cause depends on what happened just before the problem appeared; a file that will not open is not necessarily corrupted, so make a copy and check the error message before trying repairs.

What Excel file corruption means

An Excel workbook contains more than the numbers and text visible on a worksheet. An .xlsx file is a package of related components, including worksheet data, formulas, formatting, workbook settings, and other information. Excel needs those components to fit together well enough to read the file. If a component is incomplete or inconsistent, Excel may warn that it found a problem, fail to open the workbook, or open it with some content missing.

Corruption can affect the whole workbook or only part of it. For example, Excel might recover the cell values but remove a damaged chart, drawing, or formatting record. That is different from a formula returning an error such as #REF! or a workbook opening with outdated linked data: those problems can be serious, but do not by themselves prove that the file structure is damaged.

Common ways a workbook gets damaged

The most common pattern is an interruption while a workbook is being written or moved. Saving updates the file on its storage location; if the program, computer, connection, or storage device stops responding at the wrong moment, the saved result may be incomplete. Excel has safeguards, but they cannot prevent every interruption or storage failure.

Excel or Windows closes unexpectedly: A crash, forced shutdown, power loss, or restart during a save can leave an incomplete update. A crash while the workbook is open does not automatically mean the file is corrupt; the risk is greater if a save was in progress.
A network or cloud connection drops: Saving to a shared drive or synchronized folder can fail if the connection is interrupted. Sync services may also encounter competing edits or conflicts when several devices or people change a file around the same time.
A storage device has a problem: A failing hard drive, USB flash drive, memory card, or network storage system can return incomplete or damaged data. Repeated errors when opening several files from the same device are a reason to investigate the storage, not just Excel.
Another program changes the workbook: Some spreadsheet editors, file-conversion tools, and automated systems do not preserve every Excel feature. Re-saving a complex workbook in a different application or format can remove or alter features, though that is not always structural corruption.
A save or transfer is interrupted: Copying a large file while the device is disconnecting, or terminating a conversion before it finishes, can produce an incomplete copy. The original may still be intact.
An add-in or automation process interferes: An Excel add-in, script, or macro that crashes or handles files incorrectly may contribute to a failed save. This is less likely than a straightforward interruption, but worth considering if the issue recurs during a particular automated task.

Malware is possible, but it is not the default explanation for an Excel file that suddenly will not open. Avoid assuming a cyberattack from a repair warning alone. If you see suspicious file extensions, unexpected encryption demands, or problems affecting many files, stop opening affected files and follow your organization’s security process.

Clues that help identify the cause

Think about when the failure started and whether the problem follows the file, the computer, or the storage location. If only one workbook fails everywhere, damage to that particular copy is more plausible. If many workbooks on one USB drive fail, the drive or transfer process deserves attention. If the same workbook opens on another computer, the original computer’s Excel installation, add-ins, permissions, or available resources may be involved.

Check the timing, too. A warning immediately after a power cut or interrupted save points toward an incomplete write. A problem that began after converting the file, editing it in another spreadsheet program, or moving it through a sync folder suggests checking for a changed or conflicted copy. Compare file names, locations, and modification times, but do not treat a recent timestamp as proof that the contents were saved correctly.

Read Excel’s actual message carefully. “Excel cannot open the file” can also result from an incorrect file extension, insufficient permissions, a blocked download, or an unsupported format. A workbook that opens but reports that it repaired or removed records provides a more specific clue: note what Excel says it changed and check the affected sheets, formulas, charts, and other features afterward.

How to try opening the file safely

Start by preserving the evidence. Do not keep overwriting the only copy while experimenting. In File Explorer, copy the workbook to a separate folder or another drive, then try repairs on the duplicate. If the file is stored in OneDrive or SharePoint, check that location’s version history before replacing or deleting anything; an earlier version may be easier to recover than a damaged current one.

Check the file and its location. Confirm the name and extension, make sure the file has finished downloading or syncing, and verify that you have permission to open it. If it is on a network drive or removable device, copy it to a local folder and try that copy.
Use Excel’s repair option. In Excel for Microsoft 365 on Windows, select File > Open > Browse. Select the workbook, choose the arrow beside the Open button, and select Open and Repair. Choose Repair first. If that does not work, try Extract Data if Excel offers it; this may recover values and formulas while losing other workbook content.
Check what Excel recovered. If the workbook opens, save the recovered result under a new name and inspect all important sheets. Look for missing charts, formatting, formulas, names, links, and macros. Excel’s repair is an attempt to recover readable content, not a guarantee that every feature remains unchanged.
Try another copy or version. Look for an earlier backup, an email attachment, a version in cloud storage, or a copy on another device. A known-good earlier version is often safer than repeated repair attempts on the only file.

On Excel for Mac, the Windows-specific Open and Repair menu path may not be available in the same form. Check the current Mac version’s File > Open options and use a backup or cloud version if repair is not offered. Excel for the web may display a workbook but does not provide every desktop repair feature; download a copy and try the Windows desktop app when appropriate.

Recovering content when repair fails

If Excel cannot repair the copy, check for recovery options before turning to third-party tools. In Excel for Microsoft 365 on Windows, look under File > Info for workbook management and available versions. Excel may also show a Document Recovery pane after an unexpected closure. Options and availability depend on whether AutoRecover was enabled and whether Excel retained a usable recovery file.

For future workbooks, AutoRecover settings are under File > Options > Save on Windows. AutoRecover can preserve periodic recovery information, but it is not the same as a dependable backup and may not contain the latest edits. OneDrive or SharePoint version history can provide another route when the workbook was stored there and versioning is available. A local backup or a separately stored copy is valuable for files that cannot be replaced.

If you use a recovery service or tool, work from a duplicate and consider the sensitivity of the workbook before uploading it. Financial, personal, or business data should not be sent to an unknown website. If a file is important and no backup exists, a qualified data-recovery professional may be more appropriate than repeated attempts that could overwrite recoverable data.

Problems that look like corruption but may not be

A file can seem broken even when its internal structure is readable. A workbook saved with the wrong extension, for example, may not open as expected; changing the extension alone does not convert the file’s contents. Password protection, permissions, a blocked internet download, missing fonts, disabled macros, and links to unavailable source files can also cause confusing behavior without proving corruption.

Likewise, a workbook that opens slowly, displays old values, or shows formula errors may have calculation, link, or performance problems. If the file opens, save a copy before changing settings or removing content. Check whether formulas calculate, whether external links point to accessible files, and whether the expected sheets are present. Do not remove security protections or enable macros just because Excel displays a warning; first confirm the workbook’s source and whether you trust it.

How to reduce the chance of it happening again

No storage method can eliminate every risk, but a few habits make an interrupted save less damaging and recovery more likely:

Save important workbooks in a stable location, and wait for a cloud or network service to finish syncing before shutting down or disconnecting.
Keep a separate backup or use version history. Synchronization alone is not always a backup: an unwanted edit or deletion can sync as well.
Use a reliable power source and avoid forcing Excel or Windows to close while a save is underway.
Keep Excel and Windows updated, especially if the issue repeats, while remembering that updates cannot repair a failing drive or restore missing data.
For complex workbooks, avoid unnecessary conversions between file formats or spreadsheet applications. Keep a copy in the original format before making a conversion.
Investigate recurring problems across multiple files. Check the storage device and connection, and ask your IT support team about shared-drive or synchronization issues when relevant.

For ordinary workbooks, .xlsx is a common format, while macro-enabled workbooks use .xlsm. Saving in a format that does not support a workbook’s features can remove them or prompt a warning. Choose the format that matches the content, and read Excel’s compatibility messages rather than assuming every save option preserves everything.

Frequently Asked Questions

Can I tell exactly why my Excel file got corrupted?
Not always. Excel’s message may identify damaged or removed content, but it usually cannot establish whether the underlying cause was a crash, storage fault, sync conflict, or another event. The timing and whether other files are affected help narrow it down.

Does closing Excel without saving corrupt a workbook?
Usually, closing without saving discards unsaved changes and leaves the last saved version intact. A crash or shutdown during an active save is a different situation and can leave the latest copy incomplete.

Will Open and Repair restore everything?
No. It may recover the workbook, but Excel can remove damaged components, and some content may not be recoverable. Save the result as a new file and check important data and features against a backup or other trusted copy.

Should I change .xlsx to .xls to fix the file?
No. Renaming the extension does not convert the workbook or repair its contents. It can make the file harder to identify. Use Excel’s supported opening or repair options, or restore a correctly named backup.

Is my file corrupted if Excel shows a formula error?
Not necessarily. Errors such as #REF! can result from a deleted cell or broken formula reference in an otherwise readable workbook. If the workbook opens, investigate the formula or its links separately from structural file corruption.

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.