XLChat

How to Undo Changes in Excel After Saving

AS
aspardo
3-1-2025

Excel is a powerful tool used by millions for data analysis, reporting, and much more. However, one common frustration many users face is the inability to undo changes after saving a workbook. In this blog post, we'll explore some methods to help you recover or undo changes in Excel even after you've saved the file.

Understanding Excel's Undo Limitations

By default, Excel's undo feature (Ctrl + Z on Windows or Cmd + Z on Mac) only works for actions performed in the current session. Once you save and close the workbook, the undo history is cleared. This can be a problem if you realize a mistake after saving.

Method 1: Use AutoRecover Files

Excel's AutoRecover feature can be a lifesaver. It periodically saves a copy of your workbook, which can be used to recover your work if Excel crashes or if you need to revert to a previous version.

  1. Enable AutoRecover: Go to File > Options > Save, and ensure that Save AutoRecover information every [X] minutes is checked. Set the interval to a suitable time, like 10 minutes.

  2. Locate AutoRecover Files: If you need to recover a file, you can find AutoRecover files in the following locations:

    • Windows: C:\Users\<username>\AppData\Roaming\Microsoft\Excel\
    • Mac: ~/Library/Application Support/Microsoft/Excel/

  3. Recover Your Work: Open the AutoRecover file that corresponds to the time before you made the unwanted changes. You can then copy the necessary data back into your main workbook.

Method 2: Use Version History (Excel Online and OneDrive)

If you're using Excel Online or have your workbook saved on OneDrive, you can take advantage of the Version History feature.

  1. Access Version History: Open your workbook in Excel Online, go to File > Info, and click on Version History.

  2. Select a Previous Version: You'll see a list of saved versions of your workbook. Click on the version you want to revert to, and it will open in a new tab.

  3. Copy and Paste: Compare the old version with your current version and copy the necessary data back into your main workbook.

Method 3: Use a Third-Party Add-In

There are several third-party add-ins available that can enhance Excel's undo functionality. One popular option is UndoPlus.

  1. Install UndoPlus: Download and install the UndoPlus add-in from their official website.

  2. Configure Settings: Once installed, you can configure UndoPlus to keep a longer history of changes, even after saving and closing the workbook.

  3. Revert Changes: Use the UndoPlus toolbar to revert to any point in your workbook's history.

Method 4: Manual Backup

If you're working on a critical project, consider manually saving backup copies of your workbook at regular intervals.

  1. Save Backups: Use File > Save As to create a new version of your workbook with a different name or in a different folder. For example, you could name your backups Project_v1.xlsx, Project_v2.xlsx, etc.

  2. Revert to a Backup: If you need to undo changes, simply open the most recent backup that doesn't include the unwanted changes and continue working from there.

Conclusion

While Excel's built-in undo feature has its limitations, there are several methods you can use to recover or undo changes even after saving your workbook. By leveraging AutoRecover, Version History, third-party add-ins, or manual backups, you can safeguard your work and minimize the impact of mistakes. Always remember to save frequently and consider using multiple methods for added security.