Losing hours of work on an Excel file is one of those gut-punches that turns a productive Tuesday into a recovery mission. Maybe you saved over the version with the formulas that actually worked. Maybe a co-author overwrote your edits. Maybe Excel crashed and the file came back stripped of its last forty minutes of changes. Whatever the cause, the question is the same — and it's the question that brought you here.
The good news? Excel quietly keeps more backups than most people realize. Between OneDrive's version history, AutoRecover snapshots tucked away in AppData, Windows file history, Mac's Time Machine, and a couple of menus buried inside Excel itself, you usually have several lifelines before you need to call your IT team. The trick is knowing which one to pull first.
Before diving into specific menus and folder paths, take a breath. The wrong move right now — saving the file again, closing Excel, restarting your computer — can wipe out the very recovery options you're about to use. AutoRecover snapshots clear on the next normal save. Document Recovery panes disappear when dismissed. The first sixty seconds matter more than anything else, and the cheapest insurance is to leave the file alone until you know which method you're using.
This guide walks through every realistic recovery path — what to try when the file lives in OneDrive, what to do for a local .xlsx file that was saved over, how to dig out an unsaved workbook after a crash, and how to handle a corrupted file that won't open at all. We'll cover the prevention side too, because the best recovery is the one you don't need.
One thing to know up front: speed matters. Some recovery options age out quickly. Recycle bins purge after 30 days. AutoRecover files get cleaned up on the next normal save. If you've just lost data, finish reading this paragraph and then go check OneDrive's version history before you do anything else.
Cloud-stored Excel files keep a full version history automatically — no setup required. Open the file in Excel, click File → Info → Version History. A side panel lists every saved version with the date, time, and editor who made the change. Click a version to preview it in a read-only window, then hit Restore to make that version the current one.
You can also access version history from the browser. Right-click the file in OneDrive or SharePoint, choose Version history, and you'll see the same list with download options for each snapshot. Personal OneDrive plans keep up to 25 versions; business plans keep 500. AutoSave creates new versions every few minutes while you're editing, so the granularity is excellent.
If you accidentally saved over an important version and the file is stored locally, your best shot is Windows Previous Versions. Right-click the file in File Explorer, choose Properties, then click the Previous Versions tab. Windows lists any restore points or File History backups that contain a copy of the file.
One catch — this only works if you have System Restore enabled or File History configured. Many home Windows setups don't, so check before you assume it'll save you. If nothing appears in the tab, jump to the AutoRecover or temp file methods further down.
When Excel crashes mid-edit, reopening the app usually triggers the Document Recovery pane on the left side. You'll see a list of files with timestamps showing when each was last auto-saved. Click any entry to open it — you can then save the recovered version with a new name to compare it against the original.
If the pane doesn't appear, check File → Open → Recent, then scroll to the bottom and click Recover Unsaved Workbooks. That opens the hidden UnsavedFiles folder containing any workbooks Excel had auto-saved but you'd never named.
On macOS, Time Machine is your friend. With an external drive or network backup configured, open the folder where the Excel file lives, then launch Time Machine from the menu bar. Scroll back through the timeline on the right edge of the screen to a date before the file was overwritten. Select the older version and click Restore.
For OneDrive or SharePoint files on Mac, the version history process is identical to Windows — open the file in Excel, then File → Browse Version History. Mac Excel 365 also has Document Recovery, which kicks in automatically after a crash.
This is the single most reliable recovery path in modern Excel, and it's the first thing to try if your file lives in the cloud. OneDrive treats every save as a new version and retains them for weeks or months depending on your plan. Personal plans hold around 25 versions; business and enterprise plans hold up to 500.
From inside Excel, the route is File → Info → Version History. A panel slides out showing each snapshot with a timestamp and the name of whoever saved it. Click any version to open it in a separate read-only window. You can copy data out of that window, or click Restore at the top to overwrite the current file with the older version. The current state isn't lost — it becomes a new version in the list, so you can always flip back.
Working from the browser instead? Go to OneDrive.com or your SharePoint site, locate the file, right-click it, and choose Version history. Same list, same restore options, plus a download button so you can pull any version as a separate file without overwriting anything.
Excel autosaves changes to a recovery file every ten minutes by default — and every minute if you've tuned the setting (more on that below). When Excel crashes or your computer reboots unexpectedly, the next time you open Excel the Document Recovery pane appears on the left.
That pane lists recovered files with timestamps. Click each one to open it. Save the one with the most recent data under a new name first, so you don't accidentally overwrite the recovered version while comparing. After you've confirmed the data you need, you can close the pane and Excel will offer to delete the recovered files — say no until you're absolutely sure.
If the pane never appeared and you know Excel crashed, the recovered file might still be sitting in the AutoRecover folder. That's Method 3.
AutoRecover snapshots are stored as .asd files in a hidden location. On Windows, the default path is:
C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\
Type that path into File Explorer's address bar (substituting your username) and you'll see any pending AutoRecover files. Double-click an .asd file to open it in Excel, then save it as a normal .xlsx with a new name. Don't trust the file in place — Excel may clean it up on the next normal save.
To confirm or change the location on your machine, open Excel and go to File → Options → Save. The AutoRecover file location is listed there, and you can also see how often AutoRecover saves run (default 10 minutes, recommended 1 minute for important work).
Best for files saved to OneDrive or SharePoint. Up to 500 versions retained on business plans.
Appears automatically after Excel crashes. Lists every workbook Excel was tracking when the crash happened.
Hidden recovery snapshots stored in AppData. Useful when Document Recovery doesn't appear or you've already closed it.
Restores file from System Restore points or File History backups. Requires backup setup beforehand.
macOS built-in backup browser. Lets you scroll through historical states of any folder.
For files you never saved — the workbook closed without a name and you need it back.
This is the path you take when Excel closed before you ever saved the file. Maybe you closed without thinking, or maybe Excel crashed before the first save. In Excel, click File → Open → Recent. Scroll all the way to the bottom of the recent file list. You'll see a link labeled Recover Unsaved Workbooks.
Clicking it opens a hidden folder — usually C:\Users\[YourUsername]\AppData\Local\Microsoft\Office\UnsavedFiles\ on Windows — that contains every workbook Excel auto-saved but you never named. The files are .xlsb with auto-generated names like "Book1-(Unsaved-12345).xlsb". Double-click to open one, then save it as .xlsx with a real name before you do anything else.
If the file is stored locally and you saved over the version you actually needed, Windows might have a snapshot waiting. Right-click the file in File Explorer, choose Properties, and click the Previous Versions tab. Windows lists any restore points or File History backups containing that file.
The catch — this only helps if File History or System Restore was enabled before the bad save happened. If neither was on, the tab will be empty. It's worth checking your backup setup once, while you're not in a crisis, so this option is available when you need it. On a Windows 11 machine, search "File History" in the Start menu and turn it on with an external drive selected.
Mac users running Time Machine have it easier than Windows users without File History. Open Finder, navigate to the folder containing the Excel file, then launch Time Machine from the menu bar (or System Preferences if it's not visible). The screen flips to a stack of historical Finder windows. Use the timeline along the right edge to jump to a date before the file was overwritten.
Select the file and click Restore. Time Machine copies that version back to its original location, and you choose whether to overwrite the current file or save the older one alongside it.
Not every Excel file lives in OneDrive. If your workbook is in Dropbox, right-click it on Dropbox.com and choose Version history — Dropbox keeps 30 days of revisions on free accounts, and longer on paid ones. Google Drive (when storing native .xlsx files rather than converted Google Sheets) keeps 30 days of revisions too; right-click the file and choose Manage versions.
Each platform's restore process is essentially the same: pick the version, preview it, restore or download. Treat 30 days as a hard window — anything older is usually gone unless you have a separate backup layer.
Excel scatters temporary files across the system while a workbook is open. On Windows you'll find them in C:\Users\[user]\AppData\Local\Microsoft\Office\UnsavedFiles\, plus the AutoRecover folder mentioned earlier. These temp files use prefixes like "~" or random hex strings and usually have .tmp or .xlsb extensions.
Renaming a temp file to .xlsx and opening it in Excel sometimes works — but not always. Treat this as a last-resort before you move on to third-party recovery tools.
Sometimes the file still exists but Excel refuses to open it. The first thing to try is Excel's built-in Open and Repair. Go to File → Open, navigate to the broken file, click the arrow next to the Open button, and choose Open and Repair. Excel offers two paths — Repair attempts to recover the workbook as much as possible, while Extract Data pulls out values and formulas even if the workbook structure is too damaged to load.
If Open and Repair fails, third-party tools take over. Stellar Repair for Excel, DataNumen Excel Repair, and Recoverit handle deeper corruption — they parse the file at the byte level and reconstruct what they can. EaseUS Data Recovery is the right pick if the file was deleted, not just corrupted, and you need to scan the drive for remnants.
None of these guarantee a complete recovery. Test with the trial versions before you pay — most show a preview of what they can extract, so you'll know if it's worth the license fee. And always work on a copy of the corrupted file. Repair tools sometimes write back to disk, and you don't want to lose your only copy of the broken file.
Even after exhausting every recovery method, there are still a few angles worth trying. Check your email — recent versions of the file might be attached to a thread you sent or received. Ask collaborators for their most recent copy if the file was shared. If the workbook was on a corporate network drive, IT may have nightly backups going back 14 to 90 days.
For files stored in cloud services, don't forget the recycle bin. OneDrive holds deleted files for 30 days (and longer on business plans). SharePoint's site collection recycle bin adds another 93 days on top of that, so files thought lost may still be retrievable by an admin.
Enterprise environments often have backup software like Veeam, Acronis, Carbonite, or Backblaze running in the background. Even if you don't think backups exist, ask your IT team — many organizations have backups configured by policy that individual users don't know about.
The cleanest recovery is the one you don't need. A few small habits eliminate most of the scenarios that bring people to articles like this one. Start with Excel's own settings — File → Options → Save — and change the AutoRecover interval from 10 minutes to 1 minute. The performance cost is invisible on modern machines, and the difference in recoverable data after a crash is enormous.
Turn on AutoSave for any workbook that lives in OneDrive or SharePoint. The toggle sits in the top-left corner of Excel next to the file name. With AutoSave on, every change writes to the cloud immediately and creates a new version history entry. Combine that with version history and you have a continuous, automatic backup that goes back hundreds of revisions.
Build a Ctrl+S habit for local files too. It sounds trivial, but a save every few minutes turns most crashes from disasters into minor inconveniences. For genuinely important workbooks — financial models, client deliverables, research data — consider version control. Putting .xlsx files into a Git repository or a folder synced with versioned cloud storage gives you commit-level history that survives anything short of total drive failure.
One more thing — back up the backups. If you rely on OneDrive, periodically copy critical workbooks to a second location: an external drive, a different cloud provider, or your own NAS. Cloud sync mirrors deletions, so a ransomware attack or accidental folder deletion can wipe both copies if they're synced. A second, non-synced layer breaks that chain.
Toggle AutoSave on for every cloud-stored workbook. New changes write to OneDrive instantly and trigger version history entries.
File → Options → Save → change interval from 10 to 1 minute. Tiny performance cost, huge recovery upside.
Note the AppData path under Options → Save. You'll want to find it quickly if a crash happens.
Settings → Update & Security → Backup. Pick an external drive. Windows keeps incremental snapshots of selected folders automatically.
System Preferences → Time Machine → select an external drive. Time Machine runs hourly backups in the background once enabled.
For critical workbooks, copy weekly to a second location — external drive, alternate cloud, or version control. Breaks the sync-mirrors-deletion problem.
Shared workbooks add a wrinkle. When multiple people edit a OneDrive file at once, AutoSave writes changes from everyone in near real time. That's great — until a collaborator overwrites your work and you have no idea when it happened. Version history still saves you, but the timestamps belong to whoever saved last, not to the change that broke your data.
Trick: open File → Info → Version History and click through versions in reverse order. Don't restore right away — open each version in its read-only window and compare against the current state. Once you find the version with the data you need, copy the affected cells, then return to the live file and paste them back. That preserves everyone else's recent edits while restoring just what you lost.
For SharePoint-stored workbooks, the same approach works, with one bonus — SharePoint logs who made which change. Hover over a version in the panel and you'll see the editor's name. Useful for sorting out which colleague to ask about a missing range.
Recovery in Excel comes down to checking the right place first. For cloud-stored files, version history is almost always the answer. For local files after a crash, the Document Recovery pane and AutoRecover folder cover most cases. For files saved over and lost to a local-only setup, Windows Previous Versions or Time Machine — assuming backups were configured before the incident.
The bigger win is in prevention. AutoSave to OneDrive, AutoRecover set to 1 minute, File History or Time Machine running in the background. With those three layers active, the next time you accidentally save over something important, the recovery is one menu click instead of a frantic search through hidden folders. Build the habits now, while nothing is broken, and the next crisis turns into a thirty-second non-event.
One last reminder — when something does go wrong, work fast. AutoRecover snapshots clear on the next normal save. Recycle bins age out at 30 days. The longer you wait, the fewer options remain. Bookmark this page so the recovery steps are one click away when you need them, and you'll get the file back nine times out of ten.