How to Recover an Unsaved Excel File: What Actually Works

Losing an Excel file before you've had a chance to save it is one of those gut-drop moments that happens to almost everyone. The good news: Microsoft has built several recovery mechanisms directly into Excel, and understanding how they work gives you a realistic picture of what's recoverable — and what isn't.

How Excel Protects Your Work in the Background

Modern versions of Excel (2010 and later, including Microsoft 365) use two key background processes that run silently while you work:

AutoRecover saves a temporary snapshot of your open workbook at regular intervals — by default, every 10 minutes. These snapshots are stored in a dedicated temp folder on your local drive, separate from your actual file. If Excel crashes or you close it accidentally, these snapshots can be restored the next time you open Excel.

AutoSave is a different feature, available only when you're working on a file stored in OneDrive or SharePoint. It saves changes continuously — essentially in real time — and is most reliable for users who work within the Microsoft 365 ecosystem with cloud storage enabled.

Understanding which of these was active during your session determines how much of your work is actually recoverable.

Method 1: The Document Recovery Pane (After a Crash)

If Excel crashed or your computer shut down unexpectedly, Excel will usually display a Document Recovery pane the next time it opens. This pane lists any AutoRecover files it found, often with a timestamp showing when the last snapshot was saved.

Click the version you want to review. If it contains your work, use File > Save As immediately to save it to a permanent location. Don't close the recovery pane without saving first — those temp files are deleted once you dismiss them.

This method works best when:

• The crash happened while a file was open and had been open long enough for at least one AutoRecover snapshot to be created
• Excel was actively running (not a system-level shutdown before Excel could write the snapshot)

Method 2: Recover Unsaved Workbooks Manually

If Excel opens normally without showing the recovery pane, you can look for unsaved files manually:

1. Open Excel and go to File > Open
2. Click Recent in the left panel
3. Scroll to the bottom and select Recover Unsaved Workbooks

This opens the AutoRecover folder directly. Files here are temporary .xlsb or .xlsx files that Excel stored during your session. They're named with long strings of characters and won't have your original filename.

Browse by Date Modified to find the most recent version, open it, and save it immediately if it contains your work.

⚠️ These temporary files are automatically purged after a set period (typically 4 days, though this varies by Excel version and system settings). If significant time has passed since the crash, the file may already be gone.

Method 3: Check the AutoRecover File Location Directly

You can also navigate to the AutoRecover folder manually through your file system:

On Windows, the AppData folder is hidden by default. You'll need to enable Show Hidden Items in File Explorer, or paste the path directly into the address bar.

Look for .xla, .xlsx, or .tmp files with recent modification dates. These are your best candidates.

Method 4: OneDrive Version History

If the file was saved at least once to OneDrive or SharePoint, you have access to version history — a log of previous saves that Microsoft stores automatically.

To access it:

• Right-click the file in OneDrive (web or desktop app)
• Select Version History
• Browse and restore earlier versions

This is one of the more reliable recovery methods because it doesn't depend on AutoRecover. Even if you accidentally overwrote a file with bad data, version history can walk you back to a clean copy.

The catch: version history only helps if the file was previously saved. A brand-new workbook you never manually saved to OneDrive won't appear here.

The Variables That Determine What You Can Recover

Recovery outcomes differ significantly based on a few key factors:

• AutoRecover interval: If your interval is set to every 10 minutes and you worked for 8 minutes before a crash, that session may not have been captured at all. Shorter intervals (2–5 minutes) improve recovery odds but are set manually under File > Options > Save.
• Whether AutoSave was on: Files stored locally with AutoSave off rely entirely on AutoRecover snapshots, which are point-in-time and can miss recent changes.
• New vs. previously saved files: A brand-new workbook that was never saved manually has no version history and relies entirely on whether an AutoRecover temp file was written.
• Time elapsed since the loss: Temp files have expiration windows. The sooner you attempt recovery, the better.
• Excel version and OS: Recovery paths, feature availability, and default settings vary between Excel 2016, 2019, 2021, and Microsoft 365 — and between Windows and macOS builds.

What "Unsaved" Actually Means in Different Scenarios 💾

There's an important distinction between:

• A file that was never saved (created in a new workbook, never hit Save) — recovery depends entirely on AutoRecover temp files
• A file that was saved previously but had new unsaved changes at the time of the crash — you can at minimum recover the last saved version, and possibly a more recent AutoRecover snapshot
• A file that was saved to cloud storage — version history and AutoSave give you significantly more options

Each scenario has a different floor for what's recoverable. Someone working on a 3-hour spreadsheet in a new workbook with default settings faces a very different situation than someone whose OneDrive-connected file closed unexpectedly after five minutes of additional edits.

How much work you get back depends heavily on which of these scenarios matches what actually happened — and what your Excel settings were configured to do before the problem occurred.