If an Excel file keeps getting corrupted, first make a copy of it, then try Excel’s built-in repair: in Microsoft 365 for Windows, choose File > Open > Browse, select the file, click the arrow beside Open, and choose Open and Repair. If the problem returns after repair, investigate where and how the workbook is saved, as well as Excel add-ins and the computer’s storage; repeated damage is often a sign of a recurring problem rather than a one-time glitch.
What “corrupted” means in Excel
An Excel workbook contains more than the values visible in its cells. It also stores formulas, formatting, charts, tables, defined names, connections, and other workbook structures. A damaged or incomplete file may stop Excel from interpreting some of that information correctly. Excel might show a message that the file format or extension is invalid, report that it found unreadable content, freeze while opening, or open the workbook with missing features.
Those symptoms do not prove the workbook itself is damaged. A slow network connection, an unavailable linked file, a broken add-in, an outdated Excel installation, or an incompatible file format can cause errors that look similar. A useful first test is to open other workbooks. If only one particular file fails, focus on that file and its storage location. If several unrelated workbooks fail, investigate Excel, add-ins, and the computer instead.
First steps to protect the workbook
Before attempting repairs, preserve the original. If the file is on a shared drive, OneDrive, SharePoint, or a removable device, copy it to a folder on the computer and work on the copy. Do not repeatedly overwrite the only version that may still contain recoverable data. If Excel opens the file, use Save As to create a separate working copy before making changes.
- Record the exact error message and when it appears: while opening, saving, calculating, or syncing.
- Check whether the file size is plausible. A file that suddenly has a size of zero or is much smaller than expected may have been incompletely saved or transferred.
- Try opening the copy from a local folder, not directly from a network share, USB drive, email attachment, or sync folder.
- If the workbook is shared, ask whether another person or process was editing it at the same time.
A file that opens successfully from a local copy but fails in its original location points toward a storage, permissions, or sync issue. It does not necessarily mean the local copy is permanently fixed; keep a protected original until the workbook has been checked and saved safely.
Common reasons a workbook gets damaged repeatedly
Interrupted saves are a frequent suspect. If Excel, Windows, a connected drive, or the computer loses power or stops responding during a save, the file may not finish writing. The same risk applies when a laptop closes, a removable drive is unplugged, or a network connection drops during a transfer. A crash does not always corrupt a workbook, but repeated interruptions make reliable saving more difficult.
Sync and collaboration can introduce another layer of complexity. OneDrive and SharePoint keep versions and coordinate changes, but a paused sync, conflicting edits, limited storage, or a short-lived connection problem can leave users looking at different copies or an older version. A workbook that is open on several computers, or is also being edited by software outside Excel, deserves particular care. Wait for sync to finish before closing or moving the file, and check version history if the latest saved copy is wrong.
Other possible causes include failing storage, file-system errors, security software interfering with file access, and third-party programs that create or modify Excel workbooks. Very large or complex workbooks can also take longer to save and are more vulnerable to interruptions or resource limits, although size alone does not mean a file is corrupt. If damage occurs across many files on one device, check the drive and system reliability rather than repeatedly repairing each workbook.
Check the file format and how it is being used
Use a format suited to the workbook. Excel Workbook (.xlsx) is the standard choice for workbooks without VBA macros. Excel Macro-Enabled Workbook (.xlsm) is needed when the workbook contains macros that should be retained. Excel Binary Workbook (.xlsb) is another Excel workbook format that can be useful for some large files, but changing formats is not a universal corruption fix. Before converting a workbook, save a separate copy and confirm that required features remain intact.
CSV files are different: they store tabular text, generally one sheet at a time, and do not preserve workbook features such as formulas, formatting, charts, or multiple worksheets. Saving a workbook as CSV and reopening it can therefore make it seem as if content was lost, but that is a limitation of the format, not necessarily corruption. Do not use CSV as a backup of a complex workbook.
Also check that the extension matches the file’s actual format. Renaming a file from one extension to another does not convert it. If a downloaded or emailed workbook produces an extension warning, obtain a fresh copy from its source rather than simply renaming it. Be cautious with unexpected attachments: only open files from sources you trust, and do not enable macros just to make an unfamiliar workbook open.
Use Open and Repair, then inspect the result
In Excel for Microsoft 365 on Windows, select File > Open > Browse. In the Open dialog, select the workbook, click the arrow next to the Open button, and choose Open and Repair. If Excel offers a choice, try Repair first. If that does not work, Extract Data may recover values and formulas while leaving some workbook features behind. The repair process can remove damaged content, so compare the result with an earlier version or other reliable source.
If the workbook opens, review important sheets, formulas, charts, named ranges, connections, and macros. Check for missing rows or columns, error values, and formulas that have changed to values. Save the repaired result under a new name and close and reopen that saved copy to confirm it still works. Keep the unrepaired original until you have verified the parts you need.
If Open and Repair cannot recover the file, try opening a known-good earlier version from OneDrive or SharePoint version history, a Windows backup, or your organization’s backup system. Excel may also display a Document Recovery pane after a crash. Recovered versions can be incomplete or older than the last edits, so compare timestamps and content rather than assuming the first recovered file is the newest or best copy.
Work out whether Excel or the file is at fault
Try opening the workbook in Excel on another trusted computer, or open a different workbook on the affected computer. These comparisons help separate a file-specific problem from a local Excel problem. If only one workbook fails everywhere, focus on recovering that workbook. If many files fail only on one computer, update Microsoft 365 through File > Account > Update Options > Update Now, if that option is available, and test Excel without add-ins.
On Windows, close Excel, press Windows key+R, enter excel /safe, and press Enter. Open the workbook from Excel’s File > Open menu. If the problem disappears in safe mode, an add-in or startup item may be involved. In normal Excel, review File > Options > Add-ins. At the bottom, choose COM Add-ins in the Manage box and click Go; clear selected add-ins to test them, then restart Excel. Re-enable them one at a time to identify a possible cause. Do not permanently disable a business-critical add-in without checking with its administrator.
Safe mode is a diagnostic test, not a repair for damaged workbook contents. If the workbook fails in safe mode and on another computer, its data or file format becomes a stronger suspect. If it works elsewhere but not on this computer, look at Excel updates, add-ins, permissions, and local storage health.
Prevent future corruption and make recovery easier
Good saving habits reduce risk, although no setting can guarantee that a workbook will never be damaged. Save important workbooks to a reliable location, wait for cloud synchronization to complete, and avoid disconnecting drives while files are open. Keep a separate backup, especially before major edits, conversions, or changes to macros. A synced folder is helpful, but synchronization alone is not the same as an independent backup: unwanted edits or deletions can sync too.
- Use OneDrive or SharePoint version history where available, and check that the organization retains versions long enough for your needs.
- Keep periodic backups in a separate location or through an approved backup service.
- Close a workbook normally and allow saving or syncing to finish before shutting down or removing storage.
- Install Microsoft 365 and Windows updates through normal, trusted update channels.
- For workbooks generated by another program, ask its vendor whether it supports the Excel format and whether it should finish writing the file before Excel opens it.
AutoRecover can help restore unsaved work after Excel closes unexpectedly, but it is not a substitute for saving and backing up. It may not contain the most recent edits, and it cannot guarantee recovery from every type of file or storage failure. For important work, save regularly and maintain a version that is not being edited.
When to get technical help
Contact your IT team or storage administrator if several workbooks become damaged in the same location, if files disappear or change unexpectedly, or if Windows reports drive errors. Repeated corruption across unrelated documents can indicate a failing disk, unreliable network storage, a permissions problem, or a process that is modifying files. Continuing to save important documents to a potentially failing device may make recovery harder.
For a business-critical workbook that cannot be recovered from version history or backups, avoid experimenting on the only copy. Preserve it as-is and ask IT or a qualified data-recovery provider about next steps. If the workbook contains confidential information, use an approved support channel and do not upload it to an untrusted repair website. A repair tool cannot promise to restore every formula, macro, connection, or formatting detail.
Frequently Asked Questions
Can a corrupted Excel file be repaired?
Often, at least some content can be recovered. Try Open and Repair on a copy, then compare the repaired workbook with a previous version or backup. Excel may not restore every feature, and some files cannot be repaired.
Why does Excel say the file format or extension is not valid?
The extension may not match the file’s actual format, or the file may be incomplete or damaged. Get a fresh copy from the source, check that the extension was not changed by renaming, and try Open and Repair on a separate copy.
Does OneDrive cause Excel files to become corrupted?
OneDrive is not automatically the cause. Sync delays, conflicting edits, or interrupted connections can make it unclear which version is current. Check sync status and version history, and wait for synchronization to complete before moving or closing the file.
Will changing XLSX to XLSB stop corruption?
No. XLSB is a legitimate Excel workbook format, but changing formats does not fix a failing drive, interrupted save, or sync conflict. Save a separate copy before converting, and verify that required workbook features still work.
Is Excel AutoRecover the same as a backup?
No. AutoRecover may help after an unexpected Excel closure, but it can miss recent changes and does not protect against every storage failure. Use regular saves and a separate backup or version history for important workbooks.
Related
- Excel Consolidated Sum: Combine Data Across Sheets
- Excel: Consolidate Two Columns Into One Without Losing Data
- Excel Consolidate Worksheets Into One: Methods & Tips
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel IRR #NUM! Error: Causes and Practical FixesAn Excel IRR formula returns #NUM! when it cannot find a rate that makes the cash flows’ net…
- UPPER Formula in Excel Not Working? Fix the CauseIf Excel’s UPPER formula is not working, first check that the function is spelled correctly and the formula…
- Excel Filter Dropdown Not Working? Fix Common CausesIf an Excel filter dropdown is missing, will not open, or shows the wrong results, first select a…
- Google Sheets Filter Search: Find Data and Fix IssuesTo search data with a filter in Google Sheets, select your data range, choose Data > Create a…
- Excel Weekday Formula Not Working? Causes and FixesIf an Excel weekday formula is not working, first check that the cell contains a real Excel date,…
- Section Break in Word Won’t Delete? Here’s WhyYes, you can remove a section break in Word: show formatting marks, place the cursor immediately before the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.