Where Does Excel Store Recovered Files: Hidden Temp Folder Locations Explained

When Excel crashes or loses power, it automatically saves backup copies to keep your work safe. 💻 These hidden folders act as a safety net, but they’re not always obvious—especially since paths change depending on whether you’re using Windows 10, macOS, or an older Office version.

I’ve seen users panic when files vanish after restarting Excel, only to realize they were tucked away in these system folders. The key is knowing where to look, since recovery files often disappear after opening Excel again unless you act fast.

Pro tip: If you’re using Office 365, the recovery paths might differ slightly from older versions like 2019 or 2016. Always double-check the %AppData% directory first—it’s the most reliable spot for unsaved files.

For deeper dives, I’ll walk you through how to manually locate these folders using File Explorer or Command Prompt in the next section. ✨

Excel AutoRecover and crash recovery File paths

Excel’s AutoRecover system works like a digital safety net, automatically saving temporary copies of your workbook every 10 minutes (configurable in File > Options > Save). When Excel crashes or closes unexpectedly, these backups become your lifeline.

The system uses two distinct pathways: one for unsaved files and another for crash recovery. Unsaved files land in the %AppData%\Microsoft\Office\UnsavedFiles folder, while crash-recovered files often appear in %Temp%\ExcelRecovery—though paths can shift based on your OS and Office version.

Here’s the technical breakdown: AutoRecover files (.asd extensions) store your workbook data in a compressed format, with metadata about the last save time. Windows users will find these in C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Office\UnsavedFiles, while macOS paths typically follow /Users/[YourUsername]/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery.

Office 365 adds complexity by sometimes using cloud-linked temp folders, which can make manual recovery trickier. The %Temp% folder (usually C:\Users\[YourUsername]\AppData\Local\Temp) often holds crash-recovered files with names like Excel8.0\ followed by random alphanumeric codes.

Why do some files vanish after reopening Excel? When you restart Excel, it automatically cleans up temporary files—including recovery versions—unless you’ve manually saved your workbook. This is why acting within 24 hours (Excel’s default retention period for AutoRecover files) is critical.

The system prioritizes space management, and older recovery files get purged first. For users on Office 365, this cleanup happens faster due to cloud synchronization protocols that may override local temp folder policies.

File paths also differ by Office version. Older versions like Excel 2010-2013 used %AppData%\Microsoft\Excel\ for recovery, while newer versions (2016+) default to the UnsavedFiles structure. macOS users face additional challenges because Apple’s sandboxing restricts direct access to some recovery folders, requiring Terminal commands to uncover hidden files.

The key difference between unsaved and crash-recovered files lies in their triggers: unsaved files appear when you forget to hit "Save," while crash-recovered files materialize only after Excel force-closes.

What most people don’t realize is that Excel’s recovery system has a 10-file limit for unsaved documents in the UnsavedFiles folder. Once you hit this cap, older files get overwritten—another reason to act fast.

The .asd files are actually XML-based archives containing your workbook’s raw data, which is why they can sometimes be manually extracted using third-party tools if Excel’s built-in recovery fails.

For power users, enabling AutoRecover every 5 minutes (instead of the default 10) in Excel’s options can double your chances of recovering lost work.

Pro tip: If you’re troubleshooting missing files, check the %AppData% folder first—it’s the most consistent location across Windows versions. For macOS, use Finder > Go > Go to Folder and enter ~/Library/Containers/com.microsoft.Excel/Data/Library/Preferences to access hidden recovery paths.

The science here is simple: Excel’s recovery system balances convenience with storage efficiency, but understanding these paths gives you the edge when disaster strikes. 🔥

How to locate and restore lost Excel files

Start by opening File Explorer and navigating to %AppData%\Microsoft\Office\UnsavedFiles. Press Win + R, type the path exactly, and hit Enter. You’ll see your unsaved workbooks listed with generic names like "Book1.xlsx" or timestamps.

For crash-recovered files, check %Temp%\ExcelRecovery using the same shortcut. If these folders are empty, try enabling hidden files in File Explorer (View > Show > Hidden items) to reveal any overlooked recovery files.

For stubborn cases, use Excel’s built-in recovery tool: open Excel, go to File > Open > Recent, then click Recover Unsaved Workbooks. This scans all recovery locations at once.

If that fails, try the Command Prompt method: open CMD as admin, type cd %AppData%\Microsoft\Office\UnsavedFiles, then dir /a to list hidden recovery files. You can drag these directly into Excel to restore them.

If you’re using Office 365, recovery paths may include cloud-linked temp folders. Check OneDrive > Files > Recovered or OneDrive > Temp folders for auto-saved versions. For older Office versions (2019/2016), focus on local paths—these rarely sync to cloud storage.

Pro tip: Copy any recovered files immediately to a safe location (like your Desktop) before opening them, as Excel may overwrite recovery folders upon launch.

When files still won’t appear, try third-party tools like Excel File Recovery or Stellar Phoenix, which scan deeper system folders. Always back up recovered files to an external drive or cloud storage before editing—this prevents accidental overwrites.

For macOS users, use Terminal to navigate hidden folders: type open ~/Library/Containers/com.microsoft.Excel/Data/Library/Preferences to access recovery paths.

To prevent future losses, adjust AutoRecover settings: go to File > Options > Save and reduce the save interval to 5 minutes. Also enable AutoSave to OneDrive (if using Office 365) for an extra layer of protection.

Regularly back up critical files manually—this is the simplest way to avoid recovery headaches entirely.