{"id":4217,"date":"2017-02-28T03:10:26","date_gmt":"2017-02-28T08:40:26","guid":{"rendered":"http:\/\/news.filepuma.com\/?p=4217"},"modified":"2024-06-18T05:02:54","modified_gmt":"2024-06-18T12:02:54","slug":"how-to-back-up-files-automatically-in-excel-2016","status":"publish","type":"post","link":"https:\/\/www.filepuma.com\/reviews\/how-to-back-up-files-automatically-in-excel-2016\/","title":{"rendered":"How to Back Up Files Automatically in Excel 2016"},"content":{"rendered":"<p style=\"color: #494949;text-align: justify\">Accidental deletions or changes to a file can ruin your day&#8211;if you don&#8217;t have a backup of your original file. Excel&#8217;s AutoBackup feature will help keep your data as safe as possible by saving a previous version of your spreadsheet automatically. Here&#8217;s how to use it.<\/p>\n<p style=\"color: #494949\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-286058\" style=\"font-weight: inherit;font-style: inherit\" src=\"http:\/\/www.laptopmag.com\/images\/wp\/purch-api\/incontent\/2016\/03\/excel-autobackup-files-670x293.png\" alt=\"excel autobackup files\" width=\"670\" height=\"293\" \/><\/p>\n<p style=\"color: #494949;text-align: justify\">AutoBackup makes a copy of your spreadsheet when you first save it. If you make changes to your original spreadsheet and save it but then change your mind about the changes, you can\u00a0open the backup copy. Each time you save the original spreadsheet, AutoBackup updates the backup copy so it&#8217;s up to date and one version behind the original. To set it up, start creating your worksheet as usual. Then:<\/p>\n<p style=\"color: #494949\">1.\u00a0<strong style=\"font-weight: bold;font-style: inherit\">Go to File &gt; Save As.<\/strong><\/p>\n<p style=\"color: #494949\"><img decoding=\"async\" src=\"http:\/\/www.laptopmag.com\/images\/wp\/purch-api\/incontent\/2016\/03\/excel-saveas.png\" alt=\"excel saveas\" \/><\/p>\n<p>2.\u00a0<strong style=\"font-weight: bold;font-style: inherit\">For Excel 2016, click &#8220;More options\u2026&#8221;<\/strong>\u00a0under the save location. Earlier versions of Excel: skip this<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-286060\" style=\"font-weight: inherit;font-style: inherit\" src=\"http:\/\/www.laptopmag.com\/images\/wp\/purch-api\/incontent\/2016\/03\/excel-saveoptions-626x400.png\" alt=\"excel saveoptions\" width=\"626\" height=\"400\" \/><\/p>\n<p>3.\u00a0<strong style=\"font-weight: bold;font-style: inherit\">Click the Tools button then General Options<\/strong>\u00a0in the Save As dialog window.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-286059\" style=\"font-weight: inherit;font-style: inherit\" src=\"http:\/\/www.laptopmag.com\/images\/wp\/purch-api\/incontent\/2016\/03\/excel-tools-568x400.png\" alt=\"excel tools\" width=\"568\" height=\"400\" \/><\/p>\n<p>4.\u00a0<strong style=\"font-weight: bold;font-style: inherit\">Check the box next to &#8220;Always create backup&#8221;<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-286056\" style=\"font-weight: inherit;font-style: inherit\" src=\"http:\/\/www.laptopmag.com\/images\/wp\/purch-api\/incontent\/2016\/03\/excel-autobackup.png\" alt=\"excel autobackup\" width=\"284\" height=\"178\" \/><\/p>\n<p>5.\u00a0<strong style=\"font-weight: bold;font-style: inherit\">Click OK.<\/strong><\/p>\n<p>6.\u00a0<strong style=\"font-weight: bold;font-style: inherit\">Click Save<\/strong>\u00a0in the Save dialog window.<\/p>\n<p>Now, every time you make a change in the original spreadsheet and save it, the backup file will be updated to reflect your spreadsheet before that last save.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Accidental deletions or changes to a file can ruin your day&#8211;if you don&#8217;t have a backup of your original file. Excel&#8217;s AutoBackup feature will help keep your data as safe as possible by saving a previous version of your spreadsheet automatically. Here&#8217;s how to use it. AutoBackup makes a copy of your spreadsheet when you [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[33],"tags":[],"class_list":["post-4217","post","type-post","status-publish","format-standard","hentry","category-business"],"_links":{"self":[{"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/posts\/4217","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/comments?post=4217"}],"version-history":[{"count":1,"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/posts\/4217\/revisions"}],"predecessor-version":[{"id":4869,"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/posts\/4217\/revisions\/4869"}],"wp:attachment":[{"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/media?parent=4217"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/categories?post=4217"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/tags?post=4217"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}