How to Recover an Excel File That Wasn't Saved

Closing Excel without saving, a sudden crash, or a frozen laptop — it happens to everyone. The good news is that Microsoft Excel has several built-in recovery mechanisms, and unsaved files are recoverable more often than most people expect. How much you can recover, and how easily, depends on your version of Excel, your settings, and how your system is configured.

Why Unsaved Excel Files Can Be Recovered at All

Excel doesn't wait for you to hit Ctrl+S before writing anything to disk. By default, it runs a background process called AutoRecover, which saves a temporary snapshot of your workbook at regular intervals — typically every 10 minutes, though this is adjustable. These snapshots are stored in a temporary folder separate from your actual file location.

When Excel crashes or closes unexpectedly, it detects the orphaned AutoRecover file on the next launch and offers to restore it. When you close without saving, the file may still exist in that temp folder for a short window — but Excel won't always surface it automatically.

Understanding this distinction matters:

• Crash or power loss → Excel's Document Recovery panel usually opens automatically on relaunch
• Closed without saving ("Don't Save" clicked) → requires manual navigation to the AutoRecover folder
• File was saved before but overwritten → a different problem, solved differently

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

If Excel crashed, the next time you open it you'll see a Document Recovery pane on the left side of the screen. This lists any AutoRecover files Excel detected. Click the version you want, then immediately save it as a new file with File → Save As.

If that pane doesn't appear automatically:

1. Open Excel and go to File → Info
2. Look for Manage Workbook (sometimes labeled Manage Versions)
3. Click it and select Recover Unsaved Workbooks

This opens a folder of .xlsb or .xlsx temp files. Sort by Date Modified to find the most recent version of what you were working on.

Method 2: Find the AutoRecover Folder Manually 📁

If the built-in route doesn't surface your file, you can go directly to the temp folder where AutoRecover snapshots are stored.

On Windows, the default path is usually:

C:Users[YourUsername]AppDataRoamingMicrosoftExcel 

You may need to enable Show Hidden Files in File Explorer to access the AppData folder.

On Mac, the path is typically:

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

Sort files by date and look for anything matching your filename or timestamp. Open the file in Excel, then save it immediately to a permanent location.

Method 3: Check the AutoSave Temp File Location in Excel Settings

Your AutoRecover file path may differ from the default — especially on managed work computers or if you've customized Excel. To find the exact path your installation uses:

1. Go to File → Options → Save
2. Look at the AutoRecover file location field
3. Copy that path and navigate to it in File Explorer or Finder

This is the definitive location for your machine. Whatever is listed there is where Excel stores its recovery snapshots.

Method 4: OneDrive and AutoSave (Microsoft 365 Users)

If you're using Microsoft 365 (formerly Office 365) and your file was stored in OneDrive or SharePoint, you have an additional layer of protection: AutoSave. This feature saves changes continuously — not just every 10 minutes — and stores version history in the cloud.

To access previous versions:

1. Open the file in Excel
2. Click the file name in the title bar (in newer versions of Excel)
3. Select Version History
4. Browse and restore any earlier version

This is distinct from AutoRecover and is generally more reliable for recovering recent changes. The catch: it only works if the file was already saved to OneDrive or SharePoint before the problem occurred. A brand-new file that never got an initial save won't have this history.

What Affects How Much You Can Actually Recover

Not every recovery attempt returns a perfect, up-to-date file. Several variables determine how much data you get back:

Adjusting AutoRecover to Reduce Future Risk 🛡️

If recovery worked this time, it's worth tightening up your settings. In File → Options → Save, you can:

• Reduce the AutoRecover interval from 10 minutes to 1–2 minutes
• Enable "Keep the last AutoRecovered version if I close without saving" — this is the option that makes the biggest difference for accidental closures
• Set a reliable AutoRecover file location if the default path is on a drive that sometimes goes offline

These settings are per-installation, so changes on one machine don't carry over to another.

When the File Is Gone for Good

If AutoRecover has no snapshot and OneDrive has no version history, your options narrow significantly. At that point, recovery depends on whether the original file location was on a drive that supports shadow copies (Windows) or Time Machine backups (Mac). These are OS-level backups that operate independently of Excel — and whether they captured your file depends entirely on your backup configuration and timing.

What you can recover, and how current that recovery will be, comes down to which of these layers were active on your specific machine at the time.