File Corruption & Recovery

How to Recover an Unsaved Excel Workbook After Losing Changes

Nimra Malik Oct 7, 2026 869 views

Question details

The user needs to recover unsaved changes or a completely unsaved Excel workbook after an accidental closure, software crash, or failure to save.

How to Recover an Unsaved Excel Workbook

Product: Microsoft Excel
Device & OS: not provided
Scenario: Data in an Excel workbook was lost because the file was not properly saved before closing or a system interruption occurred.
Observed behavior: The recent changes made to the workbook are missing, and the user is seeking a way to retrieve the auto-saved temporary copy of the file.

Before you start

Before proceeding, ensure you do not restart your device or run any disk cleanup tools, as this might permanently erase the temporary AutoRecover files needed to restore your spreadsheet.

Solution 1Recommended

Use the Built-in Recover Unsaved Workbooks Feature

Excel includes a dedicated feature specifically designed to retrieve drafts of workbooks that were closed without saving.

Microsoft Excel automatically creates temporary backups of your files at regular intervals if the AutoRecover feature is enabled. Using the native recovery tool is the most reliable way to access these temporary files.

Open the File Menu

Launch Microsoft Excel and click on the 'File' tab located in the top-left corner of the application window.

Navigate to the Recovery Tool

Select 'Open' from the left-hand navigation pane, then scroll to the bottom of the 'Recent' workbooks list and click the 'Recover Unsaved Workbooks' button.

Select and Open the Draft

A File Explorer dialog will appear displaying available unsaved drafts. Select the missing file from the list and click 'Open'.

Save the Recovered File

Once the file opens in Excel, immediately click the 'Save As' button in the yellow banner at the top of the worksheet to save it permanently to your local drive.

Use the Built-in Recover Unsaved Workbooks Feature

Check AutoRecover Settings: To prevent future data loss, verify your AutoRecover interval by going to File > Options > Save, and ensure 'Save AutoRecover information every X minutes' is checked.

Solution 2

Manually Locate the AutoRecover Folder

If the built-in recovery menu does not display your file, you can manually navigate to Excel's default AutoRecover directory on your computer.

Free Microsoft Office alternative

Prevent Data Loss with WPS Office's Smart Auto-Backup

Tired of losing unsaved Excel workbooks? WPS Office is a highly compatible, free alternative to Microsoft Office that includes robust Auto-Backup and Cloud synchronization features, ensuring you never lose your hard work again.

1. Download and Install WPS Office: Visit the official WPS website to download the free installation package and follow the prompts to install the suite on your device.
2. Open Your Spreadsheets: Launch WPS Spreadsheet and easily open any existing Microsoft Excel files without worrying about formatting issues.
3. Enable Cloud Backup: Sign in to your WPS account and enable automatic cloud synchronization to secure your files instantly as you edit.

Smart local Auto-Backup continuously protects your data against unexpected crashes.Fully compatible with Microsoft Excel file formats including .xlsx, .xls, and .csv.Free, lightweight, and features a familiar user interface for a seamless migration.Built-in WPS Cloud automatically syncs your document progress across multiple devices.

microsoft office alternative - wps office

Frequently Asked Questions

Why is my unsaved Excel file not showing up in the Recover Unsaved Workbooks folder?

Your file may not appear if the AutoRecover feature was disabled in settings, the file was open for less time than the set AutoRecover interval (default is 10 minutes), or you manually cleared your system's temporary files.

Can I recover an Excel file that was overwritten and saved by mistake?

If you use cloud storage like OneDrive or SharePoint, you can right-click the file, select 'Version History', and restore a previous version. If the file was saved locally without Windows File History enabled, previous versions usually cannot be recovered.

How do I change the AutoRecover save interval in Microsoft Excel?

Navigate to File > Options > Save. Under the 'Save workbooks' section, adjust the 'Save AutoRecover information every X minutes' setting to a lower number to ensure backups happen more frequently.

Document & File Issues