Chat with us, powered by LiveChat

How to Restore a Previous Version of an Excel File

How to Use Version History in Excel

How to Restore a Previous Version of an Excel File

Nothing is more frustrating than when a program locks up—and stops responding—for no apparent reason. You can protect your work from these events by using the AutoRecover feature to periodically save a temporary copy of the project you're working on.

Modify Recovery Settings

When the AutoRecover feature is enabled, a backup copy of the workbook is saved every 10 minutes (its default setting). However, you can change the AutoRecover save interval to occur more or less frequently.

  1. Click the File tab.
    Version History
  2. Click Options.
    Version History

    The Excel Options dialog box appears.

  3. Click Save.
  4. Click in the Minutes field.
  5. Enter a value for how frequently you'd like to save AutoRecover information.
  6. Click OK.
    Version History

Even with Excel’s document recovery features, the best way to ensure that you don’t lose much information if your computer freezes up is to save your work regularly.

Recover Unsaved Workbook Versions

If AutoRecover is enabled in Excel, you don’t have to do anything to make it work. Any available unsaved versions can be found in the Backstage view.

  1. Click the File tab.
    Version History
  2. If needed, scroll to the Version history section.
  3. Select an autosaved version of the file in the list of recovered files.
    Version History

    If the version you need to recover isn’t in the recent list, click the Manage Workbook button and select Recover Unsaved Workbooks to see if the version you need is saved there.

    The previous version of the file opens. At the top, you see a notification that this is an AutoSaved version.

The file is restored to the previous version.

Online Version History

If this is a file that’s saved online, there’s another way to view version history.

  1. Click the Title Bar button.
  2. Select Version History.
    Version History

    Here you see all the changes that have been made to the file, either by you or anyone the file is shared with.

  3. Click Open version for the file you want to restore.
    Version History
  4. Save an additional copy of the file or click the Restore button.
    Version History

FREE Quick Reference

Click to Download