How to Find Unsaved Excel Files: Recovery Methods That Actually Work

Losing work in Excel before saving is one of those gut-punch moments that happens to almost everyone. Whether Excel crashed, your laptop died, or you accidentally clicked "Don't Save," the file isn't necessarily gone. Excel has several built-in recovery systems working quietly in the background — but which one helps you depends on how your version is configured and what happened before the file disappeared.

Why Unsaved Excel Files Can Be Recovered at All

Excel doesn't just save when you tell it to. Microsoft Office includes a feature called AutoRecover, which automatically saves a temporary snapshot of your work at set intervals — typically every 10 minutes by default. These snapshots are stored in a hidden system folder, not in your regular documents location.

There's also a separate feature called AutoSave, available in Microsoft 365 subscriptions, which continuously saves your file to OneDrive or SharePoint in near real-time. These are two distinct systems, and understanding which one applies to your setup matters a lot.

Method 1: Check the Document Recovery Pane 💾

If Excel crashes or closes unexpectedly, the next time you open it you'll usually see a Document Recovery pane on the left side of the screen. This pane lists any files that were open at the time of the crash, along with a timestamp.

Click on the recovered file to open it, then immediately Save As to a permanent location. Don't close this pane without saving — the temporary files it references aren't permanent and will be deleted after a period of time or when you dismiss the panel.

This method works on both Windows and Mac, though the behavior can differ slightly between Office versions.

Method 2: Browse AutoRecover Files Manually

If the Document Recovery pane doesn't appear — or you closed it before saving — you can look for the temporary files directly.

On Windows:

1. Open Excel and go to File → Info → Manage Workbook
2. Click "Recover Unsaved Workbooks"
3. A file explorer window opens pointing to the AutoRecover folder, typically located at: C:Users[YourName]AppDataRoamingMicrosoftExcel

Alternatively, navigate to that folder directly in File Explorer. Files here will have a .xlsb or .xlsx extension and names that don't match your original filename — they're often long strings of numbers and letters.

On Mac: The AutoRecover folder is located in: /Users/[YourName]/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery/

The Library folder is hidden by default on macOS. You can reach it by opening Finder, clicking Go in the menu bar, then holding the Option key — the Library option will appear.

Method 3: Search for Temporary Files

Excel sometimes creates temp files (.tmp) in your system's temp folder. These aren't always recoverable in a usable format, but they're worth checking.

On Windows, type %temp% into the Run dialog or File Explorer address bar to open the temp folder. Look for recently modified files, particularly anything with "Excel" or "~$" in the name. The ~$ prefix is Excel's lock file convention and may point you toward related temp data.

These files are inconsistent — sometimes readable, sometimes not — but it's a low-effort step when other methods come up empty.

Method 4: Check OneDrive or AutoSave History 🔄

If you use Microsoft 365 and the file was stored in OneDrive or SharePoint, AutoSave may have been active. This is different from AutoRecover — AutoSave pushes changes to the cloud continuously, so even "unsaved" work may exist as a version in the cloud.

To check:

• Open OneDrive in a browser
• Navigate to the folder where the file was located
• Right-click the file and choose Version History

You'll see a list of saved versions with timestamps. You can preview and restore any of them.

If the file was never saved at all (brand new, never given a name or location), AutoSave won't have captured it — it only works on files that have been assigned a OneDrive or SharePoint location.

The Variables That Determine Whether Recovery Works

Adjusting AutoRecover Settings to Protect Future Work

If recovery fails this time, it's worth reviewing your settings before it happens again. In Excel, go to File → Options → Save (Windows) or Excel → Preferences → Save (Mac). From there you can:

• Reduce the AutoRecover interval (5 minutes is a common choice)
• Confirm the AutoRecover file location path
• Enable "Keep the last AutoSaved version if I close without saving"

That last setting is particularly useful — it tells Excel to hold onto the most recent AutoRecover snapshot even when you manually choose not to save.

When the File Is Likely Gone for Good

If the file was open only briefly, AutoRecover hadn't yet run, it was never saved to a named location, and the temp folder has since been cleared — the data is almost certainly unrecoverable through standard means. Third-party file recovery tools exist, but they work at the storage level and are better suited to files that were saved and then deleted, not documents that were never written to disk.

How much of your file is recoverable — or whether recovery is possible at all — comes down to your specific Office version, whether OneDrive was in the picture, your AutoRecover interval, and exactly what happened when the file was lost. Those details vary enough between setups that the same steps can produce very different results for different users.