How to Recover a Lost Excel File: A Practical Guide

Losing an Excel file can be stressful, but your workbook is often recoverable. This guide explains step-by-step recovery methods for Excel on Windows and highlights preventive settings. The primary keyword for this article is “recover lost Excel file,” which appears in the opening paragraph to match search intent and help readers find practical recovery steps fast.

Who this guide is for

• Office users who lost unsaved or corrupted Excel workbooks
• IT support staff assisting colleagues with data recovery
• Anyone who wants to prevent future data loss in Excel

What to expect

This article covers the fastest recovery options first, then digs deeper into manual file-hunting techniques. Follow the steps in order for the best chance of restoring your spreadsheet.

Quick checklist (at a glance)

• Open Document Recovery pane after a crash.
• Use Recover Unsaved Workbooks for files closed without saving.
• Check the AutoRecover folder on your PC.
• Use OneDrive or SharePoint Version History for cloud-saved files.
• Try Windows Previous Versions (File History).
• Search Windows Temp folder as a last resort.
• Adjust AutoRecover settings to reduce future risk.

Check the Document Recovery pane

Your first defense after an Excel crash

When Excel or Windows crashes, Excel often shows a Document Recovery pane the next time you open the app. This pane lists recovered versions with timestamps.

Steps:

1. Open a blank workbook immediately after the crash.
2. In the Document Recovery pane (left), open the file with the most recent timestamp.
3. Save recovered content via File > Save As.

Tip: If you see a recovery file dated 01/01/1601, don’t ignore it—this Windows metadata glitch can still contain your most recent changes.

Use “Recover Unsaved Workbooks”

For files you closed and told Excel not to save

If you clicked “Don’t Save” on a local workbook, Excel may still hold a cached copy.

Steps:

1. Open Excel and go to File > Info.
2. Click Manage Workbook and choose Recover Unsaved Workbooks.
3. Sort the open folder by Date Modified and open the newest file.
4. Save it immediately with File > Save As.

Note: Files in this folder might appear as .xlsb; open and convert them as needed.

Search the AutoRecover folder

When the Document Recovery pane doesn’t appear

Excel stores AutoRecover drafts locally. You can manually open that folder to find unsaved versions.

Steps:

1. Press Windows Key + R to open Run.
2. Enter %AppData%MicrosoftExcel and press Enter, or check File > Options > Save > AutoRecover file location in Excel.
3. Sort by Date Modified and open recent files.
4. Save the correct file via File > Save As.

If a file won’t open, try changing its extension to .xlsb or .xlsx; Windows will warn you, but confirming often lets Excel read the file again.

Restore previous versions via OneDrive or SharePoint

Use cloud version history as a time machine

If you saved to OneDrive or SharePoint and AutoSave was on (or you manually saved), version history can restore earlier states or deleted sheets.

Steps:

1. Open the workbook in the Excel desktop app (or Excel for the web if desktop fails).
2. Click the file name in the title bar and choose Version History, or go to File > Info > Version History.
3. Preview timestamps, then click Restore or Save a Copy to preserve both versions.

Tip: If a file is corrupted on your PC, Excel for the web often opens it well enough to access version history.

Use Windows’ Previous Versions / File History

Recover overwritten or deleted local files

If File History or System Restore/Shadow Copies is enabled, you can restore older versions of a folder or file.

Steps:

1. Right-click the Excel file (or the folder where it lived) in File Explorer and choose Properties.
2. Open the Previous Versions tab and select a version from the desired date. Click Open.
3. Copy the file from that historic view and paste it into a safe folder to avoid overwriting current files.

This approach is safer when you want to keep both the current and older copies.

Search the Windows Temp folder

A last-resort method for fragmented data

Temporary files can occasionally hold fragments of a lost workbook. This is less reliable but worth trying if other methods fail.

Steps:

1. Press Windows Key + R, type %temp%, and press Enter.
2. In File Explorer, search for .tmp or files beginning with ~$.
3. Sort by Date Modified to find files from when you were working.
4. Right-click a likely file, Open With > Excel. If you see usable data, copy it into a new workbook and save immediately.

Note: Temp files disappear quickly and may be incomplete.

Preventive measures and recommended settings

Make future recovery easier by adjusting Excel and storage habits.

• AutoRecover interval: Go to File > Options > Save and set AutoRecover to 2 minutes (or another short interval).
• Keep AutoRecovered versions: Ensure “Keep the last AutoRecovered version if I close without saving” is checked.
• Use OneDrive or SharePoint rather than local desktop saves when possible. Cloud storage with Version History offers the most reliable recovery.
• Save often and press Ctrl+S when making big changes.
• Consider regular backups or enabling Windows File History.

Alt text: Laptop with Microsoft 365 app icons representing cloud saving and recovery options
Title text: Illustration showing cloud-backed Office apps and recovery features

Example scenario: Recovering after a sudden crash

Imagine you were working on a local budget workbook when Windows unexpectedly restarted.

1. Reopen Excel right away. If the Document Recovery pane appears, open the most recent timestamp and save.
2. If nothing appears, try File > Info > Manage Workbook > Recover Unsaved Workbooks.
3. If still unsuccessful, check %AppData%MicrosoftExcel and the %temp% folder for recent files.
4. If you usually save to OneDrive, open Excel for the web and use Version History to restore a prior version.

Following these steps in order gives you the highest chance of full recovery.

Internal links

• How to AutoSave Microsoft Excel files to OneDrive
• AutoSave troubleshooting for Microsoft 365
• Change file types and extensions in Windows

Conclusion

Recovering a lost Excel file is usually possible if you act quickly and methodically. Start with Excel’s Document Recovery pane, move to Recover Unsaved Workbooks and AutoRecover folders, then use cloud version history or Windows Previous Versions. As a final resort, scan the Temp folder. To avoid future panic, shorten AutoRecover intervals, enable versioned cloud storage like OneDrive, and save frequently.

If you want, I can create a printable one-page checklist of these recovery steps or tailor guidance for Excel on macOS — which would you prefer?