File Corruption & Recovery

How to Recover an Unsaved Excel Workbook That Cannot Be Found

Nimra MalikNimra Malik Nov 3, 2026 869 views

Question details

The user needs to locate and recover an important unsaved Excel file and determine if an AutoRecover copy exists.

How to Recover an Unsaved Excel Workbook That Cannot Be Found
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user accidentally closed an Excel workbook without saving and cannot find it using standard recovery methods.
Observed behavior
The unsaved Excel workbook is missing, and standard recovery options are not displaying the file in the recent lists.
Before you start

Ensure you have not run any system cleaning software or emptied your Recycle Bin recently, as this might permanently delete temporary AutoRecover files.

Solution 1Recommended

Check the 'Recover Unsaved Workbooks' Directory

Use Excel's built-in feature designed to locate and restore recently closed files that were not saved.

Excel keeps temporary copies of your unsaved files in a specific system folder if the AutoRecover feature is active. Accessing this folder directly through Excel is the most reliable way to retrieve lost work.

1
Open Excel Recent Files

Launch Microsoft Excel. Click on the 'File' tab in the top-left corner and select 'Open', then choose 'Recent'.

2
Access Unsaved Workbooks

Scroll all the way to the bottom of your recent workbooks list and click the 'Recover Unsaved Workbooks' button.

3
Locate and Open

A file explorer window will open. Look for your missing file, select it, and click 'Open' to restore it.

Check the 'Recover Unsaved Workbooks' Directory
Save Immediately: If you successfully recover your file, be sure to use 'Save As' immediately to store it in a secure location on your hard drive.
Free Microsoft Office alternative

Prevent Future Data Loss with WPS Office

Tired of losing your unsaved work when Excel crashes? WPS Office provides a lightweight, highly compatible, and free alternative with intelligent auto-backup features to ensure your spreadsheets are always safe.

Advanced Auto-Backup capabilities protect against accidental closuresFully compatible with Microsoft Excel (.xlsx, .xls, .csv) formatsFree, lightweight, and fast to launch on any deviceFamiliar user interface for a seamless, zero-learning-curve transition
microsoft office alternative - wps office

Frequently Asked Questions

Where are AutoRecover files stored in Windows?

By default, AutoRecover files in Microsoft Office are saved in a hidden system directory located at 'C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\'. You can paste this path into Windows File Explorer to check it manually.

Why didn't Excel create an AutoRecover copy?

AutoRecover only saves files at specified intervals (usually every 10 minutes by default). If you closed the file before the first interval triggered, or if the AutoRecover setting was disabled, no temporary copy will be created.

How do I enable AutoSave to prevent future data loss?

Go to File > Options > Save. Ensure that both 'Save AutoRecover information every X minutes' and 'Keep the last AutoRecovered version if I close without saving' are checked. Adjust the minutes to a smaller number for more frequent backups.