MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2019: Undo an AutoSave


March 11, 2019 - by Bill Jelen

Excel Undo an AutoSave. Photo Credit: Miguel A. Amutio at Unsplash.com

What if you have to undo an AutoSave? Your manager said to merge two regions and then 20 minutes later calls the merger off. AutoSave has been saving after every change in your workbook.

Click the drop-down menu next to the title bar. Click on Version History.


Excel will offer to let you open a previous version of the file. They don't save a version after every change. I (Bill Jelen) made 50 changes to this workbook in the last 20 minutes. The Version History is offering me three versions from those twenty minutes. Note that although all of the changes were made by Bill Jelen, AutoSave is crediting the changes to Mary Ellen Jelen. No one at Microsoft can explain this apparent bug.

Detail of the Version History pane offer to go back to 6:31 AM and 6:38 AM. But 20 different changes were made between these two times.

Title Photo: Miguel A. Amutio at Unsplash.com


Bill Jelen is the author / co-author of
Microsoft Excel 2019 Inside Out

Dive into Microsoft Excel 2019–and really put your spreadsheet expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds–all you need to make the most of Excel’s most powerful tools for analyzing data and making better decisions.