Excel: Roll Back to an AutoSaved Version

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Problem: I need to roll back to an AutoSaved version. I screwed up something that I can not fix with the 64 levels of Undo.

Strategy: Go to the Excel File menu and choose the Info pane. If any autosaved versions are available, they will be listed under versions.

  1. The last two autosaved versions are available.

    Additional Details: When you open an AutoSaved version, it will open as read only. The info pane will alert you that it is not the most recent version. The message bar in Excel will allow you to make that version the current version.