Accidentally saving unwanted edits in Excel can be frustrating, especially after closing the file when the traditional Undo option is no longer available. This guide focuses on how to undo changes in Excel after save and close, offering clear, step-by-step solutions to help you recover previous versions of your data.
While using an Excel file as an outline, somehow I hit the save button and overwrote the original file. I had multiple files open at the time. I believe I tried to close the application with the X button, and when prompted "Do you want to save changes" I hit Yes.
Then all the active Excel files were closed. The unintended consequence was that a file I wished to keep was changed to something I did not really want to save. Is there a way to recover the lost data from the original Excel file? Perhaps through a temporary edit file?
- Question from Bob
Accidentally saving unwanted changes in Excel and then closing the file can feel like a dead end. Many users assume that once the file is saved and closed, there is no way to undo those changes, especially since the standard "Undo" button no longer works in this situation. This often leads to lost data, overwritten formulas, or hours of work seemingly gone.
The good news is that it is still possible to undo changes in Excel after save and close, but only if you use the right methods. Excel provides several built-in recovery options which can help you restore a previous version of your workbook. In this guide, you will learn exactly how to undo changes in Excel after saving and closing, with step-by-step solutions tailored to different scenarios.
Yes, in many cases, you can recover a previous version of an Excel file even after it has been saved and closed. However, the success of recovery depends on how the file was stored and whether certain features were enabled before the changes were made.
If your file is saved in cloud services such as OneDrive or SharePoint, Excel automatically keeps a version history. This allows you to view and restore earlier versions of the file. For locally stored files, recovery is still possible through features like AutoRecover, temporary files, or backup copies, provided they were available or enabled at the time.
When a file has already been saved and closed, the "Undo" button in the left upper corner becomes ineffective because the edit history is cleared once the session ends. At this point, recovering previous data requires alternative methods that rely on versioning, temporary storage, or system-level backups. Below are the most effective ways to undo changes in Excel after save and close, you can try them one by one until the problem is resolved.
If you only saved the Excel file but didn’t close it, you can still use the "Undo" button or "Ctrl" + "Z" to revert the changes. This is the simplest and most effective method. However, this only works if you haven’t performed any other actions besides saving. Once you close the file, this method will no longer work.
Step 1. Press "Ctrl" + "Z" or click the "Undo" button in the left upper corner.
Step 2. Once you confirm this is the version you want, save the file to a safe location.
If your Excel file is stored in cloud services like OneDrive or SharePoint, Excel automatically maintains version history when you edit the file. This is the most reliable way to revert changes because it preserves multiple saved states of the file.
Step 1. Open the Excel file from OneDrive, SharePoint, or Excel Online.
Step 2. Right click on "File" and select "Version History".
Step 3. Browse the list of available versions with timestamps.
Step 4. Open the desired version to check if it’s the one you want and click "Restore" to revert the file.
AutoRecover saves temporary versions of your workbook at intervals, which can help restore unsaved or recently overwritten data. It was originally designed to protect your files in the event of a system or Excel crash. If you have the AutoSave feature enabled, it will automatically save versions at regular intervals. You can try to find your desired version from these backups.
Step 1. Open Excel and go to "File" > "Info".
Step 2. Under "Manage Workbook", you may see a list of auto-saved files from different points in time.
Step 3. Locate and open the relevant AutoRecover file in Excel, then expand "Manage Workbook" and click "Restore" to make this the newest version.
However, you can still navigate to the auto-recovery file location to retrieve any undeleted recovery copies, which usually have the ".xlsb" file extension. Most importantly, you must act as soon as possible.
If Excel’s "Always Create Backup" option was enabled, a backup copy (.xlk) might exist and contain the previous version of your file when you save your workbook. In Microsoft Excel, "Always Create Backup" is a classic yet practical local backup mechanism. And by default, it will not be deleted unless you remove or move the original file.
Step 1. Navigate to the folder where the Excel file is stored.
Step 2. Look for files with a similar name to your current file and the ".xlk" extension.
Step 3. Open the backup file in Excel and save it as a new workbook to avoid overwriting.
☀️How to Enable "Always Create Backup" in Excel:
If the folder where you save your files is synced with OneDrive, every change you make to your Excel file will be synchronized to the OneDrive cloud. OneDrive’s version history records every modification and edit you make. You can undo changes at any time, even after saving and closing the file locally.
Step 1. Go to OneDrive in a browser and sign in with your account.
Step 2. Locate the Excel file and right-click it, then select "Version history" from the menu.
Step 3. Choose an earlier version to verify the correct one and click "Restore" to replace the current file with this version.
Windows may automatically create earlier file versions if you have enabled File History. So, you can easily restore the Excel file if they’re accidentally modified, deleted, or corrupted. However, note that this will only work if the Excel file was added to the backup plan before it was modified.
Step 1. Navigate to the folder or drive where the Excel file was stored in File Explorer, and right-click it, then choose "Restore previous versions" from the context menu.
Step 2. Choose a version from the list based on date/time. You can click "Open" to view the detailed contents of the folder, or open the Excel file to confirm it’s the one you want.
Step 3. Click "Restore" to undo the Excel file changes.
While the methods above can effectively recover earlier versions of an Excel file, they all rely on one key condition: a backup or version record must already exist. When all built-in options fail, recovering overwritten Excel data becomes significantly more challenging, especially if the Excel file was permanently deleted.
In such situations, a more advanced approach is to use a professional data recovery tool like MyRecover. Unlike Excel’s native recovery features, which depend on preconfigured settings, MyRecover works at the disk level and scans your storage device for residual file data without any backup. It supports a wide range of file types, including Excel workbooks, Word documents, PowerPoint presentations, etc., and can perform both quick and deep scans depending on how severe the data loss situation is.
Step 1. Download and install MyRecover on your computer from Microsoft Store or its official website.
Step 2. Launch the app and select the drive which stores the deleted Excel file, then click "Scan" to start the scanning process.
Step 3. After the scan is completed, choose the files you wish to recover from the recoverable lists and click "Recover". Upgrade to the Professional edition to unlock file previews, so you can verify the content before recovery.
Step 4. Select a safe location (not the original drive) to save the recovered files.
Once the recovery is done, the message "Files have been recovered Successfully" will pop up. Then, you can access the recovered files by clicking on the "Browse" button.
In conclusion, accidentally saving and closing an Excel file with unwanted changes can be stressful, especially since the standard "Undo" button becomes ineffective once the file is closed. Fortunately, there are multiple ways to undo the changes or revert your Excel data. These methods provide reliable solutions when the necessary settings or backups were previously enabled.
However, in cases where built-in recovery options are unavailable and the file was permanently deleted, using a professional data recovery tool like MyRecover can offer a deeper, disk-level approach. It can scan for deleted or overwritten Excel files, helping you restore important work when something goes wrong.