File Corruption & Recovery

How to Recover a Missing Excel Worksheet After Choosing Do Not Save

Rana GarciaRana Garcia Oct 22, 2026 871 views

Question details

The user needs to recover a newly added Excel worksheet or recent edits that were lost after closing the workbook and accidentally clicking the "Do Not Save" option.

How to Recover a Missing Excel Worksheet After Choosing "Do Not Save"
Product
Excel
Device & OS
not provided
Scenario
The user finishes working on an Excel spreadsheet, closes the application, and mistakenly selects "Do Not Save" when prompted, leading to the loss of a newly inserted worksheet and recent data entries.
Observed behavior
When the user reopens the workbook, the newly added worksheet and any recent changes are missing because the file changes were deliberately discarded during the closing prompt.
Before you start

Ensure you have not restarted your computer or run any temporary file cleaner utilities, as these actions might permanently delete the temporary AutoRecover files needed for restoration.

Solution 1Recommended

Recover via Manage Workbook in Excel

Use Excel's built-in unsaved file recovery tool to find and restore recent drafts that were closed without saving.

Microsoft Excel has a safety feature designed to hold onto unsaved files for a short period. If Excel was open long enough to trigger an automatic background save, you can retrieve your missing worksheet directly through the application's Info menu.

1
Open Microsoft Excel

Launch Microsoft Excel and open a blank workbook or the original file you were working on.

2
Navigate to the Info tab

Click on the "File" menu in the top-left corner, then select "Info" from the left-hand navigation pane.

3
Access Manage Workbook

Click the "Manage Workbook" button (it may be labeled "Manage Versions" in older versions).

4
Recover Unsaved Workbooks

Select "Recover Unsaved Workbooks" from the dropdown list. This will open a File Explorer window showing your UnsavedFiles folder.

5
Restore your file

Locate the missing draft, select it, and click "Open". Once the draft opens in Excel, immediately click "Save As" in the yellow warning bar at the top to securely save it.

Recover via Manage Workbook in Excel
Quick Action: Always perform this recovery as soon as possible, as the UnsavedFiles folder is temporary and clears out over time or after a computer reboot.
Free Microsoft Office alternative

Prevent Unsaved File Loss with WPS Office's Smart Backup

Tired of losing your Excel data when you accidentally click "Do Not Save"? Switch to WPS Office. It provides an intelligent Auto-Backup center that systematically saves multiple local versions of your spreadsheets, making recovery seamless and frustration-free.

  1. 1. Download WPS Office: Install WPS Office for free from the official website to replace Microsoft Excel.
  2. 2. Open your files: Open your existing .xlsx workbooks seamlessly without worrying about compatibility or formatting issues.
  3. 3. Enable Smart Backup: Navigate to Menu > Settings > Backup Center to configure automatic local backups, ensuring your data is always safe.
Built-in Auto-Backup Center ensures you never lose a worksheet, even if you close without saving.Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Free, lightweight, and loads massive spreadsheets in seconds.Familiar tabbed interface allows seamless migration with zero learning curve.
microsoft office alternative - wps office

Frequently Asked Questions

How often does Excel save AutoRecover information?

By default, Excel saves AutoRecover information every 10 minutes. You can adjust this frequency to suit your needs by going to File > Options > Save and modifying the "Save AutoRecover information every X minutes" setting.

Why is my Recover Unsaved Workbooks folder empty?

If the folder is empty, Excel may not have been open long enough to trigger an AutoRecover save (default is 10 minutes). Additionally, temporary unsaved files might have been cleared by a system cleanup utility or a computer restart.

Are AutoRecover files kept permanently?

No, AutoRecover files are strictly temporary. Excel typically deletes these background drafts once you normally save and close the file, or after a few days if left as unsaved drafts. Always save a recovered file immediately using the Save As option.

Can I recover a permanently deleted Excel file using AutoRecover?

No, AutoRecover is exclusively designed to recover unsaved changes or files closed without saving (such as during a system crash or power outage). To recover a file that was permanently deleted from your drive, you must check your Windows Recycle Bin or use specialized data recovery software.