How to Recover an Excel File That Was Not Saved

Losing unsaved Excel work is one of the most frustrating experiences in everyday computing — and it happens to nearly everyone at some point. Whether a power outage cut your session short, Excel crashed unexpectedly, or you accidentally clicked "Don't Save," the data isn't necessarily gone. Excel has several built-in recovery mechanisms, and understanding how they work gives you the best chance of getting your file back.

How Excel Protects Unsaved Work

Microsoft Excel has two core features designed specifically for this situation:

AutoRecover automatically saves a temporary snapshot of your workbook at regular intervals — by default, every 10 minutes. These snapshots are stored in a hidden system folder and are separate from your actual saved file. When Excel closes abnormally, it uses these snapshots to offer a recovery option the next time you open the application.

AutoSave is a newer, cloud-connected feature available when you're working in OneDrive or SharePoint. It saves changes continuously in near real-time, which is a fundamentally different level of protection than AutoRecover.

These two features are often confused, but they serve different purposes and behave differently depending on your setup.

Step 1: Check the Document Recovery Pane

The first thing to do after Excel crashes or restarts unexpectedly is simply reopen Excel. If AutoRecover captured a snapshot before the crash, Excel will automatically display a Document Recovery pane on the left side of the screen. This pane lists available recovered versions of recently open files.

• Click on the recovered file to open it
• Review the content and verify how recent the snapshot is
• Save it immediately with File → Save As if the data looks correct

If this pane doesn't appear, it means either Excel closed normally (so no recovery was triggered), or AutoRecover didn't have time to save a snapshot before the crash.

Step 2: Search for AutoRecover Files Manually

If the Document Recovery pane doesn't appear, you can search for AutoRecover files directly. Their location depends on your operating system and Excel version:

To find the exact path on your machine: go to File → Options → Save (Windows) or Excel → Preferences → Save (Mac). The AutoRecover file location is listed there.

AutoRecover files use the .xlsb or .xlsx extension and are named with the original filename followed by a timestamp or version number. Open the folder, sort by Date Modified, and look for recent entries.

⚠️ These temporary files are deleted automatically once Excel closes normally — so if you saved and closed the file yourself, the AutoRecover snapshots will already be gone.

Step 3: Recover a File That Was Never Saved at All

If you created a brand-new workbook and closed without saving even once, there's still one more place to look: the Unsaved Workbooks folder.

In Excel on Windows:

1. Go to File → Info → Manage Workbook
2. Select Recover Unsaved Workbooks
3. A folder will open containing .xlsb draft files — browse for yours by date

This folder is separate from the AutoRecover path and specifically holds files that were never given a save location by the user.

On Mac, this recovery path is less reliable and depends heavily on which version of Excel is installed.

Step 4: Check OneDrive or SharePoint Version History 🔍

If your file was saved to OneDrive or SharePoint — even just once — version history is available and can be a powerful recovery tool. These platforms store previous versions of files automatically.

To access version history:

• OneDrive (web): Right-click the file → Version History
• SharePoint: Open the file library → click the three-dot menu → Version History
• Within Excel with AutoSave on: Go to File → Info → Version History

Version history entries are time-stamped, so you can browse back to a point before data was lost or overwritten.

Variables That Determine Your Recovery Outcome

How much data you can recover — and which method will work — depends on several factors:

• AutoRecover interval setting: The default is 10 minutes, but users can set it anywhere from 1 to 120 minutes. A longer interval means potentially more data loss between snapshots.
• How Excel closed: A crash or power failure triggers recovery; a normal "Don't Save" close typically deletes the AutoRecover snapshots immediately.
• Whether the file had ever been saved: Files saved at least once have a defined path; brand-new unsaved workbooks rely entirely on the Unsaved Workbooks folder.
• Cloud vs. local storage: Files stored in OneDrive or SharePoint have continuous version history available; locally stored files depend entirely on AutoRecover.
• Operating system and Excel version: Recovery folder paths and feature availability differ meaningfully between Windows and macOS, and between older perpetual licenses and Microsoft 365 subscriptions.
• Time elapsed since the crash: AutoRecover files can be overwritten or cleaned up if you've opened and closed Excel several times since the incident.

Different Setups, Different Results

A Microsoft 365 subscriber working entirely within OneDrive has access to near-continuous version history and is unlikely to lose more than seconds of work. Someone running Excel 2016 on a local drive with default AutoRecover settings could lose up to 10 minutes of changes — or everything if they closed the file without saving.

Users on macOS face a different set of paths and, in some versions, more limited recovery options compared to Windows. IT-managed corporate environments may also have configured AutoRecover or backup policies differently from the defaults.

Your recovery options are directly shaped by how your specific version of Excel is configured, where your file was stored, and the exact sequence of events that led to the data loss.