how to use autosave in excel 2016

[davidmyers]

Hi,
Can anyone tell me how to use autosave with excel 2016. I have an excel file on my pc, and would like to autosave any changes back to the local file system where it lives (not the cloud, or onedrive) every 3 minutes.
I need to distribute this file to several people, can I set it up so it will autosave on their pc's?

Any help appreciated.
David

 

[davidmyers]

Just a thought, rather than saving periodically every 10 minutes. It would be alot simpler (and more logical) to save after an event, I for instance have several userforms for creating content for cells on the sheet, so every time i close a userform i could do

ActiveWorkbook.Save

Hope this helps someone

David