File Corruption & Recovery

How to Recover Deleted Excel Worksheets from a Damaged Workbook

Elise Williams Oct 12, 2026 869 views

Question details

The user needs to recover multiple Excel worksheets that were deleted or replaced with text due to file corruption and confusing OneDrive synchronization.

How to Recover Deleted Excel Worksheets from a Damaged Workbook

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to restore lost worksheets from a corrupted Excel file while navigating OneDrive sync issues and duplicate folders.
Observed behavior: Excel removed multiple worksheets and replaced them with text. Additionally, enabling OneDrive synchronization created multiple Documents folders, making it difficult to locate files.

Before you start

Immediately pause your OneDrive synchronization to prevent the corrupted file from overwriting healthy cloud backups. Do not save or modify the currently damaged workbook until you have secured a backup.

Solution 1Recommended

Restore Worksheets Using Version History and AutoRecover

Utilize built-in version history features in OneDrive or Windows, along with Excel's AutoRecover, to find an intact older version of your workbook.

When an Excel file becomes corrupted, the most reliable method for recovering missing worksheets is rolling back to a previous version saved automatically by the system.

Check OneDrive Version History

Right-click the damaged Excel file in your local OneDrive folder and select 'Version history'. Browse the list of saved versions and restore one from before the corruption occurred.

Use Windows Previous Versions

Right-click the folder containing your workbook or the file itself, select 'Properties', and navigate to the 'Previous Versions' tab. If a shadow copy exists, select it and click 'Restore'.

Access Excel AutoRecover

Open a blank Excel workbook, go to 'File' > 'Info' > 'Manage Workbook', and select 'Recover Unsaved Workbooks'. Look for temporary backup copies of your corrupted file.

Restore Worksheets Using Version History and AutoRecover

Extracting Data Safely: If you successfully open an older version, immediately copy the recovered worksheets into a brand new workbook to sever any lingering corrupted links.

Solution 2

Pause OneDrive Sync and Retrieve Cloud Backups

Prevent further syncing of the damaged file and manually download safe copies directly from your OneDrive cloud storage.

Solution 3

Inspect for Hidden Sheets and Local Backup Files

Check if the missing worksheets were accidentally hidden during the crash or search for standard Excel backup files.

Free Microsoft Office alternative

Switch to WPS Office for Reliable File Management and Backups

Tired of complicated file synchronization and frequent workbook corruption in Microsoft Office? WPS Office provides a highly compatible, lightweight alternative with robust local backup features to keep your data safe without the confusion of duplicate sync folders.

1. Download and Install: Get WPS Office for free from the official website and install it quickly on your computer.
2. Open Your Spreadsheets: Easily open, view, and edit your existing .xlsx files in WPS Spreadsheet with perfect formatting retention.
3. Enable Smart Backup: Turn on WPS Local Backup in the settings to automatically save version histories locally and safely.

Highly compatible with Microsoft Excel (.xlsx, .xls, .csv) formatsBuilt-in local backup and auto-recovery tools to prevent data lossFree, lightweight, and incredibly easy to navigateSeamless file management without confusing cloud sync duplicates

microsoft office alternative - wps office

Frequently Asked Questions

Why did Excel replace my worksheets with plain text?

This typically happens when an Excel workbook becomes severely corrupted. To salvage the file, Excel's automatic repair tool strips out unreadable objects, formatting, and corrupted sheet structures, leaving only recoverable plain text behind.

Where does Excel store its AutoRecover files?

By default, AutoRecover files are stored in the hidden AppData directory. You can usually find them by navigating to 'C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\' in your File Explorer.

How do I stop OneDrive from creating multiple Documents folders?

You can resolve duplicate folders by managing your OneDrive backup settings. Click the OneDrive icon in your taskbar, go to Settings, navigate to the 'Sync and backup' tab, click 'Manage backup', and toggle off the Documents folder backup to restore local control.

Can a corrupted Excel file be permanently fixed?

If Excel's built-in 'Open and Repair' command cannot restore the original structure, the file itself may remain permanently corrupted. The safest solution is always to extract the surviving data or sheets into a brand new workbook and discard the damaged file.

Document & File Issues