Deleted File Recovery

How to Recover a Deleted Excel Worksheet After Saving

Rana GarciaRana Garcia Nov 10, 2026 870 views

Question details

The user needs to know how to retrieve a specific worksheet tab that was deleted before the Excel workbook was subsequently saved.

How to Recover a Deleted Excel Worksheet After Saving
Product
Excel
Device & OS
not provided
Scenario
A user accidentally deletes a worksheet within an Excel file and then saves the file, overwriting the document and removing the ability to simply undo the action.
Observed behavior
The deleted worksheet is missing from the current saved file, and Excel cannot restore the sheet from the current file alone since the undo history has been cleared.
Before you start

Stop making further edits to the current workbook immediately to avoid overwriting any remaining temporary files or background AutoRecover backups.

Solution 1Recommended

Restore from OneDrive or SharePoint Version History

If your Excel file is saved and synced via OneDrive or SharePoint, you can easily restore a previous version of the workbook from before the deletion occurred.

Cloud storage services keep a detailed history of your file changes. By reverting to an older version of the entire workbook, you can recover the deleted sheet. Note that any modifications made to other sheets after the restored version's timestamp will be lost.

1
Open the Version History

Open your file in Excel. Click on the file name at the top title bar and select 'Version History' from the drop-down menu. Alternatively, navigate to File > Info > Version History.

2
Locate the Correct Version

A panel will open on the right side of your screen displaying earlier versions organized by date and time. Look for a version saved just before you deleted the worksheet.

3
Restore or Save a Copy

Click 'Open version' to view it. If it contains your deleted worksheet, click the 'Restore' button at the top of the worksheet to overwrite the current file, or 'Save a Copy' to keep both versions.

Restore from OneDrive or SharePoint Version History
Tip: Saving a copy is often safer, as you can manually copy the recovered worksheet into your most recent workbook without losing other recent updates.
Robust File Backup Alternative

Prevent and Recover Lost Worksheets Easily with WPS Office

WPS Office offers a powerful, built-in Local Backup Center that continuously saves historical versions of your spreadsheets. This makes recovering a deleted worksheet incredibly simple, even if you have hit save, providing peace of mind without needing cloud subscriptions.

  1. 1. Open WPS Spreadsheet: Launch WPS Office and open your current spreadsheet document.
  2. 2. Access the Backup Center: Click on 'Menu' at the top left corner, navigate to 'Backup and Recovery', and select 'Backup Center'.
  3. 3. Locate the Previous Version: In the Backup Center window, click on 'Local Backup' to view automatically saved historical versions of your files.
  4. 4. Restore Your Worksheet: Find the version saved just before the worksheet was deleted, double-click to open it, and easily recover your lost data.
Built-in Backup Center to automatically retrieve previous file versions instantlyFully compatible with Microsoft Excel (.xlsx, .xls) file formatsFamiliar user interface requiring zero learning curveFree and lightweight alternative to Microsoft Office
microsoft office alternative - wps office

Frequently Asked Questions

Can I use the Undo shortcut (Ctrl+Z) to get my deleted worksheet back after saving?

No. Once you save and close an Excel workbook, the undo history is completely cleared. Even if you just save the file while keeping it open, Excel typically clears the undo stack for deleted worksheets, making Ctrl+Z ineffective.

Will third-party data recovery software restore just my deleted worksheet?

Generally, no. Data recovery software operates at the file level. It can help you recover a previously saved version of the entire Excel file from your hard drive, but it cannot extract or repair a single deleted worksheet from within a currently existing file.

Where are Excel AutoRecover files stored by default?

By default, Windows stores Excel AutoRecover files in a hidden AppData folder, typically located at C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\. You can verify your specific path by going to File > Options > Save in Excel.