Forum Discussion
AutoSave feature causing frustration
HI Marli van Staden.
First of all, before editing the registry be EXTREMELY careful!
If you make a mistake you can render the machine unusable.
(You should also make a backup of the registry before modifying it.)
All this said, if you want to try, you have to ADD the "DontAutoSave" key inside "HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel". The key type should be DWORD and its value should be 1.
Also, as an introduction to editing the registry, you can give a look to https://www.howtogeek.com/school/using-windows-admin-tools-like-a-pro/lesson5/
Hope it helps...
Marli van Staden I feel the same frustration. In our office environment it is causing additional confusion as the last person to edit a certain file is also changed which is propagated all throughout O365 (i.e. Delve, SharePoint notifications/subscriptions etc.)
Hi Frank_Dawson ! After I wrote this post, there appears to have been an update to Office 365 which now allows for globally disabling AutoSave for an application. To disable this in Excel, go to File => Options => Save and uncheck the box "Autosave OneDrive and SharePoint Online files by default on Excel". Your colleagues would need to do the same, but hopefully this helps!
There are more problems. We have files online that already existed before this feature was introduced, but where we made sure the "Thisworkbook.autosaveon" flag was set to false. But any new user that opens the file will somehow ignore this feature and it gets turned on again by Excel.
Worse, I experimented with using vba code to programmatically turn off autosave the moment a workbook is opened, but somehow excel manages to already save before the user has had a chance to press the "enable macros" button. >.>
How do I permanently disable this feature for all users accessing my files in SharePoint, not just for myself?
- Hi! Please refer to the following documentation:
https://support.office.com/en-us/article/what-it-administrators-should-know-about-autosave-88e0f80f-e5ea-441b-9c5a-259f08490ae7
Adam
I haven't tried this myself if it works but it seems these regfixes disables Autosave for selected applications:
https://lazyadmin.nl/it/disable-autosave-for-office-365/
Regedits could be pushed via GPO if thats applicable!
Try for one machine!
Not saying I would do it though! I like autosave :)
/ Adam
