File Corruption & Recovery

Recover Accidentally Deleted Data in an Excel Workbook

Olivia MillerOlivia Miller Nov 18, 2026 871 views

Question details

The user needs to recover data accidentally deleted from an original Excel workbook after editing a shortcut or copy.

Recover Accidentally Deleted Data in an Excel Workbook
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.
Before you start

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.

Solution 1Recommended

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.

1
Check Undo

In the open workbook, select Undo on the Quick Access Toolbar or press Ctrl+Z on Windows to reverse recent changes.

2
Save the recovered data

Once the missing data is restored, select File > Save As to save a separate copy of the recovered workbook.

Undo the deletion in the open Excel workbook
Undo history may be unavailable: Closing the workbook or performing certain actions can clear the undo history. If Undo cannot restore the data, check version history or backups.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLS and XLSX files.Use Save As to create a separate workbook before making changes.Navigate spreadsheets in a familiar Office-style interface.Move existing Office documents to a free, lightweight suite.
microsoft office alternative - wps office

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.