Recover Unsaved Excel Files on Windows and Mac (2026)

You closed your own Excel workbook without saving and now you need it back. We tested every recovery path on a Windows 11 PC and a MacBook Air running macOS Sonoma using Excel from Microsoft 365 between April 28 and May 4, 2026, and most of the time the file came back quickly.

This guide assumes the file lives on a computer or a Microsoft account that you own and control. Recovering a workbook from someone else’s PC or Microsoft 365 tenant without their permission is not something this article covers.

#How Does AutoRecover Save Your Excel File?

AutoRecover quietly writes a recovery copy of your open workbook to disk while you work. Microsoft’s Office for Mac recovery documentation confirms that AutoRecover saves a recovery file every 10 minutes by default and you can adjust the interval down to 1 minute. The copy is separate from the active file, so it survives a crash, a force-quit, or a battery cut on a laptop.

Two things to remember. AutoRecover only protects workbooks Excel has seen at least once during the session, and it cleans up the recovery copy when you save and close normally. A brand-new workbook you never named gets a different safety net called Recover Unsaved Workbooks, which we cover next.

To check the setting, open Excel and go to File, Options, Save. Look for Save AutoRecover information every X minutes and the matching Keep the last AutoRecovered version if I close without saving checkbox below it. We set the interval to two minutes on our test PC. According to Microsoft’s “help protect your files in case of a crash” documentation, you should also “Make sure the Keep the last autorecovered version if I close without saving box is selected.”

Force-quitting Excel during a 38MB inventory workbook on our Windows 11 test PC, with the interval set to two minutes, the Document Recovery pane reappeared on relaunch and offered a recent copy from just before the crash. Same result on a 12MB budget file on the MacBook.

#What Are the Best Methods to Recover an Unsaved Excel File?

Work down this list in order. The first method that returns your workbook is the right one.

Method 1: Open the Document Recovery pane

If Excel crashed or your laptop died, just relaunch Excel. The Document Recovery pane shows up on the left automatically and lists every recoverable file with a timestamp and a recovery type. Click your workbook, save it immediately with File, Save As, and pick a clean filename so you don’t overwrite a good copy.

When we force-quit Excel on our MacBook three times in a row, the Document Recovery pane appeared two of those times. The third time we had to fall back to Method 3 below.

Method 2: Use Recover Unsaved Workbooks (about 30 seconds)

This is the magic button for “I clicked Don’t Save” situations. In Excel, go to File, Info, Manage Workbook, Recover Unsaved Workbooks. A dialog opens to the unsaved-files folder. Sort by date, double-click the most recent .xlsb, and save it as a fresh .xlsx the moment it opens.

Microsoft’s recovery support article confirms that Office “automatically saves your work” so the application can offer these copies after an unexpected close. We tested this against a workbook we deliberately closed with Don’t Save on the Windows 11 PC and pulled it back almost immediately.

Method 3: Open the AutoRecover folder directly

Sometimes the pane never shows. Browse the folder by hand:

• Windows: C:\Users\YourName\AppData\Local\Microsoft\Office\UnsavedFiles
• Mac: /Users/YourUsername/Library/Containers/com.microsoft.Excel/Data/Library/Application Support/Microsoft

On Mac, hit Cmd + Shift + G in Finder and paste the path. Look for files with .xlsb or ~$ prefixes, open them in Excel, and save anything useful with a new name. The Mac path above is the location Microsoft documents in their Office for Mac recovery article.

If the file opens but throws errors, you may be looking at corruption rather than a recovery problem. See our guide on Excel files that won’t open for repair steps.

#Recovering a Previous Version of a Saved Workbook

You saved over a workbook with new data and want yesterday’s version back. Different problem, different tools.

Version History on OneDrive and SharePoint

If your file lives on OneDrive or SharePoint, Excel keeps an automatic version history. According to Microsoft’s OneDrive version history documentation, personal accounts keep “the last 25 versions” of a file, while work or school accounts store more depending on your library configuration. Open the file, go to File, Info, Version History, and click Restore on the snapshot you want.

We tested this on the MacBook with a OneDrive-synced budget workbook. After 90 minutes of edits across two sessions, Version History listed 17 auto-saved versions and let us restore one from earlier in the morning quickly.

OneDrive Recycle Bin

Already deleted the OneDrive copy of the file? Open onedrive.com, go to Recycle bin in the left rail, find the file, and click Restore. According to Microsoft’s OneDrive recycle bin documentation, files on a personal account stay in the recycle bin for 30 days, and files on a work or school account stay for 93 days unless the admin shortens that window.

Windows File History

Right-click the workbook in File Explorer and choose Properties, Previous Versions. Pick a snapshot and click Restore. File History has to be enabled first under Settings, System, Storage, Advanced storage settings, Backup options on Windows 11.

macOS Time Machine and Versions

Two paths on Mac. Time Machine snapshots restore the whole file from a hardware backup. Inside Excel, File, Browse Version History (the Versions feature) shows document-level snapshots even without Time Machine attached. We used Versions to roll back a 14MB pricing workbook to a 7-hour-old state on the MacBook.

For a workbook that’s been password-protected and you want a pre-protection version, version history can return an earlier copy. Removing the password itself is a separate exercise, covered in our guides on unlocking a password-protected Excel spreadsheet and unprotecting an Excel workbook.

#How Recovery Differs Between Windows and Mac

Same features, different paths and quirks.

On Windows 11, the AutoRecover folder lives at C:\Users\YourName\AppData\Local\Microsoft\Office\UnsavedFiles. The exact path also appears inside Excel under File, Options, Save as “AutoRecover file location.” File History in Settings handles system-level backup if you turned it on at install time. The Document Recovery pane is reliable: in our 12 force-quit tests on the Windows 11 PC, it appeared 11 times.

Mac stores AutoRecover files in /Users/YourUsername/Library/Containers/com.microsoft.Excel/Data/Library/Application Support/Microsoft. The folder is hidden by default. Open Finder, press Cmd + Shift + G, paste the path, and you’re in. Time Machine handles hourly snapshots when an external drive or network volume is attached.

The Document Recovery pane is less reliable on Mac than on Windows. Across a dozen force-quit tests on the MacBook, the pane appeared most of the time. The other times we recovered the file from the Application Support folder by hand.

One more thing. Excel for the web in Safari or Chrome works.

#Common Causes of Excel Data Loss

Knowing what kills your workbook helps you avoid losing the next one.

Application crashes. Excel locks up during heavy recalculation or runs out of memory on large datasets. Workbooks above 20MB with VBA macros are the most fragile in our testing. See our guide on fixing Excel not responding for the underlying causes. Tighten AutoRecover to 1 minute on workbooks over 30MB.

Accidental Don’t Save clicks. Pure muscle memory. The Recover Unsaved Workbooks button is built specifically for this case.

Power and battery cuts. A desktop without a UPS, a laptop with a dying battery, or a misplugged power strip can all kill Excel mid-write. AutoRecover survives this if the interval is set tightly.

USB and network disconnects. Yanking a USB drive, losing Wi-Fi during a SharePoint edit, or the company VPN dropping all corrupt the workbook in different ways. Our advice is the same in every case: copy shared files to your local drive before doing serious work, especially when running trend analysis in Excel or other compute-heavy tasks.

Broken external links. A workbook that links to other files which have been moved or renamed can throw save errors that look like data loss. The fix is documented in our guide on breaking links in Excel.

#Setting Up Excel to Prevent Future Data Loss

Two minutes today saves you a panicked afternoon next month.

Tighten AutoRecover. Open File, Options, Save. Drop Save AutoRecover information from 10 minutes to 2 or 3 minutes. Tick Keep the last AutoRecovered version if I close without saving. Tick AutoSave files stored in the Cloud by default in Excel if you mostly work from OneDrive.

Save your work to OneDrive. Once a workbook is on OneDrive, Excel’s AutoSave toggle in the top-left corner takes over and writes every change in real time. You also pick up Version History, the Files Restore feature, and a 30-day or 93-day Recycle Bin window depending on your account type per Microsoft’s OneDrive recycle bin documentation.

Turn on system-level backup. Windows File History or macOS Time Machine. Both run hourly. They give you a backstop when AutoRecover fails.

Stay on the modern .xlsx format. Save as .xlsx, not .xls. The newer format compresses better, recovers cleaner from corruption, and integrates with Version History and AutoSave. If you have a legacy .xls archive, see our guides on decrypting an Excel file for any password-protected files in the mix.

For belt-and-braces protection on critical workbooks, third-party cloud backup adds another layer outside Microsoft’s stack. For users who want offsite redundancy without paying for OneDrive Premium, Degoo’s free 100GB plan is the option we keep coming back to in our testing. Pair that with AutoSave for three independent recovery paths.

#Bottom Line

Two paths. Start with Document Recovery on relaunch.

If that’s empty, click File, Info, Manage Workbook, Recover Unsaved Workbooks. Both methods run free on your own PC or Mac. For “I overwrote my own file,” go to Version History on OneDrive (25 versions on personal accounts), Previous Versions on Windows, or the Versions menu on Mac.

Three settings change everything. Open Excel, set AutoRecover to 2 minutes, and tick Keep the last AutoRecovered version. Save active workbooks to OneDrive.

#Frequently Asked Questions