#How to turn on autosave in excel 365 code#

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.

#How to turn on autosave in excel 365 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. 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.