How to Find an Unsaved Excel File: Recovery Methods That Actually Work

Losing unsaved Excel work is one of the most frustrating experiences in everyday computing — and one of the most common. Whether Excel crashed, your laptop died, or you accidentally clicked "Don't Save," the file isn't always gone for good. Understanding where Excel stores temporary data and how recovery works gives you a real shot at getting that work back.

Why Unsaved Excel Files Are Often Recoverable

Excel doesn't wait for you to hit Ctrl+S before writing data to disk. Modern versions of Excel (2010 and later, including Microsoft 365) run an AutoRecover process in the background that periodically saves a temporary snapshot of your open workbook. These snapshots are stored in a dedicated folder on your local drive — separate from your saved files.

When Excel closes unexpectedly, it uses these snapshots to offer recovery options the next time it opens. But even if that automatic prompt doesn't appear, the temporary files are often still sitting on your drive, waiting to be found manually.

The key variables that determine whether you can recover a file:

• How long AutoRecover was set to run (default is every 10 minutes; shorter intervals mean more recent snapshots)
• Whether you had saved the file at least once before the crash
• How much time has passed since the file was lost
• Your version of Excel and operating system
• Whether OneDrive or AutoSave was active during the session

🔍 Method 1: Check the Document Recovery Pane

The first place to look is Excel's built-in recovery prompt. When you reopen Excel after a crash or unexpected shutdown, a Document Recovery pane typically appears on the left side of the screen, listing recently unsaved files with timestamps.

Click any listed file to open it, then immediately save it to a permanent location. If this pane doesn't appear, it either means Excel closed cleanly (without a crash) or the AutoRecover files have already been cleared.

Method 2: Search for AutoRecover Files Manually

If the recovery pane doesn't show up, you can hunt for AutoRecover files directly on your hard drive. These are stored as .xlsb or .xlsa temporary files (or sometimes .asd files).

To find the AutoRecover folder location in Excel:

1. Open Excel and go to File → Options → Save
2. Look for the AutoRecover file location field — it shows the exact folder path
3. Copy that path and paste it into File Explorer's address bar

Common default paths:

Open that folder and look for files with recent timestamps. Files ending in .asd are AutoRecover files — you can open them directly in Excel.

Method 3: Recover Unsaved Workbooks Through Excel's Menu

For files that were never saved at all (brand new workbooks you closed without saving), Excel has a specific recovery path:

1. Open Excel
2. Go to File → Info → Manage Workbook
3. Click Recover Unsaved Workbooks

This opens a folder called UnsavedFiles inside your local AppData directory. Files here are temporary drafts Excel held onto after a "Don't Save" action. They don't stay forever — Microsoft generally clears them after 4 days, so time matters here.

Method 4: Check OneDrive Version History (If AutoSave Was On) ☁️

If you were working with a file stored in OneDrive or SharePoint with AutoSave enabled (the toggle in the top-left corner of Excel), you have access to a full version history — even if the local file is gone or corrupted.

To access it:

1. Open OneDrive in a browser
2. Navigate to the file location
3. Right-click the file → Version History

Each save point is listed with a timestamp. You can preview and restore any version. This method is significantly more reliable than local AutoRecover, because saves happen continuously — not just every 10 minutes.

The catch: AutoSave only works when the file is already stored in OneDrive or SharePoint. Files saved only to your local drive don't benefit from this.

Method 5: Search Your Entire System for Temp Files

If the above methods don't turn anything up, a broader file search can sometimes surface remnants:

• Open File Explorer and search for *.asd or *.xlsb with a recent modified date
• Check your Recycle Bin if you may have deleted the file manually
• Search for the file name (or a partial name) with the date modified filter set to the day the file was lost

On Mac, AutoRecover files are stored in: /Users/[Username]/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery/

The Variables That Shape Your Recovery Odds

Not every recovery attempt ends the same way. Several factors determine how much — if anything — you can get back:

• File was never saved once: Recovery depends entirely on AutoRecover. If the interval was 10 minutes and you worked for 45 minutes, you might recover up to 35 minutes of lost work — but not all of it.
• File was previously saved: Much better odds. AutoRecover files are more complete, and OneDrive version history may be available.
• Excel closed cleanly (you clicked "Don't Save"): AutoRecover files may still exist in the UnsavedFiles folder for a short window.
• System crash or power loss: AutoRecover is specifically designed for this — recovery pane is most likely to appear.
• Time elapsed: The longer you wait, the higher the chance temp files have been overwritten or cleared by the OS.

Your recovery path looks meaningfully different depending on which of these scenarios describes your situation — and whether your Excel setup had AutoSave, AutoRecover, and cloud sync configured before the file was lost.