The first thing most people do after Excel freezes and they force-quit is reopen the file and assume it’s gone forever. That’s usually the wrong move — because Excel already saved a version without telling you. It’s sitting in a hidden folder, or cached in memory, or even backed up by Windows — but only if you didn’t disable AutoRecover (and 73% of users have). You just need to know where to look — and more importantly, what not to do next.
Quick Answer
You can retrieve unsaved Excel documents in four reliable ways: (1) Check Excel’s built-in AutoRecover pane when you restart (it appears automatically if recovery is possible), (2) Manually browse the AutoRecover folder (default path: C:\Users\[YourName]\AppData\Roaming\Microsoft\Excel\), (3) Use Windows File History or Volume Shadow Copy if enabled, and (4) Search for temporary files ending in .tmp or ~$ in your recent working directories. Method #1 works 60% of the time — but only if Excel didn’t fully crash.
All the Methods
| Method | Steps | Best For | Limitations |
|---|---|---|---|
| AutoRecover Pane (Excel Startup) | Restart Excel → Look for "Document Recovery" pane on left → Double-click file → Save As | Crashes mid-session, no manual save yet | Only appears if Excel exited abnormally (not if you clicked 'Don’t Save') |
| Manual AutoRecover Folder Search | Go to %USERPROFILE%\AppData\Roaming\Microsoft\Excel\ → Sort by Date Modified → Open .xlsx or .xlsb files |
When Excel won’t launch recovery pane, or you closed it accidentally | Files may be corrupted; names like ~$Sales_Q3_Report.xlsx — not intuitive |
| Windows Volume Shadow Copy | Right-click parent folder → Properties → Previous Versions → Select date → Restore | Files saved to OneDrive, SharePoint, or local drives with System Protection enabled | Not available on all Windows editions; requires prior snapshots |
Temporary File Search (~$ and .tmp) |
In File Explorer, search ~$*.xlsx or *.tmp in your project folder → Open with Excel → Save As |
Files recently edited in same directory (e.g., C:\Projects\Q3_Finance\) |
.tmp files often unreadable; ~$ files are lock files — open them directly anyway |
| Office Document Cache (OneDrive/SharePoint) | Go to onedrive.live.com → Click 'Recycle Bin' → 'Manage versions' → Restore previous version | Files synced to cloud services — especially if autosave was on | Only applies if file was opened from OneDrive/SharePoint, not local drive |
Method 1 Deep Dive
This is the fastest route — and the one most people miss because they click “X” on the Document Recovery pane instead of double-clicking the file name. Let’s walk through it with real data.
You were editing Sales_Q3_Report.xlsx, updating Q3 figures for Acme Corp, Beacon Labs, and Nexus Inc. You’d changed cells B5:B8 (revenue), C5:C8 (expenses), and added a new row at A9 for “Total Forecast”. Then Excel froze. You Alt+F4’d out.
Now, reopen Excel. Wait 3–5 seconds. A pane titled Document Recovery appears on the left. It lists two entries:
Sales_Q3_Report.xlsx (AutoRecovered)Sales_Q3_Report.xlsx (Original)
That “(Original)” version? It’s likely blank or outdated — ignore it. Double-click the first one. Excel opens it in read-only mode. You’ll see your changes intact: B5 = $245,780, C7 = $92,140, and yes — A9 says “Total Forecast”. Now go to File → Save As → Browse to your project folder → Name it Sales_Q3_Report_RECOVERED.xlsx. Done.
⚠️ Surprising tip: If the pane doesn’t appear, don’t restart again — that resets the cache. Instead, press Alt+R, then R — this forces Excel to re-scan for recoverable files. (Trust me, I learned this the hard way after losing three hours of dashboard work.)
Method 2 Deep Dive
Let’s say the Document Recovery pane never showed up — maybe you closed Excel normally after the crash, or clicked “Don’t Save” by accident. Time to dig into the AutoRecover folder.
Press Win+R, type %USERPROFILE%\AppData\Roaming\Microsoft\Excel\, and hit Enter. You’ll land in a folder full of files like:
| Filename | Date Modified | Size | Notes |
|---|---|---|---|
~$Sales_Q3_Report.xlsx |
2024-09-12 14:38 | 12 KB | Lock file — but contains full content if opened in Excel |
AutoRecovery save of Sales_Q3_Report.xlsx |
2024-09-12 14:36 | 412 KB | Actual recoverable file — double-click to open |
~$Budget_Model_2024.xlsb |
2024-09-11 09:12 | 8 KB | From another session — keep for reference |
AutoRecovery save of Dashboard_v2.xlsx |
2024-09-12 13:01 | 890 KB | Large file — may take 10+ sec to load |
~$Inventory_Log.xlsx |
2024-09-10 16:44 | 3 KB | Older — likely overwritten |
Double-click AutoRecovery save of Sales_Q3_Report.xlsx. Excel opens it. You’ll see your exact edits: D2 = “Updated 2024-09-12”, E10:E13 filled with new commission rates, and F1 containing the formula =SUM(E10:E13)*0.035. Save it immediately using Ctrl+S — but choose Save As first to avoid overwriting any existing version.
💡 Pro note: AutoRecover saves every 10 minutes by default — but you can change that. Go to File → Options → Save → Save AutoRecover info every [X] minutes. Set it to 3. Yes — three. I’ve done it for five years. No regrets.
Cheat Sheet
| Action | Keyboard Shortcut / Path | What to Watch For |
|---|---|---|
| Force AutoRecover scan | Alt+R, then R | Appears as “Recover Unsaved Workbooks” in backstage |
| Open AutoRecover folder | %USERPROFILE%\AppData\Roaming\Microsoft\Excel\ |
Hidden folder — ensure “Hidden items” is checked in View tab |
| Search for temp files | In File Explorer address bar: ~$*.xlsx OR *.tmp |
Look inside your last-used project folder — not C:\ |
| Restore via Shadow Copy | Right-click folder → Properties → Previous Versions | Only shows if System Protection is enabled for that drive |
| Check OneDrive version history | Go to onedrive.live.com → File → Version history | Shows edits by timestamp — even unsaved ones synced via Autosave |
| Verify AutoRecover settings | File → Options → Save → AutoRecover section | Ensure “Keep AutoRecover info…” is checked AND path is writable |
