Why can’t you find the unsaved version of that report you closed by accident? Why does Excel sometimes open two copies of the same workbook with different data? Why does clearing %TEMP% never seem to fix recovery issues?
The answer lives in four places — not one — and three of them are hidden behind registry keys or buried in user profile subfolders no one checks. Excel doesn’t just use one temp location. It uses a hierarchy. And if you don’t know which layer is active, you’ll waste hours hunting for a file that’s already been overwritten.
The Setup
You’re supporting Sarah Chen in Finance at Acme Corp. She’s working on Q2_Sales_Forecast_2024.xlsx, a 12MB file with live connections to Power Query and embedded charts. She closes it without saving after editing cells in Sheet1!D5:D18. Later, she opens Excel and sees ‘Document Recovery’ — but only two autosaves appear: one from 2024-03-12 and another from 2024-03-15. Her last edit was 2024-03-17 at 4:22 PM.
| File Name | Last Modified | Size | Location |
|---|---|---|---|
| Q2_Sales_Forecast_2024.xlsx | 2024-03-12 10:17 AM | 9.8 MB | C:\Users\schen\AppData\Local\Microsoft\Office\UnsavedFiles\ |
| Q2_Sales_Forecast_2024.xlsx | 2024-03-15 3:44 PM | 11.2 MB | C:\Users\schen\AppData\Roaming\Microsoft\Excel\ |
| ~$Q2_Sales_Forecast_2024.xlsx | 2024-03-17 4:21 PM | 16 KB | C:\Users\schen\Documents\ |
| Book1.xlsx | 2024-03-17 4:22 PM | 45 KB | C:\Users\schen\AppData\Local\Temp\ |
| XL{A7F2E1B9-8C3D-4E5A-B9F1-1D2C3E4F5A6B}.tmp | 2024-03-17 4:22 PM | 2.1 MB | C:\Users\schen\AppData\Local\Microsoft\Office\16.0\OfficeFileCache\ |
| AutoRecovery save of Q2_Sales_Forecast_2024.xlsx | 2024-03-17 4:22 PM | 12.1 MB | C:\Users\schen\AppData\Roaming\Microsoft\Excel\ |
| ~WRL0001.tmp | 2024-03-17 4:22 PM | 87 KB | C:\Users\schen\AppData\Local\Temp\ |
| Q2_Sales_Forecast_2024.xlsx | 2024-03-17 4:22 PM | 12.1 MB | C:\Users\schen\Documents\ |
The Challenge
Excel saves temp files in five locations — not one. And which one gets used depends on whether the file is new or existing, whether it’s opened from OneDrive, whether AutoRecover is enabled, and whether Excel crashed or was closed normally. Worse: some folders (like OfficeFileCache) are invisible unless you type the full path into File Explorer. Others (like UnsavedFiles) get cleared on startup — but only if Excel exits cleanly. If it crashes? Those files stay put. Forever — until someone manually deletes them.
Here’s what makes this tricky:
- Windows Search won’t find
~$orXL{GUID}.tmpfiles unless you enable ‘Hidden items’ AND ‘File name extensions’ AND search system folders. - Ctrl+Alt+Shift+F10 opens the Document Recovery pane — but it only shows files Excel *thinks* are recoverable. Not all temp files qualify.
- Changing AutoRecover settings in File > Options > Save affects future saves — not past ones. So adjusting it now won’t help you find yesterday’s lost edits.
And here’s the counterintuitive part: The most recent temp file isn’t always the largest one. In fact, the 16 KB ~$ file in C:\Users\schen\Documents\ contains the lock metadata and last-saved timestamp — and is often the only clue that a newer version exists elsewhere.
Walking Through It
We’re going to locate, verify, and recover Sarah’s missing 2024-03-17 edits. Do this in order. Skipping steps breaks the chain.
Step 1: Check the obvious — the ~$ file
Open File Explorer. Paste this into the address bar:C:\Users\schen\Documents\
Press Enter. Enable ‘Hidden items’ in the View tab. Look for any file starting with ~$ and matching your workbook name. You’ll see ~$Q2_Sales_Forecast_2024.xlsx — modified at 4:21 PM.
This file is not the data. It’s a placeholder. But its timestamp tells you Excel was actively writing to the real file seconds before close. That confirms a temp copy should exist — and narrows the window.
Step 2: Go straight to AutoRecover (not %TEMP%)
Don’t waste time in C:\Users\schen\AppData\Local\Temp\. Excel rarely stores full workbook copies there. Instead, go to:C:\Users\schen\AppData\Roaming\Microsoft\Excel\
In File Explorer, type that path directly. Press Alt+D to focus the address bar, then paste and press Enter.
You’ll see two files:
• AutoRecovery save of Q2_Sales_Forecast_2024.xlsx (12.1 MB, 4:22 PM)
• Q2_Sales_Forecast_2024.xlsx (11.2 MB, 3:44 PM)
The first one is your target. Double-click it. Excel opens it in Protected View. Click ‘Enable Editing’. Now compare cell Sheet1!D12 with the version she remembers. It matches — she added ‘+12% forecast adjustment’ in that cell.
| Before (Recovered) | After (Verified) |
|---|---|
| =IF(B12>500000,B12*1.12,"") | =IF(B12>500000,B12*1.12,"+12% forecast adjustment") |
| Cell D12 blank in prior autosave | Cell D12 now contains comment + formula update |
| Last saved: 2024-03-15 | Last saved: 2024-03-17 4:22 PM |
Step 3: Force Excel to show *all* temp locations
Hold Ctrl and click File > Open > Recent. Keep Ctrl held down while clicking ‘Recover Unsaved Workbooks’ at the bottom. This bypasses the standard Document Recovery pane and forces Excel to scan all five temp paths — including OfficeFileCache.
If the file still doesn’t appear, restart Excel holding Ctrl the whole time. Release only after the splash screen disappears. This boots Excel in Safe Mode and triggers a full temp inventory.
Step 4: Dig into OfficeFileCache (the silent keeper)
Paste this path:C:\Users\schen\AppData\Local\Microsoft\Office\16.0\OfficeFileCache\
Look for files named XL{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}.tmp. Sort by Date Modified. The one from 4:22 PM is your backup — even if it’s smaller than the AutoRecovery file. Right-click → ‘Copy’, paste into a new folder, rename to Q2_Sales_Forecast_2024_RECOVERED.xlsx, then open.
It opens as read-only. Go to File > Info > Convert to make it editable. Save immediately to Documents — not Desktop.
The Result
Sarah recovers all changes made between 3:44 PM and 4:22 PM on March 17. No data loss. Here’s the final verified state of key cells:
| Cell | Value (Recovered) | Notes |
|---|---|---|
| Sheet1!D5 | =SUMIFS(Revenue,Region,"APAC",Year,2024) | Formula unchanged |
| Sheet1!D12 | =IF(B12>500000,B12*1.12,"+12% forecast adjustment") | New comment + logic update |
| Sheet1!D18 | 1,248,710.50 | Updated total (was 1,109,800.00) |
| Sheet2!A1 | 2024-03-17 16:22 | Timestamp inserted manually |
| Chart title (Chart1) | "Q2 Forecast — Updated Mar 17" | Text changed |
| Power Query connection status | “Up to date as of 2024-03-17” | Refreshed before close |
What Could Go Wrong
Three mistakes we see every week — and how to spot them before they cost you time.
Mistake #1: Deleting %TEMP% without closing Excel first
When Excel is running, it holds handles to temp files in C:\Users\schen\AppData\Local\Temp\. If you wipe that folder while Excel is open, those files get marked ‘in use’ — then vanish when Excel closes. The AutoRecover file in Roaming may still exist… but the OfficeFileCache copy is gone forever. You’ll see ‘File not found’ errors in Document Recovery — not because the file’s missing, but because Excel tried to load it from a dead handle.
Mistake #2: Assuming OneDrive sync = AutoRecover backup
OneDrive saves versions — but only when you explicitly click ‘Save’ or when AutoSave is on. If Sarah had closed Excel before OneDrive synced (e.g., laptop went to sleep), her 4:22 PM edits exist only in local temp files — not the cloud. Checking OneDrive Version History shows last version from 2024-03-15. That’s useless here. Don’t trust cloud sync to cover local crash recovery.
Mistake #3: Renaming the ~$ file and double-clicking it
The ~$ file is not a workbook. It’s a binary lock file. If you rename it to Q2_Sales_Forecast_2024.xlsx and double-click, Excel throws ‘file format not valid’. Worse — doing so corrupts the original lock, preventing AutoRecover from detecting the parent file next time. Always leave ~$ files alone. They’re breadcrumbs — not the meal.
Your next move: Run this now. Open Notepad. Paste the four paths below. Save as EXCEL_TEMP_LOCATIONS.txt on your Desktop. Pin it to Quick Access. You’ll use it more than you think.
| Path | Purpose | Shortcut |
|---|---|---|
| C:\Users\[USER]\AppData\Roaming\Microsoft\Excel\ | AutoRecover & backup copies | Alt+D, paste, Enter |
| C:\Users\[USER]\AppData\Local\Microsoft\Office\UnsavedFiles\ | Crash-recovery files (cleared on clean exit) | Alt+D, paste, Enter |
| C:\Users\[USER]\AppData\Local\Microsoft\Office\16.0\OfficeFileCache\ | Raw temp buffers (hidden, persistent) | Alt+D, paste, Enter |
| C:\Users\[USER]\Documents\ | ~$ lock files + occasional full copies | Alt+D, paste, Enter |
