How to Recover an Excel File: What Actually Works and Why
Losing an Excel file — whether through an accidental delete, a crash, or a save gone wrong — is one of those moments that ranges from mildly annoying to genuinely catastrophic. The good news is that Excel and Windows (and macOS) have several overlapping recovery layers built in. The less-good news is that which ones apply to you depends heavily on how your setup is configured.
Here's a clear breakdown of how Excel file recovery actually works.
How Excel Protects Your Work in the Background
Modern versions of Excel (Microsoft 365, Excel 2019, Excel 2021) run an AutoRecover process that periodically saves a temporary version of your open file. This is different from your actual save — it's a background snapshot Excel creates in case of a crash.
Key things to know about AutoRecover:
- It runs on a timer — default is every 10 minutes, but this is user-configurable
- It only kicks in while a file is open and unsaved changes exist
- If Excel closes normally (you clicked Save and exited cleanly), the AutoRecover file is typically deleted automatically
- AutoRecover files are stored in a specific temp folder on your system — not in the same place as your actual file
To find AutoRecover files manually, look in:
- Windows:
C:Users[YourName]AppDataRoamingMicrosoftExcel - Mac:
~/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery/
These paths can vary slightly depending on your Office version and OS.
Recovering a File After a Crash
If Excel crashed or your computer shut down unexpectedly, Excel usually shows a Document Recovery pane the next time you open it. This lists auto-saved versions of any files that were open at the time.
If that pane doesn't appear — or you dismiss it — you can still hunt for AutoRecover files manually using the paths above, or through:
File → Info → Manage Workbook → Recover Unsaved Workbooks
This opens Excel's internal temp folder and shows .xlsb or .xlsx draft files that haven't been formally saved. These files are temporary and will eventually be cleared out, so time matters here.
When You've Saved Over a File (Version History) 💾
This is where things diverge significantly based on your setup.
If your file is stored on OneDrive or SharePoint, Excel keeps a version history automatically. You can:
- Right-click the file in OneDrive
- Select Version History
- Browse earlier versions by date and time
- Restore or download a previous version
This is one of the most reliable recovery options available — and it works even when you've saved over the file intentionally, then changed your mind.
If your file is stored locally (on your hard drive, not a cloud folder), version history depends on whether Windows File History or Previous Versions (via shadow copies) is enabled. These are OS-level backup features that aren't on by default on all systems. If they were enabled before the file was lost, you can:
- Right-click the folder where the file was stored
- Select Properties → Previous Versions
- Browse available snapshots
If those features weren't set up ahead of time, this option won't be available.
Recovering a Completely Deleted Excel File
If the file was deleted entirely and isn't in the Recycle Bin, your options depend on:
| Scenario | Recovery Likelihood |
|---|---|
| File deleted recently, Recycle Bin not emptied | High — restore directly |
| File deleted, Recycle Bin emptied, no backup | Low to moderate |
| File on OneDrive, deleted within 30 days | High — check OneDrive Recycle Bin |
| File on SharePoint | High — admin-recoverable up to 93 days |
| Local file, no cloud backup, drive not heavily used since | Moderate — file data may still exist on disk |
For locally deleted files where no backup exists, third-party file recovery tools scan your drive for file data that hasn't yet been overwritten. These tools vary widely in effectiveness and are more likely to succeed on traditional hard drives (HDDs) than on SSDs, where data is typically wiped more aggressively due to TRIM functionality.
The Variables That Change Everything
Recovery success isn't universal — it hinges on several factors:
- Where the file was stored: Cloud storage (OneDrive, SharePoint, Google Drive with Sheets conversion) offers far more recovery options than local-only storage
- AutoRecover settings: If the interval was set long or the feature was disabled, recovery windows shrink
- Time elapsed: The longer you wait after a loss, the more likely temp files are purged or disk sectors are overwritten
- Storage type: SSDs and HDDs behave differently when it comes to deleted data recovery
- Office version: Older versions of Excel have fewer built-in recovery tools
- OS backup configuration: File History, Time Machine (Mac), and shadow copies need to be enabled before a problem occurs — not after
What the Mac Experience Looks Like 🍎
On macOS, AutoRecover works similarly to Windows, but the file paths differ and Time Machine plays the role that Windows File History plays on PC. If Time Machine backups are running and up to date, recovering a previous version of a file is straightforward through the Time Machine interface.
Mac users on Microsoft 365 with OneDrive have access to the same version history features as Windows users.
The Honest Reality of Recovery
Some recovery scenarios are near-certain. Others — particularly unbackedup, locally-stored files that were lost on an SSD with no AutoRecover data — are genuinely difficult, sometimes impossible without professional data recovery services.
The difference between "I got it back in two minutes" and "it's gone" often comes down to decisions made before the file was lost: whether cloud sync was enabled, whether AutoRecover was configured, whether OS-level backups were running. Your specific combination of those settings is what determines which recovery path is actually open to you.