Recover Accidentally Deleted Data in an Excel Workbook
Question details
The user needs to recover data accidentally deleted from an original Excel workbook after editing a shortcut or copy.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user edited what appeared to be a separate workbook and wants to restore the original data.
- Observed behavior
- Deleted data is missing from the original workbook, and recovery depends on whether an earlier version, backup, or temporary copy is available.
If the workbook is still open, check whether Undo is available before closing it. Identify where the workbook is stored, such as OneDrive, SharePoint, or a local folder, so you can check the appropriate recovery options.
Undo the deletion in the open Excel workbook
Use Undo first if the workbook is still open and the deletion remains in the current undo history.
In the open workbook, select Undo on the Quick Access Toolbar or press Ctrl+Z on Windows to reverse recent changes.
Once the missing data is restored, select File > Save As to save a separate copy of the recovered workbook.

Restore an earlier workbook version
Use version history when the workbook is stored in OneDrive or SharePoint, or check available local backup versions.
Check AutoRecover, the Recycle Bin, and other backups
Look for an unsaved or backed-up copy if Undo and version history do not provide the missing data.
Work with Excel Files in WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface for opening and editing spreadsheets. Its compatibility with Excel formats makes it easy to move existing workbooks to WPS. It does not restore deleted Excel data without an available earlier copy.

Frequently Asked Questions
Why did editing a shortcut change the original workbook?
A shortcut points to the original file rather than storing an independent workbook. Open the workbook and use File > Save As to create a separate copy before editing.
Can I recover deleted cells from the Recycle Bin?
The Recycle Bin stores deleted files, not individual cells removed from a saved workbook. Try Undo or an earlier workbook version for deleted cell data.
Where can I find an earlier version of an Excel file?
For a workbook stored in OneDrive or SharePoint, check File > Info > Version History in Excel or select Version history from the file's cloud storage menu. On Windows, you can also check Properties > Previous Versions if backups are available.
Can AutoRecover restore data after I saved the deletion?
It might contain an earlier unsaved copy, but it is not guaranteed to recover overwritten data. Check File > Info > Manage Workbook > Recover Unsaved Workbooks and review any relevant files.
What if there is no earlier version or backup?
If Undo is unavailable and no usable version, backup, or temporary copy exists, the deleted data may not be recoverable.




