Recover Deleted Data in an Excel 2007 Workbook After Saving
Question details
Recover worksheet data that was accidentally deleted before an Excel 2007 workbook was saved.

- 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.
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.
Use Undo if the Workbook Is Still Open
Try Undo first if you have not closed the workbook since deleting the data.
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.
Check the worksheet, then click the Office Button and choose Save As to save a separate recovered copy.
Recover an Earlier Workbook Version in Windows
Use Previous Versions if Windows has a copy from before the data was deleted.
Check Backups, Cloud History, and Recovery Files
Look for another copy if Undo and Windows Previous Versions do not provide the missing data.
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.

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.





