If you need to know how to recover deleted sheets in Excel, first ask whether the workbook is still open. Press Undo immediately and avoid saving or closing until you confirm the worksheet is back. If the deletion was already saved, find an earlier workbook version and copy the missing sheet into a separate file. Do not overwrite the current workbook, because it may contain valuable edits made after the sheet disappeared.
how to recover deleted sheets in Excel: safe diagnosis
A deleted worksheet and a deleted workbook are different losses. When you remove a sheet tab, Excel changes the open workbook. The XLSX or XLSM file may still exist in its normal folder. Storage recovery cannot extract a single deleted tab from the current saved workbook as though the tab were a separate file. Your best evidence is the open session, an earlier workbook version, or a backup copy.
Before trying anything, record the workbook name and full location. Check whether it is stored locally, on OneDrive, in SharePoint, on a network share, or inside an email attachment folder. Note the missing sheet name, the approximate deletion time, and any work completed afterward. This information helps you choose a version without discarding newer changes.
If the workbook remains open
Use Ctrl+Z or the Undo button as your first action. Do not perform unrelated edits first, because each new action changes the undo history. When the sheet returns, save a copy under a new filename. Confirm formulas, charts, named ranges, PivotTables, and links that depend on the restored tab before replacing any existing file.
If Excel was closed or the deletion was saved
Undo history normally does not survive closing the workbook. Reopening the same file and pressing Ctrl+Z is therefore unlikely to restore the sheet. Shift your attention to version history, AutoRecover, backup copies, or another collaborator’s unsaved session. Keep the current workbook unchanged while you search.
Open version history without replacing the current file
For a workbook stored in OneDrive or SharePoint, open Version History from Excel or the storage service. Select a version from before the deletion and inspect it. Microsoft’s instructions for restoring a previous Excel version explain that Restore replaces the current version, which means later updates can be lost. The safer approach is to open or download the older version as a separate copy whenever the interface permits.
Check the missing tab first, but do not stop there. Confirm that the older workbook has the expected date, sheet order, formulas, tables, macros, external connections, and source data. A version saved five minutes before deletion may be ideal; a version from last week may contain the worksheet but omit substantial recent work.
Copy only the recovered sheet
Open the current workbook and the older copy side by side. In the older file, right-click the recovered sheet tab, choose Move or Copy, select the current workbook, and enable Create a copy. Save the result under a third filename before deciding which version becomes authoritative. This preserves the newer workbook while importing the missing worksheet.
Sheet-level dependencies require care. Formulas may refer to other tabs, workbook-level named ranges, Power Query connections, macros, or external data sources. Copying one worksheet can adjust references or leave links pointed at the older file. Use Formulas > Name Manager, Data > Queries & Connections, and Edit Links where available to inspect the result.
Look for local recovery and backup copies
If Version History is unavailable, open Excel and check File > Info > Manage Workbook. A recovery copy may exist when AutoRecover was enabled or Excel closed unexpectedly. Also inspect the AutoRecover location shown in Excel Options. Copy a candidate to a safe working folder before opening it; do not rename or overwrite the only candidate.
Search the workbook’s original folder for files with similar names, backup extensions, or timestamps around the deletion. Windows File History and Previous Versions may contain an earlier copy. An attachment sent before the incident can also preserve the sheet, although it may not include later edits. On a managed network share, ask the administrator about server snapshots rather than attempting permission or volume changes yourself.
The guide to recover a previous file version explains the wider Windows options. If the entire workbook was deleted, use the separate workflow for recovering a deleted Excel file. For an existing workbook that will not open, the Excel document recovery methods address corruption and unsaved-file cases.
Use Drecov only when the workbook file is missing locally
PandaOffice Drecov becomes relevant if an earlier local workbook, an AutoRecover file, or the entire XLSX/XLSM file was deleted or became inaccessible on stable Windows storage. It cannot pull a deleted worksheet out of a currently saved workbook, repair formulas, restore a cloud version, or recreate overwritten cells. Its role is to locate recoverable workbook files on a PC, HDD, SSD, external drive, USB device, SD card, or memory card.
Drecov uses read-only recovery mode, Quick Scan, Deep Scan, filters, preview, and recovery to a selected healthy destination. Lost Partition Recovery is available when the volume that held the workbook has disappeared. Stop using the source immediately. Do not install recovery software on that partition, and prepare another healthy drive for the recovered files. If the device disconnects, clicks, or reports severe read errors, stop direct scans and seek imaging or professional help.
⚠ Warning: Install it on a drive different from the one where your data was lost to prevent overwriting.
Step 1: Open Drecov and select the workbook’s former location
Choose the stable drive or partition where the missing workbook or AutoRecover copy was stored. Identify it by model, capacity, and former path. Select Lost Partition Recovery only when the relevant partition is no longer present.
Step 2: Run Quick Scan and examine spreadsheet candidates
Start Quick Scan. Browse the original folder and AutoRecover path first. Filter for spreadsheet formats and compare filenames, sizes, and modification dates with the incident timeline.
Step 3: Run Deep Scan only while the source stays stable
This check is especially useful for how to recover deleted sheets in Excel. If Quick Scan misses the workbook and the disk remains consistently readable, start Deep Scan. Older candidates may no longer retain their original names or folders. End the scan if new instability appears.
Step 4: Filter and preview several workbook versions
It helps diagnose how to recover deleted sheets in Excel without changing the source data. Use extension, former path, filename, size, and date together. Preview supported candidates where possible. A preview can help identify a workbook, but it does not verify every worksheet, formula, macro, chart, or external connection.
Step 5: Recover candidates to the healthy destination
Recover promising files to the separate drive, never to the source. If results are not in the expected destination, check Drecov Folder or Recovery Folder. Keep multiple plausible versions until inspection is complete.
⚠ Warning: Install it on a drive different from the one where your data was lost to prevent overwriting.
Step 6: Validate the workbook and the deleted sheet
Open recovered copies with macros disabled initially when their origin is uncertain. Confirm the missing sheet, recalculate formulas, inspect named ranges and charts, and compare totals against a trusted export. Only then resume cleanup or repair on the source.
Verify the restored worksheet before normal editing resumes
Save the assembled workbook under a new name. Check formulas that refer to the restored tab, conditional formatting, data validation, hidden rows and columns, filters, PivotTable sources, charts, and print areas. For XLSM files, verify macros in a controlled environment and confirm that copying the sheet did not change workbook-level names.
Ask another user to open the file if it is shared. Confirm that cloud synchronization has finished before deleting older copies. Label the known-good version clearly, but retain the pre-recovery workbook until the team agrees that no recent edits were lost.
Finally, create a small test change in a duplicate and confirm that it saves to the intended location. This catches a common follow-up problem: users recover the correct sheet but continue editing an attachment, temporary download, or stale offline copy instead of the shared workbook.
FAQ
Can Excel restore a sheet after I saved and closed the file?
Undo will usually be unavailable. Look for Version History, AutoRecover, File History, a backup, or a copy held by another collaborator.
Will restoring version history erase newer work?
Restoring an older version can replace the current workbook state. Open or download the older version separately, then copy only the missing sheet when possible.
Can Drecov recover one deleted worksheet?
Not from inside a currently saved workbook. Drecov can search stable local storage for an earlier or deleted workbook file that may still contain the worksheet.
Why did formulas change after I copied the sheet?
The sheet may depend on workbook-level names, other tabs, queries, or external links. Inspect those references before accepting the recovered file.
Should I overwrite the current workbook with the old version?
No. Keep both files and assemble a third copy. Overwriting too early can trade one recovered sheet for many lost recent edits.
Conclusion
The quickest route to a deleted Excel sheet depends on timing: Undo while the session remains open, then Version History or backup copies after the deletion has been saved. Preserve the current workbook and transfer the missing tab from an older copy so later edits survive. Use Drecov only when a local workbook file itself has disappeared, recover it to another healthy drive, and verify every important worksheet dependency before returning to normal work.
⚠ Warning: Install it on a drive different from the one where your data was lost to prevent overwriting.
