How to Recover a Missing Excel Worksheet After Choosing Do Not Save
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.

- 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.
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.
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.
Launch Microsoft Excel and open a blank workbook or the original file you were working on.
Click on the "File" menu in the top-left corner, then select "Info" from the left-hand navigation pane.
Click the "Manage Workbook" button (it may be labeled "Manage Versions" in older versions).
Select "Recover Unsaved Workbooks" from the dropdown list. This will open a File Explorer window showing your UnsavedFiles folder.
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.

Locate the AutoRecover Folder in File Explorer
Manually browse your computer's hidden system folders to find the temporary AutoRecover backups Excel creates.
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. Download WPS Office: Install WPS Office for free from the official website to replace Microsoft Excel.
- 2. Open your files: Open your existing .xlsx workbooks seamlessly without worrying about compatibility or formatting issues.
- 3. Enable Smart Backup: Navigate to Menu > Settings > Backup Center to configure automatic local backups, ensuring your data is always safe.

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.




