If an Excel file is corrupted and cannot be repaired, stop working on the original, make a separate copy, and try recovery options in order: Excel’s Open and Repair command, a previous cloud or backup version, and data extraction or another spreadsheet app. A repair attempt can discard damaged content, so preserve the file first; if it contains important information, do not overwrite it while experimenting.
Protect the file before trying repairs
Close Excel and make a copy of the workbook using File Explorer, Finder, or your cloud storage service. Keep the original unchanged and give the copy a clear name, such as Sales_original.xlsx and Sales_repair-copy.xlsx. If the file is on a USB drive, network share, or syncing folder, copy it to a local drive before attempting repair. A weak connection or interrupted sync can cause errors that resemble workbook corruption.
Check that the file has a plausible size and extension. An Excel workbook may use formats such as .xlsx, .xlsm, or the older .xls format. A file that is zero bytes, unexpectedly tiny, or still downloading may be incomplete rather than repairable. Do not simply rename a file to a different extension: changing the name does not convert its contents into another format.
- Close other Excel windows that may have the workbook open.
- Make a working copy before using repair tools or another spreadsheet program.
- If the file came from email or the web, confirm it came from a source you trust; do not enable macros just to open it.
- Write down any error message. “File format or file extension is not valid,” a blank workbook, and a repair log can point to different problems.
What Excel file corruption means
An Excel workbook is more than a grid of visible cells. It can contain worksheets, formulas, formatting, charts, tables, names, links, pivot information, macros, and other workbook settings. If part of the file’s stored structure is incomplete or inconsistent, Excel may refuse to open it, display a repair notice, or open it with some content missing.
Corruption does not always mean every sheet is lost. A damaged chart or style record may affect only one feature, while a truncated file can prevent Excel from reading much of the workbook. Nor does an error necessarily prove corruption: a wrong extension, insufficient access permissions, a blocked download, an unsupported feature, or a file still being synchronized can produce similar symptoms. Testing a copy on a local drive helps separate those issues from damage inside the workbook.
Use Open and Repair in Excel for Windows
In Microsoft 365 Excel for Windows, use the built-in repair command on a copy of the workbook. Open Excel first rather than double-clicking the damaged file, then follow these steps:
- Choose File > Open > Browse.
- Select the workbook once in the file picker.
- Select the arrow beside the Open button, then choose Open and Repair.
- Choose Repair first. If that does not work, repeat the process and choose Extract Data, if offered.
Repair attempts to restore as much workbook structure as possible. Extract Data is a fallback aimed at retrieving values and formulas when a normal repair fails; it may not preserve formatting, charts, objects, or every formula. Read any repair report Excel displays, and save a successful result under a new filename. Then inspect the repaired workbook rather than assuming it is complete.
If Open and Repair is unavailable or fails immediately, check that Excel is up to date and that the copy is stored locally. You can also try opening a duplicate from Excel’s Open screen. Do not repeatedly save over the damaged original: each save can replace the only copy that might still be useful to another recovery method.
Look for a previous or unsaved version
A clean earlier version is often a better recovery than attempting to reconstruct a badly damaged workbook. If the file is stored on OneDrive or SharePoint, use its version history and restore or download a version from before the problem began. In Excel for Windows, File > Info > Version History may provide access to versions for a cloud-stored file. The exact options depend on the account, storage location, and organization settings.
For a workbook that was never saved, or changes that disappeared after Excel closed unexpectedly, check File > Info > Manage Workbook > Recover Unsaved Workbooks in Excel for Windows. AutoRecover can help with unsaved work, but it is not a guaranteed backup of every change, and its availability depends on Excel’s settings and whether a recovery copy was created. A recovered draft may be older than the last edits.
Also check Windows File History, a company backup system, or another backup location if one is configured. On a Mac, look for cloud version history or the organization’s backup system and check Excel’s available recovery files. Excel for the web does not provide the same Windows Open and Repair workflow, so use a desktop copy or a known-good prior version for repair attempts.
Salvage data when the workbook still will not open
If Excel can open the file far enough to show sheets, save a copy immediately and transfer important information into a new workbook. Copy one worksheet at a time where possible; a problem in one sheet or object may not affect the rest. For especially valuable data, compare row counts, key totals, and representative formulas against reports or other source records. A workbook that opens is not necessarily a complete workbook.
If the file is an .xlsx or .xlsm workbook, a technician may be able to inspect a duplicate as a ZIP-based package because these formats store workbook components in separate files. This is an advanced option, not a reason to edit the package casually: deleting or changing a component can make the workbook less recoverable. The older .xls format is structured differently, and changing extensions will not make it compatible with ZIP tools.
Another spreadsheet application, such as LibreOffice Calc, may sometimes open a workbook Excel cannot. Test only a copy, and treat the result as a salvage attempt rather than a guaranteed repair. Formulas, macros, external connections, charts, and formatting can change or be omitted when software interprets another program’s workbook format. If it opens, save the recovered content to a new file and verify it in Excel before relying on it.
If Excel can open the workbook but one worksheet is the problem, you may be able to move unaffected sheets into a fresh workbook. Use Home > Format > Move or Copy Sheet, select a new workbook as the destination, and copy rather than move the sheet. If that command is unavailable or copying triggers an error, do not force it; retrieve the sheet’s values by copying visible ranges or exporting data where possible.
Common causes and misleading symptoms
Workbooks can become damaged after an application or computer shuts down during a save, a drive or network connection fails, cloud synchronization is interrupted, or storage media develops errors. The file may also be incomplete after a failed download or transfer. These are possible causes, not proof of what happened in a particular case.
Some symptoms have simpler explanations. If Excel says the extension does not match the format, check whether the file was renamed or downloaded incorrectly. If you see a permissions message, confirm that you can access the folder and that the file is not open exclusively by another person. If a workbook opens in Protected View, that is a security precaution for an internet-origin file, not by itself evidence of corruption. Only enable editing or macros when the source is trusted and the action is necessary.
Choosing a recovery route and weighing the risks
Use the least destructive option that can meet your goal. If you need the exact workbook, including macros, charts, and formatting, prioritize a previous version or backup. If you mainly need the underlying numbers, Extract Data, a sheet-by-sheet copy, or an alternate application may recover useful content even when presentation features are lost.
- Need the whole workbook intact: try cloud version history or a verified backup before intensive repair.
- Need a recent unsaved draft: check Excel’s recovery options, then compare its timestamp and contents with what you remember.
- Need values from a workbook that will not repair: try Extract Data or a carefully controlled copy in another spreadsheet app.
- Need a macro-enabled workbook: preserve the .xlsm original and check that macros and other code remain present; never enable unknown macros as a recovery shortcut.
Commercial recovery software and repair services may be offered for damaged files, but results are not guaranteed. Before paying, check the provider’s privacy and deletion terms, especially if the workbook contains payroll, customer, medical, or business information. Avoid uploading confidential files to an unfamiliar online repair site. For a business-critical file on a failing drive, stop repeated attempts and ask your IT team or a reputable data-recovery professional about preserving the storage device.
Prevent the next workbook loss
Turn on AutoSave for supported files stored in OneDrive or SharePoint, and use version history where available. AutoSave is useful for ongoing changes, but it does not replace an independent backup. Keep periodic copies in a separate location, especially before major edits, importing large datasets, or running macros. A backup is only useful if it can be retrieved, so occasionally confirm that the saved copy opens.
Close Excel normally and wait for save or sync indicators to finish before shutting down or disconnecting a drive. Avoid editing the same file simultaneously in conflicting locations, and investigate recurring disk or sync errors instead of treating each damaged workbook as an isolated incident. For sensitive files, follow your organization’s approved storage and backup policies.
Frequently Asked Questions
Can a corrupted Excel file be repaired?
Sometimes. Open and Repair can restore some workbooks, and version history or backups may provide a complete earlier copy. If the file is severely truncated or its storage is failing, recovery may be partial or impossible.
Where is Open and Repair in Excel?
In Excel for Microsoft 365 on Windows, choose File > Open > Browse, select the workbook, choose the arrow beside Open, and select Open and Repair. Work on a copy and try Repair before Extract Data.
Will Open and Repair keep my formulas and formatting?
It may keep much of the workbook, but no repair can promise that every formula, style, chart, macro, or object will survive. Extract Data is more focused on recovering usable values and formulas and can lose presentation features. Inspect important sheets and compare key results.
Can I recover an Excel file I never saved?
Possibly. In Excel for Windows, check File > Info > Manage Workbook > Recover Unsaved Workbooks. Recovery depends on whether Excel created a temporary recovery copy, so it may be missing or out of date.
Should I change .xlsx to .xls to make the file open?
No. Renaming changes only the filename, not the workbook’s internal format. Use Excel’s repair or recovery options, or obtain the file again from its source if the extension was assigned incorrectly.
Related
- Excel Consolidate Multiple Sheets Into One: 4 Methods
- Excel: How to Consolidate Multiple Rows Into One Cell
- Excel Consolidate and Empty Cells: What Happens?
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Can You Use Solver in Excel for the Web? What WorksNo: Microsoft’s Solver add-in cannot be run in Excel for the web, so you can’t set up or…
- Excel This Action Won’t Work on Multiple SelectionsThe Excel message “This action won’t work on multiple selections” usually means the command needs one continuous, rectangular…
- COUNTIFS Syntax in Google Sheets: Examples and TipsGoogle Sheets uses =COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...]) to count rows that meet two or more conditions at…
- How to Delete a Page in Word Using a Keyboard ShortcutTo delete a page in Word on Windows, press Ctrl+G, type \page in the page-number box, press Enter,…
- Power Query Append Tables in Excel: How to Combine RowsYes. In Excel for Microsoft 365, Power Query appends tables by stacking their rows into one result: load…
- Edit Data Validation in Excel: Lists, Rules, and FixesTo edit data validation in Excel for Microsoft 365 on Windows, select a cell that uses the rule,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.