How to Recover an Excel File That Was Not Saved

Losing an unsaved Excel file is one of those gut-punch moments that feels permanent — but often isn't. Microsoft Excel has several built-in recovery mechanisms, and Windows and macOS add a few more layers of protection underneath. Whether you closed the file accidentally, Excel crashed mid-session, or your computer restarted during an update, there are real, structured paths to getting that data back.

How Excel Protects Your Work Automatically

Modern versions of Excel (2010 and later, including Microsoft 365) run a background process called AutoRecover. At a set interval — typically every 10 minutes by default — Excel saves a temporary snapshot of your open workbooks to a designated folder on your system. This is separate from the file you'd save manually with Ctrl+S.

There's also AutoSave, which is distinct from AutoRecover. AutoSave is a Microsoft 365 feature that continuously syncs your file to OneDrive or SharePoint in near real-time. If AutoSave was active when you were working, your file likely exists in the cloud with version history intact — even if you never hit Save manually.

Understanding which of these was running during your session is the first question worth answering, because it determines where to look.

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

When Excel crashes or closes unexpectedly, it typically detects this on the next launch and opens the Document Recovery pane automatically. This panel displays any AutoRecover snapshots from your previous session.

If you see your file listed there, open it and immediately save it to a permanent location with File → Save As.

If the recovery pane doesn't appear, Excel may have closed too cleanly (e.g., you clicked "Don't Save") and suppressed it.

Method 2: Browse the AutoRecover Folder Manually 💾

AutoRecover snapshots are stored as .xlsb or .xlsx files in a hidden system folder. You can find its location by going to File → Options → Save in Excel — the AutoRecover file location path is listed there.

Typical default paths:

Navigate to that folder using File Explorer or Finder, look for files matching your workbook's name, and open the most recent one. Sort by date modified to find the closest snapshot to when you were working.

These temp files are automatically deleted once you close Excel normally — so this method only works if the session ended abnormally (crash, power loss, forced restart).

Method 3: Recover Unsaved New Files Never Saved Once

If you created a brand-new workbook, started adding data, and closed without ever saving — including saying "No" to the save prompt — Excel may still have a recovery copy in the Unsaved Files folder.

Go to File → Info → Manage Workbook → Recover Unsaved Workbooks. This opens a folder of draft .xlsb files that Excel held onto temporarily. These files are kept for a limited time (typically a few days) before being automatically purged.

This is a different location than the AutoRecover path and specifically catches that "I accidentally clicked Don't Save" scenario.

Method 4: Check OneDrive or SharePoint Version History

If you were working from a file stored in OneDrive or SharePoint with Microsoft 365's AutoSave active, the file is almost certainly recoverable — even to specific earlier points.

Open OneDrive in your browser, find the file, right-click it, and select Version History. You'll see a timestamped list of saved states. You can preview and restore any version from that list. Microsoft 365 retains version history for a substantial period, though how far back you can go depends on your subscription tier and storage settings.

This approach also applies if someone else accidentally overwrote or deleted the file from a shared location.

Method 5: Check Windows File History or macOS Time Machine 🔄

If your machine runs Windows File History (a built-in backup feature) or macOS Time Machine, and backups were configured before your session, you may be able to restore a previous version of the file directly.

On Windows: right-click the folder where the file was saved → Restore previous versions.

On macOS: open Time Machine and navigate to the folder — you can scroll back through snapshots by date.

This only helps if the file had been saved at least once before to a location covered by the backup. For brand-new files that were never saved, this path won't apply.

The Variables That Determine What's Recoverable

Not every situation leads to full recovery. Several factors shape your odds:

• AutoRecover interval — A 10-minute interval means up to 10 minutes of work can be lost even with a good snapshot. Users who adjusted this to 1–2 minutes fare better.
• Whether AutoSave was active — This depends on whether the file was stored in OneDrive/SharePoint and whether you had a Microsoft 365 subscription.
• How the session ended — A crash leaves AutoRecover files intact. A clean "Don't Save" close may delete them.
• Operating system and Excel version — Older Excel versions (pre-2010) have limited or no AutoRecover capability. Some enterprise IT configurations disable or redirect AutoRecover paths.
• How long ago the file was closed — Unsaved recovery files are purged after a period; the sooner you look, the better.

What to Do Going Forward

Once you recover what you can, it's worth adjusting a few settings. Lowering the AutoRecover interval to 2–5 minutes, enabling AutoSave by defaulting new files to OneDrive, and periodically pressing Ctrl+S manually all reduce the exposure window. Some users also turn on File History on Windows or ensure Time Machine is running on Mac as a secondary safety net.

The actual recovery path that works for you depends on which features were active during your session, which version of Excel you're running, where the file was stored, and how the session ended — factors that vary considerably from one setup to the next.