Losing an unsaved Excel file feels like watching hours of work evaporate in a single second. One crashed laptop, one accidental "Don't Save" click, one rogue power blip — and that financial model, that timesheet, that sales report? Gone. Or so you think.
Here's the good news: Microsoft built several recovery nets into Excel, and most users never know they exist. Whether you closed without saving, your machine froze mid-edit, or Excel itself crashed, there's usually a way back. You just need to know where to look — and you need to act before Windows or macOS cleans up the temp files.
This guide walks you through every method that actually works in 2026 for how to recover unsaved Excel file scenarios, from the built-in AutoRecover pane to obscure temp-file folders most tutorials skip entirely. We'll cover Excel 365, Excel 2024, Excel 2019, and the older 2016 builds. Mac users — you're not forgotten either. By the end, you'll know which method to try first based on what happened, and you'll have a recovery checklist you can keep pinned to your monitor.
Before diving into recovery, it helps to understand what's actually happening behind the scenes. Excel doesn't just lose your work randomly. It loses your work because of a handful of predictable triggers, and knowing them changes how you respond.
The most common cause? You clicked the X in the top-right corner, hit "Don't Save" out of muscle memory, and then realized — three seconds too late — that you needed that file. Second most common: Excel froze, you killed the process in Task Manager, and the workbook never got a chance to write to disk. Third: a power outage, a Windows update that rebooted overnight, or a kernel panic on a Mac. Fourth, and the most frustrating, is when a file gets corrupted during save — Excel writes a broken header, then refuses to open the file the next morning.
Each scenario has a different recovery path. AutoRecover handles crashes. The Recent Files list handles accidental "Don't Save" clicks. Temp folders handle the deep cases where nothing else works. Mix them up, and you'll waste an hour trying the wrong fix.
If Excel crashed and you reopen it, the Document Recovery pane will sometimes appear automatically on the left side of the screen. This pane lists every file Excel was tracking with AutoRecover when the crash happened. It's the fastest win — one click and you're back in business.
If the pane doesn't appear, don't panic. Open Excel, click File, then Open, and at the bottom of the Recent list click Recover Unsaved Workbooks. This pulls up the AutoRecover folder directly. Pick the file with the most recent timestamp, open it, and save it somewhere safe before doing anything else.
Sometimes the Recover Unsaved Workbooks button doesn't show what you need. The fix is to navigate to the AutoRecover folder yourself. On Windows, this lives at C:\Users\YourName\AppData\Local\Microsoft\Office\UnsavedFiles. On Mac, head to /Users/YourName/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery.
The files in these folders have names like Book1((Unsaved-302947823)).xlsb. Sort by date modified, grab the most recent one, and double-click it. Microsoft Excel will open it in recovery mode. Save it immediately — these files get auto-cleaned after four days by default.
Right-click the folder where your file used to live. Hit Properties, then the Previous Versions tab. If System Protection is enabled (and on Windows 11 it usually is), you'll see snapshots from earlier today, yesterday, last week. Pick one, copy the file out, and you've recovered yesterday's draft.
This method works even if Excel never created an AutoRecover file — it taps into the OS-level shadow copy system instead. Most users have no idea it exists.
Excel writes temporary working copies during every edit session. These files have weird names — usually starting with a tilde (~) followed by a string of random characters and ending in .tmp. They live in the same folder as your original document, or sometimes in the user's Temp folder.
To find them on Windows, open File Explorer, paste %temp% into the address bar, and hit Enter. Look for files modified around the time you lost your work. Rename one to .xlsx and try opening it. Half the time it works. The other half, Excel will offer to repair it — which is also a win.
On Mac, the path is /private/var/folders/ — but honestly, navigating that on macOS is a nightmare. Open Terminal and run open $TMPDIR instead. That drops you straight into your user's temp folder.
If your file lived on OneDrive or SharePoint, you have a massive safety net most people forget about. Open the file in OneDrive's web interface, click the three dots, choose Version History, and you'll see every saved version — sometimes dozens, going back weeks. Restore any one with a single click.
This is the cleanest recovery method when it applies. It also works for files shared in Microsoft Teams, since Teams stores attachments in SharePoint behind the scenes. If you're studying spreadsheet skills seriously, how to use excel properly includes habits like always editing from OneDrive — your future self will thank you.
Once you've recovered your file, take five minutes to bulletproof yourself for next time. Open Excel, go to File > Options > Save. Set Save AutoRecover information every to 1 minute (the default is 10 — way too long). Tick Keep the last AutoRecovered version if I close without saving. Then enable AutoSave on OneDrive for any file you care about.
If you're serious about Excel as a career skill, knowing recovery is just the start. Real proficiency means mastering formulas, pivot tables, lookups, and shortcuts under timed conditions — which is exactly what employers test for. The faster you build muscle memory for save shortcuts (Ctrl+S every 30 seconds isn't paranoid — it's professional), the less often you'll need this guide.
Sometimes the file is gone. Truly gone. The AutoRecover folder was empty, no temp files exist, no shadow copies, no cloud version. At that point you have two options: rebuild from memory, or hire a data recovery specialist who can scan the raw disk sectors for fragments. The second option costs $200-$1000 and works maybe 60% of the time.
The honest truth? Prevention beats recovery every single time. AutoSave to OneDrive plus Ctrl+S as a reflex will save you more pain than any tutorial. Make it a habit before you need to.
Print this. Tape it to your monitor. The next time Excel betrays you, work top to bottom — don't skip steps just because one feels obvious.
%AppData%\..\Local\Microsoft\Office\UnsavedFiles into File Explorer. Anything in there with today's date is fair game.%temp%, and sort by date modified. Look for .tmp files with weird names — rename one to .xlsx and try to open it.Most recoveries end at step 1 or 2. Step 3 and 4 catch maybe 80% of the rest. Steps 5 and 6 handle the edge cases — and step 7 is the nuclear option you hope you never need.
Worth noting: the most recent Excel 365 builds quietly improved a few things in late 2025. The AutoRecover interval can now be set to 30 seconds (it used to bottom out at 1 minute). Cloud autosave indicators got more visible, with a green checkmark in the title bar showing your last sync. And on Mac, the AutoRecovery folder moved to a more accessible location under the Containers directory — older guides pointing to ~/Library/Application Support/Microsoft are out of date.
If you're on a corporate machine where IT has locked down AutoSave settings, you might find recovery options disabled by group policy. The fix is to ask your admin to enable "Allow AutoSave for OneDrive files" — most won't push back once they hear the alternative is users losing budget spreadsheets every other Friday.