Forum Discussion
Solved
AutoSave feature causing frustration
As an independent financial modeller, I work on Microsoft One Drive as it ensures that my work is automatically backed up. This worked well for me until the new Excel AutoSave feature was enabled.
...
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...
Set the document as read only or final? Also toggling the auto save button to off makes it open in off mode next time
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
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..