Troubleshooting AutoRecover failures: Where to find unsaved temp files.

When Microsoft Excel crashes, loses power, or closes without a save prompt, the built-in Document Recovery task pane should appear the next time you open the program. When that pane fails to appear, users often assume their work is gone. In reality, AutoRecover files, unsaved drafts, and background cache snapshots are frequently left behind on your hard drive as hidden .xla, .asd, or .tmp files. You can manually find and reconstruct these files if you know where Excel stores them.

Quick Answer

Open a blank Excel workbook, navigate to File > Open > Recent, scroll to the bottom of the list, and click Recover Unsaved Workbooks. If your file is not listed there, press Windows Key + R, paste %LOCALAPPDATA%\Microsoft\Office\UnsavedFiles into the box, and press Enter. Check this folder for .xla or .xlsb files matching your workbook’s name.

---

Understanding the Three Recovery Locations

Excel does not write unsaved snapshots to a single directory. Depending on whether the file was an existing saved workbook that crashed, or a brand-new file closed without saving, the data is routed to one of three storage locations.

[Crash / Unsaved Event]
       │
       ├── Was the workbook ever saved?
       │     ├── NO  ──► Stored in: %LOCALAPPDATA%\Microsoft\Office\UnsavedFiles\
       │     └── YES ──► Stored in: %APPDATA%\Microsoft\Excel\
       │
       └── Did AutoRecover fail entirely?
             └── YES ──► Scan raw swap disk: %TEMP% (C:\Users\<User>\AppData\Local\Temp\)

---

Location 1: Brand-New Files Closed Without Saving

If you created a new workbook (e.g., Book1.xlsx), worked in it, and accidentally clicked Don’t Save on exit, Excel preserves an emergency draft for a short period.

1. Open File Explorer (Windows Key + E).
2. In the address bar, paste the following environment variable path and press Enter: %LOCALAPPDATA%\Microsoft\Office\UnsavedFiles
3. Look for files named in this format: Book1((Unsaved-30819472394)).xlsb (or .xla).
4. Copy the file to your Desktop.
5. Right-click the file, select Rename, and change the extension to .xlsx (or .xlsb).
6. Double-click the file to open it in Excel, then click File > Save As to commit it to permanent storage.

---

Location 2: Existing Workbooks After a Crash (The AutoRecover Cache)

If you were working on an existing file that had already been saved previously, AutoRecover saves incremental state snapshots to your user roaming profile every few minutes (default is 10 minutes).

1. Press Windows Key + R to launch the Run dialog.
2. Paste the following path and press Enter: %APPDATA%\Microsoft\Excel\
3. You will see several folders named after your workbooks (for example, Quarterly_Report_2026.xlsx will have a matching folder named Quarterly_Report_2026123456789).
4. Open the corresponding folder.
5. Look for an .asd (AutoRecover Save Data) file or a hidden .xlsb file inside.
6. If the file has an .asd extension:
   • Open a blank Excel document.
   • Go to File > Open > Browse.
   • Change the file type dropdown at the bottom right from All Excel Files to All Files (.).
   • Browse to the folder, select the .asd file, and click Open.

---

Location 3: The Windows Temp Directory Fallback

If both primary recovery locations are empty, Excel’s atomic temporary files may still exist in the Windows temporary storage partition. When Excel edits a file, it creates a temporary swap copy in the background.

1. Press Windows Key + R, type %temp%, and press Enter.
2. Click the Date modified column header to sort the files from newest to oldest.
3. Look for files matching these naming conventions:
   • Files starting with a tilde and numbers (e.g., ~DF4A98.tmp)
   • Files starting with excel (e.g., excel8.tmp)
   • Files with sizes that match your missing workbook (e.g., several megabytes rather than 0 KB)
4. Copy any candidate .tmp files to your Desktop.
5. Rename the file extension from .tmp to .xlsx.
6. Open the renamed file. If Excel displays a message that the format does not match the extension, try renaming it to .xlsb.

If the file opens but triggers a corruption warning, repair the internal sheets using “We found a problem with some content in ‘filename.xlsx'”: Using the Open and Repair tool.

---

Why AutoRecover Failed to Trigger Automatically

If you re-opened Excel after a crash and the recovery pane was completely missing, one of four issues occurred:

1. AutoRecover Was Disabled for That Specific File

Excel allows AutoRecover to be disabled on a per-workbook basis. Go to File > Options > Save. Scroll to the bottom and check if the box marked Disable AutoRecover for this workbook only was selected.

2. The AutoRecover File Was Marked as “Disabled”

If Excel crashed while attempting to generate the AutoRecover snapshot, it flags that snapshot as a hazardous item on the next reboot to prevent an infinite crash loop.

• Go to File > Options > Add-ins.
• At the bottom, change the Manage dropdown to Disabled Items and click Go…
• If your missing workbook is listed, select it, click Enable, and restart Excel.

3. The 10-Minute Timer Had Not Elapsed

AutoRecover works on a timer, not keystrokes. If your timer is set to the default 10 minutes, and you opened a file, worked for 8 minutes, and experienced a crash, no snapshot was ever generated. Reduce this threshold to prevent future data loss:

• Go to File > Options > Save.
• Set Save AutoRecover information every to 1 or 2 minutes.

4. Cloud AutoSave Overrode Local AutoRecover

If your file is stored on OneDrive or SharePoint, Excel prioritizes cloud versioning over local AutoRecover. If cloud syncing encounters a conflict or disconnection, local AutoRecover may not create its usual desktop cache. To diagnose sync issues with cloud-hosted workbooks, see Troubleshooting “AutoSave” being disabled automatically.