Excel 2020: AutoSave is Necessary, But Turn it Off When Not Co-Authoring - KING OF EXCEL

KING OF EXCEL

KINGEXCEL.INFO ( KING OF EXCEL ) Welcome KINGEXCEL.INFO - Nothing Is Unable ... About Excel Tricks, Learning VBA Programming, Dedicated Software, Accounting, Living Skills ...

Saturday, March 14, 2020

Excel 2020: AutoSave is Necessary, But Turn it Off When Not Co-Authoring

Excel 2020: AutoSave is Necessary, But Turn it Off When Not Co-Authoring

AutoSave is Necessary, But Turn it Off When Not Co-Authoring. Photo Credit: Frank Okay at Unsplash.com
But let's talk about workbooks that will never be used with co-authoring. These are the run-of-the-mill workbooks that I use 99.9% of the time. I do not want AutoSave to be active for those workbooks. I want to open Excel, know that I can do some "what-if" changes and then close the workbook without saving. If AutoSave is on, those changes are automatically saved. It is terrible.
Or - you likely recognize the scenario: You have a report for January. You need a report for February. You open the January report, change the headings, and then do File, Save As to save for February. This workflow has been fine for decades. But if you allow AutoSave to be on, you will be destroying the January report as soon as you edit A1 and type February over January.
You have four choices. 
  1. Change your workflow to do the Save a Copy before you make any edits. 
  2. Always save to a local drive and AutoSave will not automatically be enabled. 
  3. Toggle AutoSave off for each workbook. Click the "On" icon shown here to turn AutoSave off for the current workbook.
The first icon in the Quick Access Toolbar is AutoSave, with a toggle switch. By default, the setting is "On". A tooltip advises you "We Are Automatically Saving Your Changes For You".
The best choice is 4. Go to File, Options, Save, and unselect the choice for AutoSave OneDrive and SharePoint Online Files By Default.
Go to Excel Options and choose Save along the left. Find and turn off the setting for AutoSave OneDrive files and SharePoint Online files by Default in Excel.
#evba #etipfree #eama #kingexcel
📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1

No comments:

Post a Comment