We have an excel spreadsheet that is used by several users on a shared drive.
When anybody opens the file, it would be quite useful if the file could force their system to automatically turn Autosave on as it opens. Then when the file is closed, it should return their version of Excel to the previous setting (which it will presumably have to remember during the edit) so that it does not auto-save every subsequent file opened. Can this be done and if so how
When anybody opens the file, it would be quite useful if the file could force their system to automatically turn Autosave on as it opens. Then when the file is closed, it should return their version of Excel to the previous setting (which it will presumably have to remember during the edit) so that it does not auto-save every subsequent file opened. Can this be done and if so how