How to turn on autosave in microsoft excel 16.11.1

#HOW TO TURN ON AUTOSAVE IN MICROSOFT EXCEL 16.11.1 CODE#

For me AutoSave is not only counter-productive, itвЂ™s downright dangerous. IвЂ™m moving all my spreadsheets outside of OneDrive and SharePoint. I also saw a similar key autosavebydefaultuserchoice but again, that doesnвЂ™t seem to work.

Instead thereвЂ™s autosavebydefaultadminchoice but that doesnвЂ™t work for me either. I hate it! The key DontAutoSave mentioned above has apparently now been deprecated so doesnвЂ™t work on newer updates to Office. At the end IвЂ™ve lost all info relating to Customer A, and each file IвЂ™ve saved actually has details for the next customer with the last customerвЂ™s details actually being in two files with different names. I then save as Customer B Outstanding Invoices and repeat for Customer C. I then refresh for Customer B but in doing so it overwrites the file вЂњCustomer A Outstanding InvoicesвЂќ with Customer BвЂ™s details and data. I вЂњrefreshвЂќ it for Customer A and Save As вЂњCustomer A Outstanding InvoicesвЂќ вЂ“ it turns AutoSave on. Say I have a file called вЂњCustomer Outstanding InvoicesвЂќ and have AutoSave off. This when mixed with AutoSave and Save As can mean huge problems. I use something called Jet Reports which automatically updates spreadsheet templates with live data from our ERP system, taking into account user-specified parameters. If you donвЂ™t click вЂњsaveвЂќ, you obviously didnвЂ™t want to keep all that work, did you? All theyвЂ™d be doing is applying their needs to your problem. Some users want to be able to edit data then abandon what theyвЂ™ve typed for a safely-saved version. When a file is stored on OneDrive, OneDrive for Business, or SharePoint Online, AutoSave is enabled by default in Microsoft 365.

#HOW TO TURN ON AUTOSAVE IN MICROSOFT EXCEL 16.11.1 CODE#

This would baffle the designer of this feature, because they can only see their own point of view to the exclusion of all others.Дear developers: if youвЂ™re still having trouble understanding what is so annoying about this feature, just imagine that users had a feature to delete your code every time you switched off your PC. Microsoft Office 365 has a feature called AutoSave, which is a function for Microsoft 365 members in Excel, Word, and PowerPoint that saves your content automatically every few seconds while you work. But this article describes the many, many scenarios when that assumption doesnвЂ™t hold true. If you come from the assumption that youвЂ™d never want to lose any data you typed, it would make sense. Because you will invariably find those decisions come from your own blinkered viewpoint. Provide options, donвЂ™t try and make decisions for users. Every time you make a decision for the user, you fail them. Forced Autosave For Everybody is one of those features that I can only image came about because they let one of the more Aspie-prone developers run wild.

How to turn on autosave in microsoft excel 16.11.1