How to Recover an Unsaved Excel File: What Actually Works

Losing an Excel file before saving it is one of those gut-drop moments that most people have experienced at least once. Whether Excel crashed mid-project, your laptop died, or you accidentally clicked "Don't Save," the data isn't always gone for good. Excel has several built-in mechanisms designed to catch exactly these situations — but how well they work depends on your version, your settings, and how your system was configured before the problem happened.

Why Unsaved Excel Files Can Often Be Recovered

Excel doesn't wait for you to manually save to preserve your work. Modern versions of Excel (2010 and later, including Microsoft 365) include two key background features:

• AutoRecover — saves a temporary snapshot of your open workbook at regular intervals (every 10 minutes by default)
• AutoSave — available in Microsoft 365, continuously saves to OneDrive or SharePoint if the file is stored in the cloud

These aren't the same thing. AutoRecover is a local safety net for crashes. AutoSave is a real-time cloud sync. Understanding which one applies to your situation is the first step.

Method 1: Use Excel's Built-In Document Recovery Panel

If Excel crashed or closed unexpectedly, it will usually detect this the next time you open it and display a Document Recovery pane on the left side of the screen. This pane lists any files that were open when the crash occurred, along with timestamps.

Click the file you want to restore, review it, and — critically — save it immediately with a permanent name and location. The recovered version is still temporary at this stage.

If the recovery pane doesn't appear automatically, don't panic. There are other places to look.

Method 2: Find the AutoRecover File Manually

Excel stores AutoRecover files in a temporary folder on your system. You can locate this path directly inside Excel:

1. Go to File → Options → Save
2. Look for the AutoRecover file location field — it shows the exact folder path

On Windows, this is typically something like: C:Users[YourName]AppDataRoamingMicrosoftExcel

Navigate to that folder in File Explorer and look for files ending in .xlsb or .asd. These are AutoRecover snapshots. Open them in Excel and save immediately if you find your data.

On Mac, the AutoRecover path is usually found under: /Users/[YourName]/Library/Application Support/Microsoft/Office/Office 2011 AutoRecovery/ (The exact path varies by Office version.)

Method 3: Recover a File Never Saved in the First Place 💾

This is a different scenario — you created a new workbook, worked on it, then closed without ever saving it once. Excel has a specific recovery path for this:

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

This opens a folder of draft files that Excel temporarily held onto. These are only kept for a limited time (typically a few days), so acting quickly matters.

Alternatively, you can navigate directly to: C:Users[YourName]AppDataLocalMicrosoftOfficeUnsavedFiles

Method 4: Check OneDrive or SharePoint Version History

If you were working with a file stored in OneDrive or SharePoint and had AutoSave enabled, you may be able to restore a previous version even if the file was overwritten or improperly closed.

In Excel with Microsoft 365:

1. Go to File → Info → Version History
2. Browse the list of auto-saved versions with timestamps
3. Open the version you need and save it as a new file

This method works best for users whose files live in the cloud by default. If your file was saved only to a local drive, OneDrive version history won't apply.

Key Variables That Affect Recovery Success

Not every recovery attempt works, and the outcome depends on several factors:

The Setting Most People Forget to Check ⚙️

In File → Options → Save, there's a checkbox labeled "Keep the last autosaved version if I close without saving." If this is unchecked, Excel won't retain a recovery copy when you choose not to save on exit. Many users don't realize this is a toggle at all — let alone that it might be off.

This is worth verifying now, before you ever need it.

When Recovery Isn't Possible

If AutoRecover was disabled, the temporary file window has passed, and the file wasn't cloud-synced, recovery becomes significantly harder. Third-party file recovery tools exist and can sometimes retrieve deleted or lost files from local storage, but their success rate depends heavily on whether the disk space has been overwritten since the data was lost. These tools operate at a different level — scanning for file fragments rather than using Excel's own recovery systems.

What Your Situation Actually Determines

The right recovery path depends entirely on details specific to your setup: which Excel version you're running, where the file was stored, whether AutoRecover was active and at what interval, and how much time has passed. Someone using Microsoft 365 with OneDrive storage has meaningfully different options than someone running Excel 2016 on an offline machine. The methods above cover the full range — but which ones are actually available to you right now comes down to your own configuration. 🔍