How to Recover Lost Excel Data After Freezing and Auto-Undo
Question details
The user needs to recover workbook data that was lost when Excel became unresponsive and automatically undid multiple recent changes.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user copied and pasted formula cells into another workbook, causing Excel to freeze and revert extensive changes upon resuming.
- Observed behavior
- Excel displayed a 'Not Responding' error, recovered after a few minutes, but executed a mass undo that wiped out hours of work. The standard Undo and Redo commands were disabled or unable to restore the data.
Before attempting recovery, ensure that you do not save any further changes to the current workbook, as this could overwrite previous recoverable versions in your system.
Restore a Previous Version via OneDrive or SharePoint
Use this method if your Excel file is saved in an online location like OneDrive or SharePoint, which automatically tracks version history.
Microsoft 365 automatically saves versions of your files when they are stored in OneDrive or SharePoint. This is the most reliable way to recover data lost during an application crash.
Log in to your OneDrive or SharePoint account via a web browser and navigate to the folder containing your Excel workbook.
Right-click the corrupted or reverted Excel file and select 'Version history' from the context menu.
Review the list of saved versions by date and time. Click the three dots next to the version saved just before the crash, and select 'Restore' to replace the current file, or 'Open File' to review its contents first.

Restore Previous Versions from Local Windows File History
Use this method if your file is saved locally on your computer and you have Windows File History or System Restore enabled.
Contact Microsoft 365 Support for Advanced Recovery
Use this method if neither version history nor local backups yield the lost data, and you are operating under a business or school account.
Prevent Data Loss with WPS Office's Robust Auto-Backup
Tired of unexpected crashes, lagging performance, and lost work in Microsoft Excel? WPS Office offers a highly stable, lightweight spreadsheet alternative with an advanced built-in Auto-Backup feature to ensure your complex formulas and data are always secure.
- 1. Download WPS Office: Download and install the free version of WPS Office from the official website.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files without losing any formatting or formulas.
- 3. Enable Smart Backup: Navigate to the settings menu to configure local and cloud Auto-Backup intervals for total peace of mind.

Frequently Asked Questions
Why did Excel automatically undo my changes after freezing?
When Excel encounters a severe error—such as memory overload from pasting complex formulas—it may attempt to recover stability by reverting to the last safely cached state. This emergency recovery can unfortunately wipe out unsaved or uncommitted changes, resulting in a 'mass undo'.
Can I use the Undo button to reverse Excel's automatic revert?
No. When Excel crashes and performs a forced recovery or mass revert to restore application stability, the normal Undo and Redo history is entirely cleared from the system's active memory. You must rely on file backups or version history to recover the data.
Where are Excel AutoRecover files saved locally on Windows?
By default, Windows saves AutoRecover files in the hidden AppData folder. You can usually find them by navigating to C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\. Check this folder for any unsaved versions generated right before the crash.
How do I prevent Excel from losing data during a crash in the future?
To prevent data loss, always enable 'AutoSave' in the top-left corner if saving to OneDrive. If saving locally, go to File > Options > Save, and ensure 'Save AutoRecover information every X minutes' is checked and set to a short interval, such as 5 minutes.




