Excel File Not Opening? Fix Corruption and Recover Data

If an Excel file will not open and Excel reports corruption, make a copy first, then try File > Open > Browse, select the copy, choose the arrow beside Open, and select Open and Repair. Choose Repair first; if that fails, try Extract Data to recover values and formulas where possible.

What an Excel corruption message means

A workbook can become unreadable when part of its file structure is damaged, incomplete, or inconsistent. Excel workbooks such as .xlsx files contain multiple linked parts, including worksheet data, formatting, formulas, and workbook settings. If a part Excel needs cannot be read, the program may refuse to open the file, display a repair notice, or open it with missing content.

However, a message that sounds like corruption does not prove the workbook itself is damaged. Excel may also reject a file because its extension does not match its actual format, a download or cloud sync stopped partway through, access is restricted, or an add-in is interfering with Excel. The wording of the error and whether other workbooks open normally can help narrow down the cause.

For example, “Excel cannot open the file because the file format or file extension is not valid” can indicate a mismatch between the extension and the file contents, not necessarily damaged worksheet data. Avoid changing .xlsx to .xls or another extension as a repair method: renaming changes the label, not the contents, and can make it harder to identify the real format.

Protect the original before troubleshooting

Before attempting a repair, preserve the file as it is. Repair attempts, repeated downloads, or manual edits can complicate recovery, and an overwritten original may remove the best available source. Close Excel if it is already displaying a repair prompt, then make a separate copy using File Explorer.

Copy the file to a local folder, such as Documents, and give the copy a clear name like Budget-recovery-copy.xlsx.
If the file is on a network drive, USB device, or cloud-synced folder, copy it locally before trying to open it.
Check that the file size is plausible and not zero bytes. A zero-byte file generally contains no workbook data to repair.
Keep the original untouched until you have checked the recovered workbook and saved a separate usable version.

If the file came from an email or download, obtain it again from the sender or source when possible. A fresh copy can resolve a truncated transfer without changing anything in Excel. For a OneDrive or SharePoint file, check whether another version is available before relying on a repair attempt.

Use Open and Repair in Excel for Windows

In Microsoft 365 Excel for Windows, Open and Repair is the built-in first repair option for a workbook that will not open normally. Use it on the local copy, not the sole original:

Open Excel, then select File > Open > Browse.
In the Open dialog, browse to and select the copied workbook. Do not double-click it.
Select the arrow next to the Open button, then choose Open and Repair.
When prompted, select Repair. Let Excel finish, then review the workbook for missing sheets, formulas, formatting, or other changes.
If Repair does not work, repeat the process and choose Extract Data. Excel may offer to recover values or formulas, but this route may not preserve the workbook’s full appearance or features.

Open and Repair is an attempt, not a guarantee. A workbook may open with a repair log or warning, and some objects or content may be lost if their underlying data is too damaged. If Excel does open it, immediately use File > Save As to save the result under a new name and, if appropriate, the .xlsx format. Then close and reopen that saved copy to confirm it works.

The Open and Repair command is available in desktop Excel for Windows. Excel for Mac does not use the same Windows dialog path. On a Mac, first make a copy, open Excel, and try opening the copy through File > Open. If it still fails, try a previous cloud or backup version, or ask someone with desktop Excel for Windows to attempt Open and Repair on a copy.

Tell file damage apart from an Excel problem

A quick comparison can show whether the problem follows one workbook or affects Excel more broadly. Try opening a different, known-good workbook in the same Excel installation. If other files work, the affected workbook or its location is more likely to be involved. If multiple unrelated workbooks fail, investigate Excel, an add-in, or the computer environment before assuming every file is corrupted.

Only one workbook fails: Try a fresh download, a local copy, Open and Repair, or an earlier saved version.
Files from one location fail: Check network access, cloud sync status, file permissions, and whether the transfer completed.
Many workbooks fail: Start Excel in Safe Mode on Windows by pressing Windows key + R, typing excel /safe, and pressing Enter. If a workbook opens in Safe Mode, an Excel add-in or startup setting may be contributing.
Excel itself will not start: The issue may be the Office installation or another system problem rather than one workbook’s contents.

Safe Mode is a diagnostic step, not a workbook repair. If it changes the result, disable add-ins one at a time using File > Options > Add-ins in regular Excel, then check whether the issue returns. Add-in controls and availability can vary by add-in type. If Safe Mode makes no difference and only one workbook remains affected, return to file-specific recovery rather than repeatedly changing Excel settings.

Check versions, backups, and cloud history

When repair cannot restore a workbook, an earlier copy may be more complete than a damaged current copy. Look for a version saved before the problem began. In OneDrive or SharePoint, use the file’s version history if it is available to your account and location. You can also check Windows File History, a backup service, a manually saved copy, or the sender’s original attachment. Availability depends on whether those features were set up and whether a prior version exists.

For a workbook stored in OneDrive, confirm that syncing has finished and that you are opening the intended file, not a stale or partially synchronized copy. If necessary, download a separate copy and open that locally. For a network share, ask whether another user can open the same file and whether the file is currently being edited or access is restricted. Do not delete temporary or lock files indiscriminately; they may relate to an active editing session.

Excel may also offer recovery options after an unexpected shutdown. In Windows desktop Excel, check File > Info > Manage Workbook for available recovered or unsaved versions. The exact entries depend on what Excel was able to save and on the application’s recovery settings. This is different from repairing a damaged file: an AutoRecover version may be older, incomplete, or absent.

What may not survive a repair

A workbook is more than the numbers visible in cells. It can include formulas, cell formatting, charts, pivot tables, comments, data connections, macros, external links, and embedded objects. Repair may recover some parts but not others. Extract Data is useful when the priority is getting readable cell content back, but it should not be expected to recreate every layout, connection, or workbook feature.

After a repaired workbook opens, check it against a known source where possible. Review sheet names and row counts, inspect important formulas, look for blank areas or unexpected error values, and verify charts or pivot tables that matter to your work. If the original is macro-enabled (.xlsm), do not assume that a repaired or newly saved workbook retained its macros; confirm that required code and functionality are present before using it. Keep the original file and any repair log until you are confident the recovered version is suitable.

A repaired workbook can also contain stale external links or data connections. If Excel asks whether to update links, do not approve updates automatically unless you recognize the sources and expect current data. For a business-critical workbook, compare recovered figures with the source system or another trusted copy before using them to make decisions.

When to stop and seek another recovery route

If the workbook contains important or sensitive data and both Repair and Extract Data fail, avoid experimenting on the only copy. Preserve it, record the exact error text, and consult your organization’s IT support or a reputable data-recovery professional. Recovery cannot be guaranteed, especially if the file is empty, severely truncated, or overwritten. For workbooks containing confidential information, check your organization’s security rules before uploading the file to an online repair service.

For less critical files, compare the time and risk of further attempts with the value of rebuilding the workbook from source data. If the data exists in a database, accounting system, exported report, or another person’s copy, obtaining it again may be safer than trying to reconstruct damaged workbook components. Once recovered, save a clean copy and set up an appropriate backup or version-history process so a future failure does not depend on a single file.

Frequently Asked Questions

Can I repair a corrupted Excel file without opening it?
Yes. In Excel for Windows, use File > Open > Browse, select the file, and choose Open and Repair from the arrow beside Open. Work on a copy and understand that repair may not preserve every workbook feature.

Will Open and Repair recover every formula and sheet?
No. It may restore the workbook, but content that is too damaged can be missing or altered. Check important sheets and formulas after opening, and use Extract Data if normal repair fails and recovering cell content is the priority.

Does changing the file extension fix an Excel corruption error?
Usually not. Renaming a file does not convert its format or repair its contents. If Excel says the extension and format do not match, get a fresh copy or confirm the file’s true format rather than guessing a new extension.

Why does the workbook open on another computer but not mine?
The file may be intact while your Excel installation, add-ins, permissions, or local copy cause the problem. Try a local copy, compare Excel versions, and test whether other workbooks open. On Windows, Safe Mode can help identify an add-in-related issue.

Can Excel for the web repair a damaged workbook?
Excel for the web may open some workbooks that behave differently in desktop Excel, but it does not provide the Windows desktop Open and Repair command. Try a separate copy, and use desktop recovery or an earlier version if the web app also cannot read it.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.