iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
Make a copy of the workbook first, then use Excel’s built-in recovery path: File > Open > Browse, select the file, open the arrow beside Open, and choose Open and Repair. Choose Repair first; if that fails, repeat the process and choose Extract Data to salvage values and formulas. Work on the copy and save anything recovered under a new name.
The right method depends on what happened. A cloud file may be recoverable through version history, an unsaved workbook through Recover Unsaved Workbooks, and an Excel application that crashes through Windows Safe Mode. None of these methods promises a complete workbook, so preserve every accessible copy before restoring or overwriting anything.
Before attempting recovery, preserve the original
Do not repeatedly open, overwrite, rename, or save the only copy of a damaged workbook. If the file is on a network share, removable disk, or a drive showing errors, copy it to a different local drive first. Microsoft specifically recommends moving a workbook to local storage when disk or network problems may be involved; this separates a storage connection problem from damage inside the workbook. See Microsoft’s corrupted-workbook guidance.
Free tools Windows power users keep installed
One-click scans. No signup required.
- Close Excel windows that have the damaged file open.
- Create a working copy with a different filename. Keep the original unchanged in its current location.
- If the file is in OneDrive or SharePoint and still opens in any form, make a copy before restoring an older version.
- Record the original file name, location, and last known good date. Those details help you choose among recovery candidates later.
A repair operation can remove damaged objects, and a version restore replaces the current cloud version. Preserving the source gives you another chance to recover content that the first attempt misses.
#1 Best Overall
- Slim durable design to help take your important files with you
- Vast capacities up to 6TB[1] to store your photos, videos, music, important documents and more
- Back up smarter with included device management software[2] with defense against ransomware
- Help secure your important files with password protection and hardware encryption
- 3-year limited warranty
Choose the recovery path that matches the symptom
Use this table to select the least destructive first step. A successful result in one path does not prove that the workbook’s entire structure, formatting, links, or calculated results survived.
| Situation | First path | What it may recover | Main limitation |
|---|---|---|---|
| Excel reports that the workbook is corrupted | Open and Repair > Repair | As much workbook data as Excel can repair | The attempt can fail or omit damaged content |
| Repair does not succeed | Open and Repair > Extract Data | Values and formulas | It is not necessarily a complete workbook with its original structure and formatting |
| A cloud workbook has a bad recent state | Version history | A previous saved version | Restoring replaces the current version |
| The workbook was never saved or was closed without saving | Recover Unsaved Workbooks or Document Recovery | An AutoRecovered or unsaved copy, if one exists | Availability depends on recovery settings and timing |
| The workbook is on an inaccessible network location | Copy it to a local drive | A local copy that can be tested independently | Copying does not repair corruption in the workbook itself |
| Excel crashes while opening files | Excel Safe Mode on Windows | Evidence about add-ins, startup files, or customizations causing the crash | Safe Mode diagnoses Excel startup; it does not repair workbook contents |
Use Open and Repair in desktop Excel
The Open and Repair command is Microsoft’s primary procedure for a workbook that will not open or is reported as corrupted. The documented versions include Excel for Microsoft 365, Excel 2024, Excel 2021, Excel 2019, and Excel 2016. Labels can vary slightly by platform or build, but the command is reached from the Open dialog.
- Start Excel without opening the damaged workbook.
- Select File > Open > Browse. Do not rely on a recent-file shortcut if it immediately triggers the same failure.
- Browse to the working copy of the workbook and select it once.
- Click the arrow beside the Open button.
- Choose Open and Repair.
- When Excel asks how to proceed, choose Repair first.
- Allow Excel to finish. If it opens a repaired workbook, inspect it before saving.
- Use Save As and give the result a new name in a safe location. Do not save over the original.
Microsoft describes the automatic behavior this way: “When you open a workbook that has been corrupted, Excel automatically starts File Recovery mode and attempts to reopen and simultaneously repair the workbook.” Automatic File Recovery may not start or may not resolve the problem, which is why the explicit Open and Repair command is the next step. The repair process can recover only the portions Excel can still interpret; a successful opening is not proof that every worksheet, chart, name, connection, or formula is intact.
Windows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallOutdated Drivers Are Slowing You Down
One free scan finds every outdated or missing driver and matches the right update for your exact hardware.Free scan · exact hardware matchIf Repair fails, run Extract Data
Return to the same Open and Repair menu and choose Extract Data instead of Repair. Microsoft describes this option as a way to retrieve values and formulas. It is a salvage operation, not a promise to rebuild the workbook’s original layout, formatting, tables, charts, macros, or other features.
- Close any failed recovery window without overwriting your working copy.
- Open the copy again through File > Open > Browse.
- Use the arrow beside Open, select Open and Repair, and choose Extract Data.
- When Excel presents the extracted material, check several sheets and representative cells for readable values and formulas.
- Save the extracted result under a new name, then rebuild missing presentation or workbook-level features only after the data has been secured.
If Extract Data returns only part of the workbook, keep that result. It may contain the most recoverable information even when a fully repaired workbook cannot be produced.
Rank #2
- 【Plug-and-Play Expandability】 With no software to install, just plug it in and the drive is ready to use in Windows（For Mac，first format the drive and select the ExFat format.
- 【Fast Data Transfers 】The external hard drives with the USB 3.0 cable to provide super fast transfer speed. The theoretical read speed is as high as 110MB/s-133MB/s, and the write speed is as high as 103MB/s.
- 【High capacity in a small enclosure 】The small, lightweight design offers up to 500GB capacity, offering ample space for storing large files, multimedia content, and backups with ease. Weighing only 0.35 Lbs, it's easy to carry "
- 【Wide Compatibility】Supports PS4 5/xbox one/Windows/Linux/Mac and other operating systems, ensuring seamless integration with game consoles,various laptops and desktops .
- Important Notes for PS/Xbox Gaming Devices: You can play last-gen games (PS4 / Xbox One) directly from an external hard drive. However, to play current-gen games (PS5 / Xbox Series X|S), you must copy them to the console's internal SSD first. The external drive is great for keeping your library on hand, but it can't run the new games.
Recover an earlier cloud version
When a workbook is stored in a supported OneDrive or SharePoint context and the problem appeared after a recent edit, version history may be safer than repairing the current file. Microsoft’s Restore a previous version of an Excel file instructions cover this route.
- Open the workbook’s version-history interface from Excel or its supported cloud location.
- Review the available versions and their dates and times.
- Choose a version from before the corruption or unwanted change.
- Before restoring, download or copy the current version if it is still accessible. This preserves any new work that the older version does not contain.
- Restore the selected version only after confirming that its timestamp matches the last known good state.
- Open the restored workbook and save a separate copy for continued work.
Restoring is not the same as merging. The selected earlier version replaces the current cloud version, so a restoration can discard edits made after that point. If the version list does not contain a usable earlier copy, return to the local Open and Repair procedure rather than repeatedly restoring versions at random.
Find a workbook that was never saved
If Excel closed before you saved the workbook, or you used the application and then chose not to save, look for an unsaved copy. In desktop Excel, use the following path:
- Select File > Info.
- Open Manage Document or Manage Workbook; the wording depends on the Excel version.
- Choose Recover Unsaved Workbooks.
- Open the candidate with the date and time closest to your work.
- Immediately use Save As and save it with a new, descriptive filename.
After an unexpected application closure, Excel may also show the Document Recovery pane when it restarts. Compare the listed copies by date and time instead of opening and overwriting each one. Save the best candidate separately before testing it.
Why an unsaved copy may be incomplete
AutoRecover works at intervals rather than after every keystroke. Microsoft’s referenced Excel settings guidance identifies 10 minutes as the default AutoRecover interval. A recovery file can therefore omit work completed after its last AutoRecover save, even when the file itself is available. The absence of a candidate can also reflect the workbook’s storage context, recovery settings, or the way Excel was closed; it does not prove that the missing work was never entered.
Rank #3
- Slim durable design to help take your important files with you
- Vast capacities up to 6TB[1] to store your photos, videos, music, important documents and more
- Back up smarter with included device management software[2] with defense against ransomware
- Help secure your important files with password protection and hardware encryption
- 3-year limited warranty
For guidance on crash protection and earlier Office copies, see Microsoft’s help-protect-your-files guidance and Recover an earlier version of an Office file.
If the workbook opens but is unstable or partly damaged
A workbook that opens with errors, missing sheets, or repeated crashes needs a different strategy from a file that never opens. Preserve the first copy, then try these Microsoft-documented fallbacks in order.
Revert to the last saved state
If the problem began during the current editing session, close the workbook without saving and reopen the last saved copy. This discards unsaved changes, so use it only when the saved state is more valuable than the current damaged session. If the file is cloud-stored, compare version history first so you do not lose a newer but still readable version.
Save each sheet as SYLK
Microsoft documents saving a sheet as SYLK to filter some corruption. SYLK saves only the active worksheet, so it is not a one-click conversion for an entire workbook.
- Open the workbook if Excel allows it to load.
- Select one worksheet tab and use Save As.
- Choose the SYLK file type and save to a new filename.
- Repeat for every worksheet you need to preserve; each sheet requires its own SYLK save.
- Open the SYLK files and save the recovered sheets into a new Excel workbook.
SYLK can remove workbook features. Check formulas, formatting, named items, charts, links, and other sheet behavior after rebuilding. Keep the original workbook and the individual SYLK files until validation is complete.
Recommended Free Tools
Rank #4
- High-capacity external hard drive with up to 2TB of storage The ModusTech Facet portable external hard drive gives you dependable HDD storage in a slim 2.5-inch design. Multiple capacities available up to 2TB — back up photos, videos, music, documents, and game libraries with room to grow. A trusted external storage solution for everyday backup, media archives, and creative work.
- USB-C and USB 3.1 connectivity with included 2-in-1 cable The Facet ships with a USB-C to USB-C cable and tethered USB-A adapter, so this external hard drive connects to modern laptops, USB-C iPhones, tablets, and older USB-A computers without buying an extra cable. USB 3.1 Gen 1 (5Gbps) interface delivers real-world transfer speeds up to 100MB/s — fast enough to back up 50GB of files in about 8 minutes.
- Plug-and-play external hard drive for PC, Mac, and laptops Preformatted in exFAT and ready to use the moment you plug it in. The Facet works out of the box with Windows PCs, macOS Macs, MacBooks, Chromebooks, and laptops — no drivers, no software, no setup required. A true plug-and-play external hard drive built for everyday use across every major operating system.
- External hard drive for PS4, Xbox One, and Smart TV gaming The Facet is compatible with PlayStation 4, Xbox One, and Smart TVs with USB support. PS4 and Xbox One games run directly from the drive — plug it in, format through the console, and add to your storage. Also works with Smart TVs that support USB recording or external media playback.
- Slim, shock-resistant portable external hard drive — 160g At 2.5 inches and just 160g, this portable external hard drive is bus-powered through a single USB-C cable — no separate power adapter, no extra cables. Slim enough for a laptop bag, jacket pocket, or camera bag, with a shockresistant casing and faceted diamond-texture top panel that resists fingerprints and everyday wear. Backed by a 1-year limited warranty from ModusTech, a consumer electronics brand specializing in external storage.
Separate a storage problem from a workbook problem
An error opening a file does not always mean the workbook is internally corrupt. A failing network connection, an unreliable removable disk, or file-system errors can interrupt reads and produce misleading Excel messages.
- Copy the workbook to a different local drive before running repair.
- If the copy operation itself fails, treat that as a storage or permissions problem first; repeated Excel repairs cannot compensate for unreadable sectors or an interrupted network transfer.
- Work only on the copied file. Leave the source on the network or original drive untouched until the recovered data has been checked.
- Once a local copy opens, save the recovered workbook to a new filename and then address the underlying storage issue separately.
This approach does not repair damaged workbook content; it prevents a connection or disk fault from interfering with every recovery attempt.
When Excel itself crashes: test Safe Mode on Windows
If Excel crashes or hangs while opening many different files, the application may be the problem rather than one workbook. Microsoft’s Safe Mode instructions use the Windows command excel /safe.
- Close Excel.
- Open the Windows Run dialog.
- Enter
excel /safeand press Enter. - In the Safe Mode window, try opening a copy of the workbook.
Safe Mode starts Excel without the add-ins, startup files, and customizations that can interfere with normal startup. If the copy opens only in Safe Mode, investigate those components before concluding that the workbook is corrupt. Safe Mode is a diagnostic test for Excel’s startup environment; it does not repair workbook contents and is specific to Excel on Windows.
Quick wins for a faster PC:
Clear out junk files and repair common Windows errorsFree Scan →Scan for outdated or missing drivers - takes under a minuteDriver Scan →Check an extension mismatch before changing anything
Excel can warn that a file’s extension does not match its actual format. Microsoft explains that this can result from an accidental or intentional rename, while unreadable contents can indicate corruption. Read Microsoft’s file-format and extension guidance before proceeding.
Best Value
- Slim durable design to help take your important files with you
- Back up smarter with included device management software[2] with defense against ransomware
- Help secure your important files with password protection and hardware encryption
- 3-year limited warranty
- Confirm where the file came from and which application created it.
- Check whether someone renamed the file without converting its contents.
- Do not assume that changing
.xlsx,.xls, or another extension will repair unreadable data. - After verifying the origin, use the correct application or Open and Repair on a copy.
An extension is a label, not a repair mechanism. Renaming a damaged file can make diagnosis harder and can remove useful evidence about its original format.
Advanced fallbacks when repair cannot open the file
Microsoft lists two advanced data-retrieval techniques for cases where ordinary repair is unsuccessful: changing calculation to manual and using external references. These methods are for extracting information, not for restoring a complete workbook.
Manual calculation
Changing calculation to manual can reduce the work Excel performs while loading a problematic workbook. Use this only after preserving the original and only when Excel can reach its calculation settings. The goal is to prevent recalculation from blocking access; it does not rebuild damaged formulas or guarantee that displayed results are current.
External references
External references can sometimes retrieve data from a workbook that cannot be opened normally. They are a data-retrieval technique, not a way to restore the source workbook’s full formulas, formatting, links, or calculated values. Treat any retrieved numbers as a new data copy that must be checked against the last known good information.
Validate the recovered workbook before trusting it
Recovery is complete only when the information you need has been checked. Use a separate copy for validation and keep the damaged original until the review is finished.
- Open every recovered worksheet that matters to your work.
- Check a sample of values at the beginning, middle, and end of large ranges.
- Inspect formulas for errors, missing references, and unexpected constants.
- Compare totals, dates, and key identifiers with a known report or source system.
- Test important filters, tables, charts, pivots, links, and macros if the workbook used them.
- Look for missing sheet tabs, renamed ranges, broken external links, or formatting that affects interpretation.
- Save the validated result under a new filename and create another backup before continuing edits.
If Extract Data or SYLK produced separate pieces, document which sheets and values came from each result. That record prevents a partial salvage from being mistaken for a complete restoration.
Reduce the chance of losing the next workbook
Recovery tools are last-resort measures. A routine that keeps independent copies makes a future failure less destructive.
Do these 3 things before closing this tab:
1Fix the driver behind crashes, sound loss and screen glitches2Repair Windows errors before they cause bigger problems3Scan for outdated or missing drivers - takes under a minute- Keep important workbooks in a location with version history when your organization supports it, and verify that earlier versions are actually available.
- Allow AutoRecover to remain enabled and understand that the 10-minute default is an interval, not continuous saving.
- Save major milestones under new filenames rather than overwriting the only copy.
- Keep a backup on a separate drive or supported cloud location; a backup is useful only if it can be opened and is not exposed to the same failure.
- When working over a network, copy a critical workbook locally before a long editing session and copy the completed version back after saving.
- Close Excel normally and investigate repeated crashes, add-in conflicts, or disk errors instead of treating every incident as workbook corruption.
No recovery route can promise every worksheet and feature will return. The safest sequence is to preserve the source, choose the path that matches the failure, save each result separately, and validate the data before relying on it.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
