{"id":5938,"date":"2023-04-12T14:50:54","date_gmt":"2023-04-12T14:50:54","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=5938"},"modified":"2024-05-15T18:48:13","modified_gmt":"2024-05-15T18:48:13","slug":"how-to-turn-on-autosave-in-excel","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/how-to-turn-on-autosave-in-excel\/","title":{"rendered":"How to Turn on AutoSave in Excel?"},"content":{"rendered":"<div class=\"flex-1 overflow-hidden\">\n<div class=\"react-scroll-to-bottom--css-slast-79elbk h-full\">\n<div class=\"react-scroll-to-bottom--css-slast-1n7m0yu\">\n<div class=\"flex flex-col text-sm pb-9\">\n<div class=\"w-full text-token-text-primary\" dir=\"auto\" data-testid=\"conversation-turn-95\" data-scroll-anchor=\"true\">\n<div class=\"py-2 px-3 text-base md:px-4 m-auto md:px-5 lg:px-1 xl:px-5\">\n<div class=\"mx-auto flex flex-1 gap-3 text-base juice:gap-4 juice:md:gap-6 md:max-w-3xl\">\n<div class=\"relative flex w-full min-w-0 flex-col agent-turn\">\n<div class=\"flex-col gap-1 md:gap-3\">\n<div class=\"flex flex-grow flex-col max-w-full\">\n<div class=\"min-h-[20px] text-message flex flex-col items-start whitespace-pre-wrap break-words [.text-message+&amp;]:mt-5 juice:w-full juice:items-end overflow-x-auto gap-2\" dir=\"auto\" data-message-author-role=\"assistant\" data-message-id=\"3e6c9c72-d92d-4851-90bf-2bc787ed66f7\">\n<div class=\"flex w-full flex-col gap-1 juice:first:pt-[3px]\">\n<div class=\"markdown prose w-full break-words dark:prose-invert light\">\n<p>Turn on AutoSave in Excel to safeguard your work and prevent data loss with every edit. By enabling AutoSave, you ensure that your Excel files are automatically saved at regular intervals, minimizing the risk of losing unsaved changes due to unexpected interruptions or system crashes. Say goodbye to the anxiety of forgetting to save your work and hello to peace of mind with this essential feature. Whether you&#8217;re collaborating on a project, analyzing data, or creating presentations, turning on AutoSave in Excel offers convenience and reliability, allowing you to focus on your tasks without worrying about losing progress. Take control of your file management and ensure that your work is always protected by enabling AutoSave in Excel. With just a simple setting adjustment, you can enjoy continuous saving and seamless recovery options, making Excel a more efficient and dependable tool for your productivity needs.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><strong>This Content Covers:<\/strong><\/p>\n<ol>\n<li><a href=\"#what-is-autosave-in-excel?\"><strong>What is AutoSave in Excel<\/strong><strong>?<\/strong><\/a><\/li>\n<li><a href=\"#autosave-vs-autorecover\"><strong>AutoSave Vs AutoRecover<\/strong><\/a><\/li>\n<li><a href=\"#turn-on-autorecover-in-previous-versions-of-excel\"><strong>Turn On AutoRecover in Previous Versions of Excel<\/strong><\/a><\/li>\n<li><a href=\"#turn-on-autosave-in-excel-365\"><strong> Turn On AutoSave in Excel 365 <\/strong><\/a><\/li>\n<li><a href=\"#adding-autosave-to-qat-in-excel-365\"><strong> Adding AutoSave to QAT in Excel 365<\/strong><\/a><\/li>\n<li><a href=\"#how-to-restore-unsaved-excel-files?\"><strong> How to Restore Unsaved Excel Files?<\/strong><\/a><\/li>\n<li><a href=\"#automatically-save-file-before-closing-using-vba\"><strong>Automatically Save File Before Closing using VBA<\/strong><\/a><\/li>\n<li><a href=\"#some-basic-questions-&amp;-issues-with-autosave\"><strong>Some Basic Questions &amp; Issues with AutoSave<\/strong><\/a><\/li>\n<\/ol>\n<h2><strong id=\"what-is-autosave-in-excel?\">1. What Is AutoSave in Excel<\/strong><strong>?<\/strong><\/h2>\n<p>For Microsoft 365 members, Excel now has a new function called AutoSave that automatically saves your file as you work every few seconds. With Microsoft 365, AutoSave is automatically activated when a file is stored on OneDrive, OneDrive for Business, or SharePoint Online.<\/p>\n<h2><strong id=\"autosave-vs-autorecover\">2. AutoSave Vs AutoRecover<\/strong><\/h2>\n<ul>\n<li>In contrast to AutoRecover, which was included in earlier versions, AutoSave is a new function in Excel Office 365.<\/li>\n<li>When you save your Excel files in OneDrive or Sharepoint, AutoSave enables you to save your work in real-time; in contrast, AutoRecover saves the file once every 10 minutes or whatever time you specify.<\/li>\n<\/ul>\n<h2><strong id=\"turn-on-autorecover-in-previous-versions-of-excel\">3. Turn On AutoRecover in Previous Versions of Excel<\/strong><\/h2>\n<p><strong>Step 1: <\/strong>Right click on <strong>QAT (Quick Access Toolbar) <\/strong>and select <strong>More Commands. <\/strong>This will open <strong>Excel Options<\/strong> dialogue box.<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-5939 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-1.png\" alt=\"Turn on AutoSave in Excel\" width=\"490\" height=\"490\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-1.png 490w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-1-300x300.png 300w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-1-150x150.png 150w\" sizes=\"(max-width: 490px) 100vw, 490px\" \/><\/p>\n<p><strong>Step 2: <\/strong>Click on <strong>Save<\/strong>. To turn on AutoRecover, check <strong>Save AutoRecover information every <\/strong>box. This will enable the <strong>AutoRecover <\/strong>option. By default, the time is set to 10 minutes, but you can change it to your preference. For safety purposes of your precious work, also check <strong>Keep the last AutoRecovered version if I close without saving <\/strong>box. In case your app crashes, when you will open the file again Excel will show you the option to\u00a0<a href=\"about:blank\">auto-recover any unsaved files\/data<\/a> if this option is enabled. When all these are done, press OK.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-5940 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-2.png\" alt=\"Turn on AutoSave in Excel\" width=\"576\" height=\"476\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-2.png 576w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-2-300x248.png 300w\" sizes=\"(max-width: 576px) 100vw, 576px\" \/><\/p>\n<p><strong>Step 3: <\/strong>You can also open the <strong>Excel Options<\/strong> dialogue box from <strong>File&gt;&gt;Options.<\/strong><\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-5941 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-3.png\" alt=\"Turn on AutoSave in Excel\" width=\"569\" height=\"220\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-3.png 569w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-3-300x116.png 300w\" sizes=\"(max-width: 569px) 100vw, 569px\" \/><\/p>\n<h2><strong id=\"turn-on-autosave-in-excel-365\">4. Turn On AutoSave in Excel 365 <\/strong><\/h2>\n<p><strong>Step 1: <\/strong>Just like enabling AutoRecover, right click on<strong> QAT<\/strong> and choose <strong>More Commands.<\/strong> Then go to <strong>Save<\/strong> tab and check <strong>AutoSave OneDrive and SharePoint Online files by default on Excel<\/strong> box, click OK. This will turn on<strong> AutoSave<\/strong> in your Excel 365.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5942 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-4.png\" alt=\"Turn on AutoSave in Excel\" width=\"577\" height=\"474\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-4.png 577w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-4-300x246.png 300w\" sizes=\"(max-width: 577px) 100vw, 577px\" \/><\/p>\n<h2><strong id=\"adding-autosave-to-qat-in-excel-365\">5. Adding AutoSave to QAT for Office 365<\/strong><\/h2>\n<p><strong>Step 1: <\/strong>If the AutoSave option is not displaying in your QAT by default, you can add it manually from Excel Options dialogue box. Simply click on the QAT button and choose <strong>More Commands<\/strong> option from the drop-down list.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5943 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-5.png\" alt=\"Turn on AutoSave in Excel\" width=\"404\" height=\"498\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-5.png 404w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-5-243x300.png 243w\" sizes=\"(max-width: 404px) 100vw, 404px\" \/><\/p>\n<p><strong>Step 2: <\/strong>This will open the <strong>Excel Options<\/strong> dialogue box. Select <strong>Quick Access Toolbar<\/strong> tab and choose <strong>Popular Commands<\/strong> in the left-hand side box. Scroll down and select <strong>Turn AutoSave On\/Off<\/strong>, then press the <strong>Add&gt;&gt;<\/strong> button to add this option into the right-hand side box. Now press OK.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5944 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-6.png\" alt=\"Turn on AutoSave in Excel\" width=\"577\" height=\"474\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-6.png 577w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-6-300x246.png 300w\" sizes=\"(max-width: 577px) 100vw, 577px\" \/><\/p>\n<p><strong>Step 3: <\/strong>Done, the <strong>AutoSave <\/strong>option is added in the <strong>QAT<\/strong> area. Now you can turn it on and off with one click.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5945 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-7.png\" alt=\"Turn on AutoSave in Excel\" width=\"479\" height=\"239\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-7.png 479w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-7-300x150.png 300w\" sizes=\"(max-width: 479px) 100vw, 479px\" \/><\/p>\n<h2><strong id=\"how-to-restore-unsaved-excel-files?\">6. How to Restore Unsaved Excel Files?<\/strong><\/h2>\n<p><strong>Step 1: <\/strong>Click on <strong>File<\/strong> and then <strong>Open. <\/strong>Select <strong>Recover Unsaved Workbooks<\/strong> option.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5946 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-8.png\" alt=\"Turn on AutoSave in Excel\" width=\"452\" height=\"457\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-8.png 452w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-8-297x300.png 297w\" sizes=\"(max-width: 452px) 100vw, 452px\" \/><\/p>\n<p><strong>Step 2: <\/strong>This will open the folder where all the unsaved files are stored. Select the file you want and press OK. This will open the file in your Excel. Now you can save it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5947 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-9.png\" alt=\"Turn on AutoSave in Excel\" width=\"576\" height=\"330\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-9.png 576w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-9-300x172.png 300w\" sizes=\"(max-width: 576px) 100vw, 576px\" \/><\/p>\n<h2><strong id=\"automatically-save-file-before-closing-using-vba\">7. Automatically Save File Before Closing using VBA<\/strong><\/h2>\n<p><strong>Step 1: <\/strong>Right click on the worksheet name and choose <strong>View Code.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5948 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-10.png\" alt=\"Turn on AutoSave in Excel\" width=\"393\" height=\"341\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-10.png 393w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-10-300x260.png 300w\" sizes=\"(max-width: 393px) 100vw, 393px\" \/><\/p>\n<p><strong>Step 2: <\/strong>Click on <strong>View <\/strong>tab then select<strong> Project Explorer.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5949 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-11.png\" alt=\"Turn on AutoSave in Excel\" width=\"572\" height=\"452\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-11.png 572w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-11-300x237.png 300w\" sizes=\"(max-width: 572px) 100vw, 572px\" \/><\/p>\n<p><strong>Step 3: <\/strong>Double click on <strong>ThisWorkbook <\/strong>option and it will open this workbook Code window. Insert the below given code inside the window and close it. Now, it will run this code whenever a modification is made to the worksheet and you close it without saving. This code will save it, and then close it.<\/p>\n<p><strong>Private Sub Workbook_BeforeClose(Cancel As Boolean)<\/strong><\/p>\n<p><strong>ThisWorkbook.Save<\/strong><\/p>\n<p><strong>End Sub<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5950 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-12.png\" alt=\"Turn on AutoSave in Excel\" width=\"578\" height=\"241\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-12.png 578w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/04\/Turn-on-Autosave-12-300x125.png 300w\" sizes=\"(max-width: 578px) 100vw, 578px\" \/><\/p>\n<h2><strong id=\"some-basic-questions-&amp;-issues-with-autosave\">8. Some Basic Questions &amp; Issues with AutoSave<\/strong><\/h2>\n<ul>\n<li><strong>Why can&#8217;t I turn on AutoSave in Excel?<\/strong><\/li>\n<\/ul>\n<p>For some files, particularly large files or files stored on SharePoint, the AutoSave settings might not work. You can re-check the AutoSave box by selecting &#8220;<strong>File &gt; Options &gt; Save<\/strong>.&#8221;<\/p>\n<ul>\n<li><strong>How to Change AutoSave Location in Excel?<\/strong><\/li>\n<\/ul>\n<p>Go to <strong>Files&gt;&gt;Options&gt;&gt;Save<\/strong> then change the AutoSave location from there.<\/p>\n<h2>Application of Turn on AutoSave in Excel<\/h2>\n<ul>\n<li><strong>Continuous Saving<\/strong>: Automatically save changes made to Excel files at regular intervals by turning on AutoSave, ensuring that your work is consistently saved without manual intervention.<\/li>\n<li><strong>Preventing Data Loss<\/strong>: Minimize the risk of losing unsaved changes or data due to unexpected interruptions, such as power outages or system crashes, by enabling AutoSave in Excel.<\/li>\n<li><strong>Collaboration<\/strong>: Facilitate real-time collaboration on Excel files by ensuring that all edits are automatically saved and synchronized across multiple users, enhancing teamwork efficiency.<\/li>\n<li><strong>Workflow Efficiency<\/strong>: Streamline your workflow and reduce interruptions by allowing AutoSave to handle the saving process, freeing up time for focus on tasks at hand.<\/li>\n<li><strong>Document Recovery<\/strong>: Enable AutoSave to automatically create backup versions of your Excel files, providing additional recovery options in case of accidental deletions or modifications.<\/li>\n<li><strong>Version Control<\/strong>: Maintain a history of changes made to Excel files by utilizing AutoSave, enabling easy access to previous versions for auditing, tracking, or reverting purposes.<\/li>\n<\/ul>\n<p><strong>For ready-to-use Dashboard Templates:<\/strong><\/p>\n<ol>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Finance\" target=\"_blank\" rel=\"noopener\">Financial Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Sales\" target=\"_blank\" rel=\"noopener\">Sales Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Human-Resource\" target=\"_blank\" rel=\"noopener\">HR Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.executiveknowledge.org\/dashboard-templates\/35\" target=\"_blank\" rel=\"noopener\">Data Visualization Charts<\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Turn on AutoSave in Excel to safeguard your work and prevent data loss with every edit. By enabling AutoSave, you ensure that your Excel files are automatically saved at regular intervals, minimizing the risk of losing unsaved changes due to unexpected interruptions or system crashes. Say goodbye to the anxiety of forgetting to save your &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.bizinfograph.com\/resource\/how-to-turn-on-autosave-in-excel\/\"> <span class=\"screen-reader-text\">How to Turn on AutoSave in Excel?<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","footnotes":""},"categories":[654],"tags":[656,655],"class_list":["post-5938","post","type-post","status-publish","format-standard","hentry","category-turn-on-autosave-in-excel","tag-turn-on-autosave","tag-turn-on-autosave-in-excel"],"_links":{"self":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/5938","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/comments?post=5938"}],"version-history":[{"count":5,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/5938\/revisions"}],"predecessor-version":[{"id":9238,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/5938\/revisions\/9238"}],"wp:attachment":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/media?parent=5938"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/categories?post=5938"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/tags?post=5938"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}