File Corruption & Recovery

How to Recover Missing Excel Worksheets and Pivot Tables

Maira Mehtab Sep 22, 2026 869 views

Question details

The user needs to recover Excel worksheets and pivot tables that have disappeared after a workbook was saved, renamed, or moved.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Worksheets and pivot tables go missing after the user saves, renames, or moves an existing Excel workbook.
Observed behavior: The newly added or modified worksheets and pivot tables are no longer present when the workbook is opened again.

Before you start

Check your computer's Recycle Bin to ensure the original version of the file was not accidentally deleted or replaced while you were moving or renaming the workbook.

Solution 1Recommended

Restore Previous File Version via OneDrive

If your workbook was saved to OneDrive or SharePoint, you can use the Version History feature to revert the file to a state before the worksheets disappeared.

Microsoft's AutoSave feature automatically creates previous versions of files stored in the cloud. If local recovery fails, cloud version history is the most reliable way to retrieve missing spreadsheet data.

Locate the File in OneDrive

Open your OneDrive folder using File Explorer (Windows) or Finder (Mac), or navigate to OneDrive in your web browser.

Open Version History

Right-click the Excel workbook that is missing the worksheets and select 'Version history' from the context menu.

Restore the Workbook

Review the list of saved versions organized by date and time. Click the three vertical dots next to the correct timestamp and select 'Restore' to recover your missing pivot tables and worksheets.

Local Storage Limitations: If the workbook was stored locally on your hard drive and changes were not saved before closing, recovery of the specific missing worksheets may not be possible.

Solution 2

Check the Unsaved Workbooks Directory

If the worksheets were lost because Excel crashed while saving or moving the file, an AutoRecover draft might still exist on your local drive.

Free Microsoft Office alternative

Prevent Data Loss with WPS Office's Built-in Backup Center

Stop worrying about lost worksheets and pivot tables. WPS Office is a free, lightweight alternative to Microsoft Office that offers full format compatibility, a familiar user interface, and a powerful local Backup Center to automatically save your spreadsheet progress.

1. Download WPS Office: Get the free WPS Office suite from the official website and install it securely on your PC or Mac.
2. Open Your Excel File: Launch WPS Spreadsheet and seamlessly open your existing .xlsx workbooks without losing any formulas or pivot table formatting.
3. Enable Local Auto-Backup: Go to Menu > Settings > Backup Settings, and activate the Local Backup feature to ensure your worksheets are continuously saved while you work.

100% compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Built-in robust local Backup Center prevents accidental loss of worksheets.Free, lightweight software that runs smoothly on older devices.Familiar tabbed user interface requires no learning curve to master.

microsoft office alternative - wps office

Frequently Asked Questions

Why did my Excel worksheets disappear after saving?

Worksheets can disappear if the workbook was accidentally saved over with an older version, if a network error interrupted the cloud sync process, or if the worksheets were unintentionally hidden by the user.

How do I unhide missing worksheets in Excel?

Sometimes worksheets are not permanently lost, just hidden from view. Right-click any visible worksheet tab at the bottom of your screen and select 'Unhide'. If the option is available, select the missing sheets from the list and click 'OK'.

Can I recover an Excel file if I clicked 'Don't Save'?

If the file was saved locally and you explicitly clicked 'Don't Save', standard recovery is highly unlikely. However, if the file was syncing to OneDrive or SharePoint, you may still be able to find a previous auto-saved version in the cloud Version History.

How can I prevent losing Pivot Tables in the future?

Ensure AutoSave is enabled by saving your workbooks to a cloud service like OneDrive. If working locally, frequently press Ctrl+S to save your progress, or use an office suite with a dedicated local auto-backup manager to secure your pivot table configurations.

Document & File Issues