How to Recover an Excel Worksheet Moved to Book1
Question details
The user needs to locate and recover a worksheet that was accidentally moved to a new workbook (Book1) and is now missing from the original file.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Moving or renaming a worksheet, accidentally selecting a 'New book' (Book1) as the destination, and then losing track of the new file before saving.
- Observed behavior
- The worksheet is no longer in the original workbook and cannot be found in the expected location.
Ensure you do not restart your computer or clear temporary system files before attempting recovery, as unsaved workbooks rely on cached application data.
Recover from Unsaved Workbooks
Use the built-in recovery tool to find temporary copies of workbooks (like Book1) that were closed or lost without saving.
When a worksheet is moved to a new workbook and the application is closed without saving, Excel often retains a temporary draft of that unsaved file in a hidden directory.
Launch Microsoft Excel and create a new blank workbook to access the main application interface.
Click on 'File' in the top-left corner of the ribbon, then select 'Info' from the left-hand menu panel.
Locate and click on the 'Manage Workbook' button to reveal a dropdown menu.
Select 'Recover Unsaved Workbooks'. A file explorer dialog will open showing recent unsaved files.
Look for a file named 'Book1' or check the files based on their date and time. Open the correct file and immediately click 'Save As' to secure your missing worksheet.
Check Currently Open Workbooks
Verify if the destination workbook is still open in a background window, which is common if the application hasn't been completely closed.
Use WPS Office to Safely Manage and Recover Spreadsheets
WPS Office provides robust file recovery features and an intuitive tabbed interface, making it easier to manage multiple worksheets without losing track of them. It is highly compatible with all major spreadsheet formats.
- 1. Open WPS Spreadsheet: Launch WPS Office and open your original workbook to begin working.
- 2. Move Worksheet Safely: Right-click the worksheet tab, select 'Move or Copy', and choose your destination workbook directly from the active tabs.
- 3. Access Auto-Backup: If a file is ever lost or closed accidentally, click 'Menu' > 'Backup and Recovery' > 'Auto Backup' to locate and restore your missing workbooks instantly.
Frequently Asked Questions
Why did my worksheet move to Book1 instead of copying?
When using the 'Move or Copy' feature, the 'Create a copy' checkbox is unchecked by default. If it remains unchecked and 'New book' is selected as the destination, the software completely removes the sheet from the original file and transfers it to a new temporary file named Book1.
Where are temporary files for unsaved workbooks stored?
By default, unsaved workbooks are temporarily stored in the 'UnsavedFiles' folder within your user AppData directory (usually C:\Users\[Username]\AppData\Local\Microsoft\Office\UnsavedFiles). You can access this directly via File > Info > Manage Workbook > Recover Unsaved Workbooks.
Can I recover a moved worksheet if I already restarted my PC?
It depends on your AutoRecover settings. If AutoRecover was enabled and triggered a save before you closed the application, you might still find the temporary file in the 'Recover Unsaved Workbooks' folder. However, restarting the PC clears many temporary caches, which reduces the chances of a successful recovery.
