Recover Unsaved Excel Files: Step-by-Step Guide

The worst moment in Excel isn't a broken formula. It's closing a file and watching your work disappear. If you're trying to recover an unsaved Excel file right now, stop clicking around randomly. There's a process, and following it in order is the difference between getting your work back and losing it for good.

Most recovery articles send you straight to AutoRecover and call it done. That works about 60% of the time. The other 40% requires knowing where to look next and what not to do while you're looking. This guide walks you through the full sequence, including the manual folder search that most tutorials skip entirely and the OneDrive edge case that nobody warns you about.

---

What You'll Get Back — and What to Check Before You Start

AutoRecover and AutoSave are not the same thing. Conflating them is the single most common reason people give up on recovery too early or trust the wrong method.

AutoRecover creates a temporary snapshot of your file at set intervals (the default is every 10 minutes, which is also, somehow, always exactly longer than the gap since your last manual save). If Excel crashes, it restores from that snapshot. If your work happened between snapshots, that portion is gone. AutoSave, by contrast, continuously saves your file to OneDrive or SharePoint in real time — but it's only available in Microsoft 365, and only when the file is stored in the cloud.

Which recovery method fits your situation

Before you try anything, answer two questions: Was this file ever saved to disk at any point? And was it stored locally or in OneDrive?

If the file was never saved (brand new, no location yet), your only option is Excel's unsaved workbook temp folder, covered in Step 1 below. If it was saved before but Excel crashed before your latest changes were written, AutoRecover may have a snapshot — also Step 1. If you saved and closed the file but now realize you overwrote something important, that's a different scenario covered in Step 3 (version history and Windows File History, not AutoRecover).

Knowing which scenario you're in saves you from wasting time on methods that can't help you.

This guide focuses on recovery. For a broader look at how saving and file management work in Excel, the Excel File Management and Sharing guide is worth reading before something goes wrong.

---

Step 1: Find Your Unsaved Workbook Using Excel's Built-In Recovery Tools

This is where to start, every time, before touching anything else.

Use the Document Recovery pane when Excel restarts after a crash

After a crash, Excel usually relaunches and shows a Document Recovery pane on the left side of the screen. You'll see a list of files it held onto. Click the one you want, confirm it's the right version, then save it immediately to a real location — not back to the temp folder.

If the pane doesn't appear on its own, don't assume recovery failed. Go to File > Info > Manage Workbook and look for entries labeled "When I closed without saving." That's Excel's way of flagging temp files it kept.

Open an unsaved workbook manually through File > Info

On Windows: File > Info > Manage Workbook > Recover Unsaved Workbooks. This opens the unsaved workbooks folder directly in a dialog window.

On Mac: Go to File > Recent > Recover Unsaved Workbooks. In some versions of Excel for macOS this option isn't visible — if that's the case, skip to Step 2, which covers the manual file path on Mac.

Once you open the temp file, use Save As immediately. Temp files are deleted when you close Excel. Don't browse around or copy data out first — save to a real folder first, then do everything else.

---

Step 2: Search for Temporary Files When the Recovery List Comes Up Empty

If Step 1 turned up nothing, the file may still exist. Excel's recovery interface just isn't surfacing it. This is the part most tutorials skip.

Where temporary Excel files live on Windows and Mac

On Windows 10 and Windows 11, AutoRecover files are stored at:

C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\

AppData is a hidden folder by default. To reach it, open File Explorer, type %appdata%\Microsoft\Excel\ directly into the address bar, and press Enter. Look for files with .xlsb or .xlsx extensions, or files with no extension at all. Sort by date modified so the most recent files appear first. If you find one that matches the timeframe of your lost work, copy it to your desktop before opening it.

On Mac, navigate in Finder to:

/Users/[YourUsername]/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery/

The Library folder is hidden on macOS by default. In Finder, hold Option and click the Go menu — Library will appear in the list. Follow the path from there.

If nothing shows up in either location and the recovery list was empty, the file may not have had a chance to write a snapshot — particularly if it crashed very quickly or AutoRecover was disabled. Check Step 3 before accepting a hard loss.

---

Step 3: Restore a Previous Version from OneDrive or Windows File History

Once you've confirmed there's no usable temp file, the question shifts from "did Excel save a snapshot?" to "did the operating system or cloud service save one?"

Recover an overwritten or lost file from OneDrive

If your file was stored in OneDrive and you're on Microsoft 365, right-click the file in OneDrive (browser or desktop app) and choose Version History. You'll see timestamped versions you can restore or download individually. This is also how you recover an overwritten Excel file — not from within Excel itself, but from OneDrive's version log.

There's a painful edge case worth naming. Some users have reported files silently rolling back in OneDrive with nothing in version history to explain it and no temp file anywhere. If that's you: check the OneDrive recycle bin online (not the Windows recycle bin — the one at onedrive.live.com), and look for the Restore your OneDrive option, which resets the entire drive to a prior point in time. It's a last resort, but it's there.

Recover a local file using Windows File History

If your file is local only, Windows File History may have a copy — if it was configured before the loss happened. Search for "Restore your files with File History" in Windows search, navigate to the folder where the file lived, and browse through historical snapshots. Microsoft's File History documentation covers setup if you haven't enabled it yet.

---

Mistakes That Cost You the File — and How to Prevent This from Happening Again

The most expensive mistake I see people make mid-recovery is closing Excel while searching for their file. The Document Recovery pane disappears. The temp files that were still accessible get cleared. A recoverable situation becomes unrecoverable. If you're in the middle of a recovery right now: keep Excel open until the file is saved to a permanent location.

The second mistake is leaving the AutoRecover interval at its default. Ten minutes is too long for any critical or time-sensitive work. Change it now: go to File > Options > Save, and set "Save AutoRecover information every X minutes" to 2 or 3. It's a 30-second change.

1. Open Excel and go to File > Options > Save.
2. Find "Save AutoRecover information every X minutes."
3. Change the value to 2 or 3 minutes.
4. Click OK. Done.

If you're on Microsoft 365 and your files live in OneDrive, enabling AutoSave is worth doing today — not after the next crash. AutoSave keeps pace with your work in real time; AutoRecover is the fallback when AutoSave isn't running. They're meant to work together.

For anyone newer to Excel who wants to understand how file saving works before something goes wrong, the Excel for Beginners starter guide covers save behavior in a way that makes the recovery logic here make more sense.

Take one action from this article right now: open Excel, go to File > Options > Save, and set the AutoRecover interval to 2 minutes. The recovery steps above will still be here if something goes wrong — but you'll be starting from a much shorter gap.

---