{"id":3188,"date":"2021-04-03T08:55:52","date_gmt":"2021-04-03T15:55:52","guid":{"rendered":"https:\/\/SUMMALAI.COM\/?p=3188"},"modified":"2021-04-03T08:55:54","modified_gmt":"2021-04-03T15:55:54","slug":"how-to-restore-a-auto-saved-previous-version-of-an-excel-file","status":"publish","type":"post","link":"https:\/\/SUMMALAI.COM\/?p=3188","title":{"rendered":"How to Restore a Auto-saved (Previous) Version of an Excel File"},"content":{"rendered":"\n

Nothing is more frustrating than when a program locks up\u2014and stops responding\u2014for 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.<\/p>\n\n\n\n

Modify Recovery Settings<\/a><\/h3>\n\n\n\n

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.<\/p>\n\n\n\n

  1. Click the File<\/strong> tab.\"Version<\/li>
  2. Click Options<\/strong>.\"VersionThe Excel Options dialog box appears.<\/li>
  3. Click Save<\/strong>.<\/li>
  4. Click in the Minutes<\/strong> field.<\/li>
  5. Enter a value for how frequently you’d like to save AutoRecover information.<\/li>
  6. Click OK<\/strong>.\"Version<\/li><\/ol>\n\n\n\n

    Even with Excel\u2019s document recovery features, the best way to ensure that you don\u2019t lose much information if your computer freezes up is to save your work regularly.<\/p>\n\n\n\n

    Recover Unsaved Workbook Versions<\/a><\/h3>\n\n\n\n

    If AutoRecover is enabled in Excel, you don\u2019t have to do anything to make it work. Any available unsaved versions can be found in the Backstage view.<\/p>\n\n\n\n

    1. Click the File<\/strong> tab.\"Version<\/li>
    2. If needed, scroll to the Version history section.<\/li>
    3. Select an autosaved version of the file in the list of recovered files.\"VersionIf the version you need to recover isn\u2019t in the recent list, click the Manage Workbook<\/strong> button and select Recover Unsaved Workbooks<\/strong> 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.<\/li><\/ol>\n\n\n\n

      The file is restored to the previous version.<\/p>\n\n\n\n

      Online Version History<\/a><\/h3>\n\n\n\n

      If this is a file that\u2019s saved online, there\u2019s another way to view version history.<\/p>\n\n\n\n

      1. Click the Title Bar<\/strong> button.<\/li>
      2. Select Version History<\/strong>.\"VersionHere you see all the changes that have been made to the file, either by you or anyone the file is shared with.<\/li>
      3. Click Open version<\/strong> for the file you want to restore.\"Version<\/li>
      4. Save an additional copy of the file or click the Restore<\/strong> button.<\/li><\/ol>\n\n\n\n

        Ref: https:\/\/www.customguide.com\/excel\/restore-previous-version-of-excel-file<\/p>\n","protected":false},"excerpt":{"rendered":"

        Nothing is more frustrating than when a program locks up\u2014and stops responding\u2014for 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 Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10,18],"tags":[663],"class_list":["post-3188","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-microsoft-office","tag-excel-auto-saved-version"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3188","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3188"}],"version-history":[{"count":1,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3188\/revisions"}],"predecessor-version":[{"id":3189,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3188\/revisions\/3189"}],"wp:attachment":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3188"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3188"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3188"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}