{"id":260238,"date":"2021-05-26T17:24:50","date_gmt":"2021-05-26T14:24:50","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-automatically-save-microsoft-excel-files-to-onedrive\/"},"modified":"2021-05-26T17:24:50","modified_gmt":"2021-05-26T14:24:50","slug":"how-to-automatically-save-microsoft-excel-files-to-onedrive","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-automatically-save-microsoft-excel-files-to-onedrive\/","title":{"rendered":"#How to Automatically Save Microsoft Excel Files to OneDrive"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a2ad76ce1b9f\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a2ad76ce1b9f\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-automatically-save-microsoft-excel-files-to-onedrive\/#Automatically_Save_Microsoft_Excel_Workbooks\" >Automatically Save Microsoft Excel Workbooks<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-automatically-save-microsoft-excel-files-to-onedrive\/#Change_Where_Excel_Workbooks_Are_Saved_in_OneDrive\" >Change Where Excel Workbooks Are Saved in OneDrive<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Automatically Save Microsoft Excel Files to OneDrive&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-725718\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/microsoft-excel-logo.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel logo\" width=\"1200\" height=\"555\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Unlike Google Sheets, Microsoft Excel doesn\u2019t enable autosave by default. You can fix that easily as long as you have a Microsoft 365 sub<a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">script<\/a>ion. We\u2019re going to show you how to autosave Microsoft Excel workbooks to OneDrive.<\/p>\n<p>If you keep hitting Control+s (or Command+s on Mac) every few seconds, this method will ensure that you don\u2019t have any unsaved work in your Excel workbooks. It works by automatically saving your workbooks to OneDrive as you keep working on them.<\/p>\n<p>We\u2019ve already mentioned that you need a Microsoft 365 subscription for this, and that means that you have 1TB of OneDrive cloud storage available, too. Go ahead and open the OneDrive app, and follow the onscreen instructions to set it up. This just requires you to log in to OneDrive, and Microsoft will handle the rest.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Automatically_Save_Microsoft_Excel_Workbooks\"><\/span>Automatically Save Microsoft Excel Workbooks<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Now is the time to open Microsoft Excel and fire up a new workbook. Select \u201cFile.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-724656\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/excel-auto-save-click-file.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click File\" width=\"500\" height=\"231\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Click \u201cNew\u201d in the left pane.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-724655\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/excel-auto-save-click-new.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click New\" width=\"500\" height=\"231\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Select \u201cBlank workbook\u201d or any other template from the list. This will open a new Excel workbook.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-724654\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/excel-auto-save-click-blank-workbook.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Blank workbook\" width=\"500\" height=\"231\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Right at the top, you\u2019ll see an option labeled \u201cAutoSave.\u201d Click the toggle next to AutoSave to change it to \u201cOn.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-724653\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/excel-auto-save-click-on.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click the toggle next to AutoSave\" width=\"500\" height=\"231\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll see a pop-up window that asks you where you want to save your workbook. Click \u201cOneDrive.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-724652\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/excel-auto-save-click-onedrive.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click OneDrive\" width=\"500\" height=\"231\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Type the file name and click \u201cOK.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-724651\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/excel-auto-save-click-ok.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click OK\" width=\"500\" height=\"231\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>That\u2019s all you need to do to enable autosave. From here on out, Excel will keep saving any modifications you make to this workbook. You\u2019ll just have to enable autosave once every time you start working on a new Excel workbook, and you won\u2019t need to save it again. You should note that you\u2019ll need an internet connection for autosave to work correctly and sync these workbooks across devices.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-724650\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/excel-auto-save-enabled.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"A pop-up that confirms that your workbooks are being automatically saved\" width=\"500\" height=\"231\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p><strong>RELATED:<\/strong> <strong><em>What Your Function Keys Do In Microsoft Excel<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Change_Where_Excel_Workbooks_Are_Saved_in_OneDrive\"><\/span>Change Where Excel Workbooks Are Saved in OneDrive<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>By default, Microsoft Excel saves your Excel workbooks in the Documents folder in OneDrive. However, that\u2019s also where all other Office documents will be saved, which can lead to a lot of clutter. For better organization, you should create separate folders for various projects, or at least one folder each for every Office app. Here\u2019s what you need to do.<\/p>\n<p>Open any of your workbooks in Microsoft Excel and click \u201cFile.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-724656\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/excel-auto-save-click-file.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click File\" width=\"500\" height=\"231\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Now, select \u201cSave a Copy\u201d from the left pane.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-724649\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/excel-auto-save-click-save-a-copy.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Save a Copy\" width=\"500\" height=\"231\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Choose \u201cOneDrive.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-724648\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/excel-auto-save-click-save-a-copy-onedrive.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click OneDrive\" width=\"500\" height=\"231\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You have two options for creating new folders. The first method is by clicking \u201cMore options\u201d and adding folders using the Explorer window that pops up.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-724647\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/excel-auto-save-click-more-options.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click More Options...\" width=\"500\" height=\"231\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The second method involves clicking the \u201cNew Folder\u201d button and creating a folder in OneDrive from within Microsoft Excel itself.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-724646\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/excel-auto-save-click-new-folder.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click New Folder\" width=\"500\" height=\"231\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Once you\u2019ve done that, click the folder.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-724645\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/excel-auto-save-select-new-folder.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select the folder where you want to auto save Excel workbooks\" width=\"500\" height=\"231\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Hit \u201cSave.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-724644\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/excel-auto-save-click-save.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Save\" width=\"500\" height=\"231\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>This will take you back to the Excel workbook. You can click the name of your file at the top to quickly check whether it\u2019s saved in the correct folder.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-724643\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/excel-auto-save-check-save-folder-location.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Check the save folder location for Microsoft Excel workbooks\" width=\"500\" height=\"231\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Now that you\u2019ve seen how to autosave Microsoft Excel workbooks, you should also check out the best Microsoft Excel keyboard shortcuts.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>All the Best Microsoft Excel Keyboard Shortcuts<\/em><\/strong><\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/724640\/how-to-auto-save-microsoft-excel-files-to-onedrive\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Automatically Save Microsoft Excel Files to OneDrive&#8221; Unlike Google Sheets, Microsoft Excel doesn\u2019t enable autosave by default. You can fix that easily as long as you have a Microsoft 365 subscription. We\u2019re going to show you how to autosave Microsoft Excel workbooks to OneDrive. If you keep hitting Control+s (or Command+s on Mac)&#8230;<\/p>\n","protected":false},"author":1,"featured_media":260239,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/microsoft-excel-logo.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-260238","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/260238","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=260238"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/260238\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/260239"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=260238"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=260238"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=260238"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}