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...
Did you ever get a good (and safe) solution to the new AutoSave issue that came in with the new Excel? Same problem as we also follow the same process of opening a file and editing it a) to see what the results are and b) maybe saving it as a different version. Thx in advance! Chris
- Thanks! We've just turned autosave off (which is turning off some good functionality) but now Excel/'One Drive' no longer unilaterally decides to save our documents...
The method you (and we) use to load a spreadsheet and perform changes before we decide whether of not to actually save this version appears to be such a common approach in business that I can't understand why this wasn't spotted earlier..,, Thanks again! C- Yeah, I think users will need some training how this works! Your workflow might be a little different..