Lost an Excel file you forgot to save? We tested every recovery method on both Windows 11 and macOS Sonoma using Excel 2024 (Microsoft 365), and most unsaved files can be recovered in under 3 minutes.
- AutoRecover saves backup copies every 10 minutes by default, and you can set it as low as 1 minute
- Recover Unsaved Workbooks (File > Info > Manage Workbook) finds lost files in about 30 seconds
- Temp files live in AppData\Local\Microsoft\Office\UnsavedFiles on Windows
- OneDrive users get automatic version history with up to 500 previous versions per file
- Setting AutoRecover to 2-3 minutes and enabling “Keep the last autosaved version” prevents most data loss
#How Does Excel AutoRecover Work?
AutoRecover periodically saves a temporary copy of your open workbook in the background. These copies are completely separate from your actual file, and they stay on your hard drive even if Excel crashes or you close without saving.
One important detail: AutoRecover only works for files saved at least once. Brand-new workbooks that were never saved go through a different mechanism called AutoSave for Unsaved Workbooks.
To check your settings, open Excel and go to File > Options > Save. Find Save AutoRecover information every X minutes, set it to 2 or 3 minutes, and check Keep the last autosaved version if I close without saving.
According to Microsoft’s support documentation, AutoRecover files are kept for 4 days. Excel deletes them automatically after that.
We tested this on our Windows 11 PC with Excel 365, deliberately force-closing Excel during a large spreadsheet edit with AutoRecover set to 2 minutes. The Document Recovery pane appeared on relaunch showing changes from just 90 seconds before the crash.
#What Are the Best Methods to Recover an Unsaved Excel File?
Start with Method 1 and work down.
Method 1: Recover Unsaved Workbooks (about 30 seconds)
Open Excel, go to File > Info, click Manage Workbook, and select Recover Unsaved Workbooks. Browse the temp files by timestamp and open the most recent one. Save it immediately with File > Save As.
Method 2: Document Recovery Pane
If Excel crashed, just reopen it. The Document Recovery pane shows up on the left side automatically, listing all recoverable versions. Click your file and save.
Method 3: Check the temp folder directly
Sometimes the Recovery pane doesn’t show up. Go straight to the folder instead:
- Windows:
C:\Users\YourName\AppData\Local\Microsoft\Office\UnsavedFiles - Mac:
~/Library/Containers/com.microsoft.Excel/Data/Library/Application Support/Microsoft
Open any .xlsb or .tmp files you find in Excel, check whether they contain your lost work, and save with a new name if they do.
If you’re dealing with Excel files that won’t open, that’s file corruption.
#Recovering Previous Versions of Saved Files
You saved over a file and want an earlier version back. This is a different problem entirely.
Version History in Microsoft 365
If your file lives on OneDrive or SharePoint, Excel keeps automatic version history. Based on Microsoft’s version history documentation, you can access up to 500 previous versions. Open the file, go to File > Info > Version History, and click Restore.
We tested this on our MacBook running macOS Sonoma with a OneDrive-synced workbook. Version history showed 12 auto-saved versions from a single 45-minute editing session.
Windows File History
Right-click any Excel file and select Properties > Previous Versions to restore from a backup point. File History must be enabled first (Settings > Update & Security > Backup).
macOS Time Machine
Enter Time Machine from the menu bar while in Finder, browse to your file, and pick a snapshot.
For those who need to unlock a password-protected spreadsheet, version history won’t remove the password but can restore data from before protection was added.
#Recovery Differences Between Windows and Mac
The core features work on both platforms, but paths and backup tools differ significantly.
On Windows, the default AutoRecover folder is C:\Users\YourName\AppData\Local\Microsoft\Office\UnsavedFiles. You can also find AutoRecover copies at the path listed in File > Options > Save under “AutoRecover file location.” Windows File History provides system-level backup if you’ve enabled it.
Mac stores AutoRecover files in a hidden folder: ~/Library/Containers/com.microsoft.Excel/Data/Library/Application Support/Microsoft. Press Cmd + Shift + G in Finder and paste the path. Time Machine handles system-level backup with hourly automatic snapshots.
One thing we noticed in testing: the Document Recovery pane appeared more reliably on Windows than on Mac after force-quitting Excel, which is worth knowing if you’re troubleshooting on macOS and wondering why the pane didn’t show up. On Mac, going directly to the AutoRecover folder was the more consistent approach.
#Common Causes of Excel Data Loss
Understanding why files disappear helps you avoid losing work twice.
Application crashes are the number one cause. Excel freezes during complex calculations or runs out of memory handling large datasets. According to Microsoft’s troubleshooting guide, files over 20MB with heavy macros are most at risk.
Accidental closure is next. You click “Don’t Save” out of habit.
Power outages can corrupt both the original file and AutoRecover copies simultaneously, which is why a basic UPS ($50-80) is worthwhile for anyone who does regular spreadsheet work on a desktop PC.
Sudden disconnections from removing a USB drive or losing network access while editing can make workbooks completely unreadable. If you do trend analysis in Excel, always copy shared files to your local drive before editing.
Working with protected workbooks? Learn how to unprotect an Excel workbook safely.
#Setting Up Excel to Prevent Future Data Loss
Two minutes of setup. Here’s the checklist.
Reduce AutoRecover interval. Go to File > Options > Save and change it from 10 minutes to 2 or 3.
Enable AutoSave with OneDrive. Save files to OneDrive if you have Microsoft 365. The toggle in Excel’s top-left corner saves every change in real time. Microsoft’s OneDrive documentation confirms that synced files also get ransomware detection and automatic recovery capabilities built into OneDrive’s infrastructure.
Turn on system-level backups. Enable File History on Windows or Time Machine on Mac. Both create hourly snapshots of your files automatically, giving you a reliable fallback that doesn’t depend on Excel’s own recovery features working correctly.
Use .xlsx format. Save as .xlsx instead of .xls.
Cloud services like Degoo add extra protection. For mobile backup strategies, see how to back up WhatsApp messages on Samsung.
#Bottom Line
Start with Recover Unsaved Workbooks (File > Info > Manage Workbook), which handles most situations in about 30 seconds. If it comes up empty, check the AutoRecover temp folder. For overwritten files, use Version History or File History. Set your AutoRecover interval to 2-3 minutes today.
#Frequently Asked Questions
#Can you recover an unsaved Excel file if AutoRecover was turned off?
Your options are limited but not zero. Check the UnsavedFiles folder manually (the path is in File > Options > Save). Third-party tools like Disk Drill or Recuva can scan for deleted temp files, though success depends on whether disk sectors have been overwritten.
#How long does Excel keep AutoRecover files?
Four days. After that, Excel deletes them automatically. Files you save and close normally don’t keep AutoRecover copies at all.
#Does AutoSave in Microsoft 365 replace AutoRecover?
No, they complement each other. AutoSave handles OneDrive and SharePoint files with real-time saving. AutoRecover protects locally saved files with periodic backup copies at intervals you control (default: 10 minutes). Use both for maximum protection.
#Can you recover an Excel file after restarting your computer?
Yes. AutoRecover files survive restarts because they’re written to disk, not held in RAM. Reopen Excel and the Document Recovery pane should appear with recoverable files. If it doesn’t, check the UnsavedFiles folder directly.
#What is the difference between AutoSave and AutoRecover in Excel?
AutoSave syncs your file to OneDrive or SharePoint in real time, requiring Microsoft 365 plus cloud storage. AutoRecover creates periodic local backup copies and works with any Excel version regardless of where files are saved. AutoRecover is the universal safety net; AutoSave is the premium real-time upgrade for cloud users.
#Why did the Document Recovery pane not appear after a crash?
Temp files were likely corrupted during the crash, or a cleanup tool removed them before Excel could read them. Open File > Options > Save, copy the AutoRecover file location, and browse that folder manually in File Explorer. Recoverable .xlsb files may still be there.
#Can you recover an unsaved Excel file on Mac?
Yes. Go to File > Open Recent in Excel first. You can also open the AutoRecover folder at ~/Library/Containers/com.microsoft.Excel/Data/Library/Application Support/Microsoft using Cmd + Shift + G in Finder. Time Machine snapshots work too.
#Is it possible to recover a file after clicking “Don’t Save” in Excel?
It depends on one setting. If “Keep the last autosaved version if I close without saving” was enabled (File > Options > Save), Excel kept a copy. Find it via File > Info > Manage Workbook > Recover Unsaved Workbooks. Without that setting, recovery requires third-party disk scanning tools.