Deleted File Recovery

Recover Deleted Data in an Excel 2007 Workbook After Saving

Nimra MalikNimra Malik Nov 14, 2026 868 views

Question details

Recover worksheet data that was accidentally deleted before an Excel 2007 workbook was saved.

Recover Deleted Data in an Excel 2007 Workbook After Saving
Product
Microsoft Excel 2007
Device & OS
not provided
Scenario
The user deleted data from a worksheet and saved the workbook before noticing the mistake.
Observed behavior
The saved workbook no longer contains the deleted information.
Before you start

Check whether the workbook is still open and whether Undo is available. Note the workbook's name and location so you can search for an earlier copy.

Solution 1

Use Undo if the Workbook Is Still Open

Try Undo first if you have not closed the workbook since deleting the data.

1
Undo the deletion

In Excel 2007, click Undo on the Quick Access Toolbar or press Ctrl+Z until the deleted data returns. Saving does not necessarily clear the Undo history.

2
Save the recovered data

Check the worksheet, then click the Office Button and choose Save As to save a separate recovered copy.

Undo history may be unavailable: Closing the workbook or performing certain actions can clear the Undo history. Undo may also reverse other recent changes.
Free Microsoft Office alternative

Edit Recovered Excel Workbooks with WPS Spreadsheet

WPS Office is a free, lightweight alternative with a familiar interface for working on spreadsheets. Open a recovered Excel workbook in WPS Spreadsheet and continue editing with a straightforward transition from Microsoft Office.

Open and edit recovered spreadsheet data in WPS SpreadsheetCompatible with Microsoft Excel XLS and XLSX formatsFamiliar spreadsheet interface for an easier transitionFree and lightweight office suite
QA img-9

Frequently Asked Questions

Can I undo deleted data after saving an Excel 2007 workbook?

Possibly. If the workbook is still open and the Undo history remains available, click Undo on the Quick Access Toolbar or press Ctrl+Z. Saving alone does not necessarily clear the history.

Where can I find a previous version of my workbook?

In File Explorer, right-click the workbook, select Properties, and open the Previous Versions tab. A version is available only if the system has retained one.

Can I recover the data after closing Excel?

Undo history is generally unavailable after closing the workbook. Check Windows Previous Versions, backups, cloud version history, or any usable AutoRecover files for an earlier copy.

Will AutoRecover always restore deleted worksheet data?

No. AutoRecover is primarily designed for unexpected interruptions, and its files may not contain the data from before the deletion. In Excel 2007, check the location under Office Button > Excel Options > Save.