Recover Excel File Not Saved: 6 Methods That Work

Excel crashed. Power cut out. You closed the workbook and clicked Don't Save by mistake. Whatever happened, the spreadsheet you worked on for three hours is gone — or so it seems. The good news? Microsoft built half a dozen recovery paths into Excel itself, and most people don't know about more than one. This guide walks through every method, in order of likelihood to actually return your file.

Most failed recovery attempts share one cause: the user only tries one trick (usually reopening Excel) and then gives up. Don't. Excel file recovery works in layers — if Document Recovery doesn't show your file, AutoRecover might. If AutoRecover is empty, the Unsaved Workbooks folder is the next stop. We'll cover them all, and then the prevention habits that make this guide unnecessary.

Before you dig in, a quick reality check. Recovery only works if Excel had a chance to save something. If you typed for thirty seconds and the program crashed before the first auto-save tick, no method will save you. But if you worked for ten minutes? The odds are excellent. Most users who follow the sequence below recover their file within five minutes, often on the first or second method tried.

Method 1: Document Recovery Pane (Easiest Win)

This is the first thing Excel tries when you reopen it after a crash. When the program detects that the previous session ended abnormally — Excel quit, Windows rebooted, the laptop battery died — it opens a Document Recovery pane on the left side of the screen. The pane lists any files Excel was tracking when things went wrong, usually labeled with a timestamp and a tag like "AutoSaved" or "Original".

What to do: click the file you want, and Excel opens it. Save it immediately to a new location — don't trust the recovered copy to survive another crash. If the pane shows two versions of the same workbook (one AutoSaved, one Original), open both, compare them side by side, and pick the one with more recent edits.

The pane vanishes after you close it, and it doesn't come back. Miss it once, and you're moving on to the next method. So when Excel reopens and that panel appears, don't dismiss it out of habit.

Method 2: AutoSave to OneDrive (Excel 365)

If you use Microsoft 365 and your workbook lives in OneDrive, SharePoint, or Teams, AutoSave is doing the work for you — every few seconds, silently. The toggle sits at the top-left of the Excel ribbon, next to the Save icon. When it's on (and your file is in the cloud), Excel saves on every keystroke pause.

To roll back: open the file, then go to File → Info → Version History. You'll see a list of saved states, each with a date and time. Click any version to open it in a new window. From there, hit Restore to make that version the current one, or just copy the cells you need into your live workbook. OneDrive keeps versions for around 30 days, though business plans hold them longer.

Catch: AutoSave only works on cloud-stored files. If your workbook sits on the C: drive, it does nothing. That's why people who think they have AutoSave on still lose data — they were editing a local copy the whole time.

Method 3: AutoRecover Files (.asd / .xlsb)

AutoRecover is Excel's local-disk safety net. By default, every ten minutes Excel quietly drops a snapshot of your open workbooks into a hidden folder. The snapshots use the .asd or .xlsb extension and persist for four days unless Excel deletes them after a clean save. Most users have no idea this folder exists — and it's the single highest-ROI recovery path after Document Recovery itself.

To find the folder: open Excel, go to File → Options → Save, and look at the AutoRecover file location field. The default on Windows is C:\Users\[your-name]\AppData\Roaming\Microsoft\Excel\. Copy that path. Open File Explorer, paste the path into the address bar, and hit Enter. You'll see files with cryptic names — open them in Excel with File → Open (set the file type to All Files so the .asd extension appears in the dialog).

If you don't see anything useful, the interval may be the culprit. Check the Save AutoRecover information every X minutes box. The default ten minutes is fine for casual use; for heavy work, drop it to one. The performance cost is negligible on any machine made in the last decade, and the worst-case data loss drops from ten minutes to under sixty seconds.

While you're in that menu, also check Keep the last AutoRecovered version if I close without saving — it should be on. If it's off, Excel discards the snapshot the moment you click Don't Save, which is exactly the scenario you're trying to protect against.

Method 4: Recover Unsaved Workbooks Button

This one's the catch-all. If you never saved a file at all — opened a blank workbook, typed for an hour, then closed it and clicked Don't Save — there's still a copy. Excel keeps unsaved workbooks for ten days in a separate folder, regardless of whether you ever named the file.

How to get there: File → Open → Recent. Scroll all the way to the bottom of the Recent list. You'll see a button labeled Recover Unsaved Workbooks. Click it. Excel opens File Explorer in the UnsavedFiles folder, showing every workbook from the last ten days that you opened but never saved. Pick the one you want, open it, and save it under a real name.

This is the method people miss most often, because the button only appears at the bottom of the Recent list and most users scroll past it. how to recover unsaved excel files via this folder also tends to surface files you didn't realize existed — abandoned scratch sheets, copy-paste experiments.

Method 5: AppData Office Temp Files (Windows)

When the previous methods come up empty, the Office temp directory is your next stop. Windows stores abandoned and orphaned Office files in a hidden folder that Excel doesn't surface through any menu, anywhere in the UI. The path: C:\Users\[your-name]\AppData\Local\Microsoft\Office\UnsavedFiles\.

Paste that into File Explorer's address bar — the AppData folder is hidden by default, so typing the path directly is the fastest way in. You'll see files with names like Book1-((random-string)).xlsb. Right-click, open with Excel, and check the contents. Some will be junk; some will be the workbook you thought you lost. Sort by date modified to put the freshest at the top, and ignore anything older than the last week — it's almost certainly residue from previous sessions.

One quirk: this folder doesn't clean itself reliably. You may find files from months ago, mixed with last night's work. Don't delete the contents to tidy up — you might be wiping out the only copy of a file you'll need next Tuesday. Treat it as an emergency-only stash and let Excel manage cleanup on its own schedule.

Method 6: Mac AutoRecovery Location

Mac users get a different folder, buried even deeper. AutoRecover on macOS lives at: ~/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery/. The tilde (~) is your home folder. The Library directory is hidden in Finder by default — to reveal it, hold the Option key while clicking the Finder's Go menu. The full Library tree appears in the menu only while Option is held down, which is why most Mac users have never seen this folder.

Inside AutoRecovery you'll find files named AutoRecovery save of [workbook]. Drag any of them onto the Excel icon in your Dock to open them. Mac AutoRecover behaves like its Windows cousin: ten-minute default interval, deleted on clean save, four-day shelf life if not.

If your Mac crashed mid-edit and the folder is empty, check Time Machine — macOS keeps hourly snapshots if you have an external drive plugged in, and you can step backward through versions of any file in any folder. Open Time Machine, navigate to where the workbook should be, scroll back to a point before the crash, and restore.

What If the File Is Corrupted?

Sometimes you recover the file, only to have Excel refuse to open it — error messages about an invalid format, or the spreadsheet opens with garbled cells full of #REF! errors. That's corruption, not a missing file, and it has its own fix path. Open Excel, go to File → Open, find the file, and instead of double-clicking it, click it once. Look at the Open button in the bottom-right of the dialog — it has a small arrow next to it.

Click that arrow and choose Open and Repair. Excel offers two options: Repair (tries to recover everything) or Extract Data (gives up on formatting and just pulls the values). Try Repair first. If it fails, fall back to Extract Data — you'll lose formulas and styling, but the raw numbers come through, which is usually the part that mattered. The whole flow takes thirty seconds and rescues maybe half of all corrupted workbooks.

Third-Party Recovery Tools (When Microsoft Fails)

Microsoft's recovery methods cover maybe 80% of real-world cases. The remaining 20% — overwritten files, deleted-then-emptied-recycle-bin scenarios, dead hard drives — need outside help. The tools below all work on the same principle: scan the disk's free space for file signatures matching Excel's, then reconstruct the data. Results vary based on how much the disk has been written to since the file vanished.

Recuva is free and surprisingly effective for recently deleted files. Download, install, point it at the drive, and let it scan. EaseUS Data Recovery Wizard and Stellar Excel Repair are paid options with free trials; Stellar specifically targets corrupted .xls and .xlsx files and rescues more from heavily damaged workbooks than Excel itself can. Recoverit and Disk Drill sit in the same paid tier. Disk Drill has a free tier that lets you preview recoverable files before paying, which is useful — you can confirm the file you want is even findable before spending money.

Whatever you use, install it on a different drive than the one you're recovering from. Writing the installer to the same disk overwrites the free space where your file lives, potentially destroying what you're trying to save. USB sticks work great for this — keep one in a drawer with your favorite tools pre-installed.

Cloud Recovery: OneDrive Recycle Bin and Version History

If your file lived in OneDrive and you deleted it, it's not gone — it moves to the OneDrive Recycle Bin for 30 days. Sign in at onedrive.live.com, click Recycle Bin in the left sidebar, find your file, and click Restore. The file returns to its original folder with permissions intact. If multiple files vanished at once — a synced folder accidentally deleted, say — restore them in bulk by selecting all and hitting Restore once.

After 30 days, items move to the Second-stage Recycle Bin (business accounts) for an additional 93 days. Past that, the file is genuinely deleted from Microsoft's servers, and only file-recovery tools on your local machine — if it synced before deletion — can help. SharePoint admins can configure longer retention through policy, so if you're at a company, ask IT before assuming a file is unrecoverable.

Version History in OneDrive deserves a second mention. Even files you didn't think needed saving keep up to 25 versions. Right-click in OneDrive's web interface, choose Version History, and roll back. This works for Excel files edited in Excel Online too — every save creates a new version, no setup required. The feature is on by default for everything stored in OneDrive, including files you copied in rather than created there.

Prevention: Stop Losing Files in the First Place

Recovery is reactive. Prevention is cheaper, faster, and doesn't require you to remember six folder paths while panicking. Set AutoRecover to one minute (File → Options → Save). Store everything important in OneDrive so AutoSave can do its job; local files on the C: drive ignore AutoSave entirely. Press Ctrl+S compulsively, every two minutes, every time you switch tabs. Version your important workbooks weekly.

For business users, this gets serious. Enterprise backup tools like Veeam for Microsoft 365 or Azure Backup handle the version-control problem at scale, with retention policies you can tune by compliance requirements. If a critical spreadsheet vanishing would cost real money, the licensing fee for proper backup is cheap insurance.

Excel Online and Forensic Last Resorts

Working in Excel Online — the browser version — has a quiet advantage. Every keystroke saves. There's no Save button in the ribbon because there's nothing to save manually. Click the filename at the top of the window to see Version History; the list goes back up to 25 versions, each labeled by editor and timestamp.

When every method above fails — drive crashed, recycle bin emptied, ransomware — disk-level recovery scans the raw sectors of a drive for file signatures. R-Studio and UFS Explorer sit at the professional end of this market, handling damaged partitions and RAID arrays. If the drive is physically failing, stop using it immediately and consider a recovery lab like DriveSavers or Ontrack.

Recovery Order: What to Try First

Work through methods in this order. First, reopen Excel and check Document Recovery. Second, look in OneDrive Version History if the file is cloud-stored. Third, navigate to the AutoRecover folder. Fourth, click Recover Unsaved Workbooks. Fifth, check AppData Office UnsavedFiles. Sixth, try Open and Repair if you have the file but it won't load. Only after all of those, reach for third-party tools — and change your habits so you never come back to this guide.