Recover Unsaved Excel File: AutoRecover, Temp Files, and Backups (2026 Guide)

Recover Unsaved Excel File the Same Day You Lost It

Excel crashed. Power dropped. You hit "Don't Save" by mistake. The good news is that a modern Microsoft Excel install keeps several silent safety nets running in the background. AutoRecover writes hidden snapshots every ten minutes. The Recent Workbooks list remembers files you never saved. The temp folder usually holds the last draft for at least four days. This guide walks you through every recovery path in the order that gets results fastest.

Most users discover Excel's recovery features only after a disaster. By then they have closed the warning dialog, restarted Windows, or worse — reinstalled Office. Each of those steps wipes out one of the safety nets we are about to use. The fixes below take less than five minutes when you start right after the crash. They keep working for hours afterward, but your odds drop with every reboot.

Method 1: Open Excel and Check Recent Workbooks

When Excel reopens after a crash it shows a Document Recovery pane on the left. The list contains every workbook AutoRecover saved during your last session, even files you never named. Click any entry to preview it, then choose Save As to commit the version to disk. If the pane does not appear, click File then Open then Recent and scroll to the bottom for the button "Recover Unsaved Workbooks". This shortcut opens the hidden UnsavedFiles folder and lists every untitled draft for the last four days.

On Mac the same feature lives under File then Open Recent then Recover Unsaved Workbooks. The dialog points at the AutoRecovery container path on macOS Sonoma and newer. Double-click any .xlsb file to preview it, then save the result to your desktop before doing anything else. Mac users running Microsoft 365 also see a small "Available Files" banner on launch — click it the very first time Excel starts after a crash.

Method 2: AutoRecover Folder for Saved Files

AutoRecover is different from Recover Unsaved Workbooks. AutoRecover handles files you had already named and saved at least once. After a crash, Excel restores the snapshot it took ten minutes before the crash. Open Excel, click File then Info. Under Manage Workbook you will see one or more entries labelled "When I closed without saving". Click the most recent one. Excel opens the snapshot in a yellow banner. Click Restore to overwrite the saved version, or Save As to keep both copies.

The default AutoRecover interval is ten minutes, which means you can lose up to ten minutes of work. Change this under File then Options then Save. Most professionals drop it to two or three minutes for important workbooks. Confirm "Keep the last AutoRecovered version if I close without saving" is checked. Then make sure the AutoRecover file location points at a folder you control rather than the default deep inside AppData.

Temp Folder Forensics

The temp folder also stores leftover lock files named ~$YourBook.xlsx. These zero-byte files are not your data, but their presence proves Excel had the workbook open recently. If you spot a lock file, the matching .tmp body usually sits in the same folder with a timestamp within seconds of the crash.

Search the folder for any file modified in the last hour and check the size column. Anything above 50 KB is worth opening. Do not delete temp files until you have recovered everything you need. Windows clears the folder automatically on the next major update, so move recovered files out first.

Method 4: OneDrive and SharePoint Version History

If your workbook lives in OneDrive, SharePoint, or Microsoft Teams, the cloud keeps every version it has ever saved. Open the file in a browser, click the filename in the top-left and choose Version History. You will see timestamps for every autosave, sometimes hundreds of entries. Click any version to preview, then Restore to make it the current copy. The previous version moves down the list rather than getting deleted, so you can always undo the restore.

Version History also handles the most painful case of all: a coworker pasted over your sheet and saved the file. Open the workbook in the browser, restore the version dated before the bad save, then close the file. The desktop app syncs the rolled-back copy down to your local OneDrive folder within a minute. If you are learning Excel online in a managed tenant, IT can usually recover from deeper backup tiers.

One detail that catches teams out: Version History counts autosaves separately from manual saves. A heavily edited file can blow through dozens of versions in a single afternoon, pushing your oldest entries off the bottom of the 500-slot list. SharePoint admins can extend retention from the site library settings, and Microsoft 365 plans with Backup add a 365-day rolling retention layer. If a critical workbook lives on a shared site, ask IT to enable both extensions before the first deadline crunch arrives.

Method 5: Previous Versions and Time Machine

Windows Pro and Enterprise quietly run Volume Shadow Copy. Open File Explorer, right-click the folder that held the lost workbook and choose Properties then Previous Versions. The list shows snapshots Windows took before any system event — not just Office events. Open one, copy the workbook back to your desktop and rename it. If the Previous Versions tab is empty, you are on Windows Home or the feature was disabled. Turn it on under System Properties then System Protection.

Mac users get the same safety net for free through Time Machine. Plug in the backup drive, open the folder that held the file, click the clock icon in the menu bar and choose Enter Time Machine. The Finder window flies back through every hourly snapshot. Navigate to the timestamp before the crash and click Restore. Time Machine keeps hourly snapshots for 24 hours, daily for a month, and weekly until the backup drive fills up.

How to Stop Losing Excel Files Again

Recovery is great. Avoiding recovery is better. Turn AutoSave on at the top of every workbook by saving the file straight to OneDrive or SharePoint. AutoSave writes every two seconds in the background and survives any crash short of a hard drive failure. Drop the AutoRecover interval to three minutes under File then Options then Save. Tick "Keep the last AutoRecovered version if I close without saving". Set a daily reminder to copy your most important workbooks into a separate folder.

Power users go one step further and lock down keyboard shortcuts. The default Ctrl + S writes the file. Pair it with Ctrl + Shift + S to write a dated copy. Build a macro that runs every five minutes and saves a snapshot to a hidden folder. None of this matters if you do not test the recovery path. Once a month, close a sample workbook without saving and step through Method 1. A two-minute fire drill beats two hours of panic.

Train every Excel user in your team on the recovery flow, not just the prevention flow. People panic differently when their own data is gone, and a calm checklist is the fastest way to keep them moving. Print the seven-step recovery list and stick it inside the front cover of the team handbook. The first time someone uses the list and recovers a file in under five minutes, your colleagues will start to view file safety as a team skill rather than a personal failure.

Why Excel Recovery Works at All

Excel's recovery engine is older than most laptops. It traces back to Office 2003 when Microsoft first shipped the AutoRecover service. The format and storage path have shifted with every Office version, but the core logic has not changed in twenty years. Every ten minutes the running Excel process pushes a binary copy of every open workbook to a hidden folder. The copy includes formulas, formats, charts and even external links. The copy is wiped only when you save the file successfully or close Excel cleanly.

Knowing how AutoRecover thinks lets you bend the system. If you want a longer safety net, lower the interval to two minutes. If you work on huge models that lag during AutoRecover, raise the interval to twenty minutes and rely on OneDrive AutoSave. If you handle sensitive data, point the AutoRecover folder at an encrypted volume so the snapshots never leak to a default Windows path. Every team I have audited finds at least one Excel disaster per quarter.

The same engineering choices apply to Word, PowerPoint, and Visio, which means the recovery instincts you build here transfer directly. Document Recovery works in every Office app. Version History works in every cloud-stored Office file. Time Machine and Previous Versions cover them all at the operating system level. Learning one recovery flow truly covers the entire Microsoft 365 productivity stack — a single hour spent here pays you back for the rest of your career.

What If Nothing Worked? Third-Party Tools

When AutoRecover, the temp folder, and version history all come up empty, third-party tools become an option. Stellar Repair for Excel, EaseUS Data Recovery, and Recuva all scan the disk for deleted file signatures. They cost between $50 and $130 and they work best if you have not written much new data since the loss. Install the tool on a different drive than the one that held the workbook — writing the installer to the same drive can overwrite the very sectors you need.

If the file is critical and the third-party scan still fails, send the drive to a clean-room data recovery service. Expect a quote between $300 and $1,500 depending on the drive size and the urgency. Reputable shops only charge if they actually recover your data. Before you ship anything, ask whether their lab is ISO 5 certified. SSDs are particularly hard to recover because TRIM zeros out the deleted sectors within seconds.

Before you spend a penny, run through every method in this guide twice. The most common reason a recovery scan finds nothing is that the user already restarted, defragged, or installed an update on top of the lost sectors. Each of those actions shrinks the recoverable window by a measurable amount. A patient operator who locks the disk and works through the methods in order will outperform expensive software every single time, especially on consumer-grade SSDs that have aggressive TRIM scheduling.

Macros, Naming, and Storage Edge Cases

Macros add one more recovery option that almost nobody uses. Open the Visual Basic editor with Alt + F11. If the lost workbook had any VBA code, the Personal Macro Workbook may still hold it in memory. Save the code to a .bas file before you close Excel. The same trick rescues custom ribbon tabs and shortcuts. Sheet structure does not survive the trick, but the macros that ran on the sheet usually do.

Train yourself to save and name every workbook within the first thirty seconds of opening it, even if you save it to the desktop and delete it later. A named file is a recoverable file. An unnamed Book1 disappears the second you click the wrong button. Power users add a keyboard shortcut for Save As Date so every working session creates a timestamped copy you can always roll back to.

Watch out for one more failure mode: split workbooks. If you opened multiple Excel windows from the same file, AutoRecover sometimes saves only the window that had focus when the crash hit. Other panes can lose their last edits even though the file looked saved. The fix is to close all but one Excel window before any risky operation, then verify the AutoRecover banner mentions the right filename when Excel reopens after the crash.

Test Your Excel Recovery Knowledge

Knowing the steps is one thing, recalling them under pressure is another. The quiz below walks you through real recovery scenarios — from a crashed laptop to an overzealous coworker who pasted over your sheet. Each question matches a method from this guide, so you can spot the gaps in your knowledge before the next crash happens. The questions are free and the explanations link back to the relevant section above. After the quiz, try the Excel cheat sheet to lock in the shortcuts that prevent data loss in the first place.

Bookmark this page before you take the quiz. Recovery scenarios tend to repeat themselves — the same coworker pastes over the same sheet, the same laptop crashes on the same VLOOKUP, the same intern hits Don't Save on the quarterly forecast. The faster you can re-find this guide when it happens, the faster you can rescue the file. Print the five-minute checklist above and tape it to the side of your monitor for the days you cannot type fast enough.

Share the link with anyone who edits Excel files as part of their job — finance teams, marketing analysts, project managers, scientists, students. Excel recovery is a universal life skill in 2026, but almost nobody learns it before they need it. By forwarding this guide once, you can spare a coworker the worst hour of their working week. Then revisit the page yourself every six months to make sure Microsoft has not moved any of the menu paths around.