how to use autosave in excel 2016

davidmyers

Board Regular
Joined
Jan 29, 2017
Messages
88
Office Version
  1. 2016
Platform
  1. Windows
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
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Hi DRSteele, Thanks for this, what bothers me is where they say:

"[FONT=&quot]AutoSave is enabled when a file is stored on OneDrive, OneDrive for Business, or SharePoint Online[/FONT]"

So how do I enable AutoSave to save to the local file system on my laptop?
 
Upvote 0
Obviously you cannot "...enable AutoSave to save to the local file system."

Someone (aside from me) might be able to write a bit of VBA code to save the file every 3 minutes, but Autosave is clearly reserved for cloud-computing.
 
Last edited:
Upvote 0
Hi,
Don't understand why
Obviously you cannot
autosave to a local file system. Excel is working on my pc, so want to autosave to my pc - not the cloud - why do I need an internet connection?.
 
Upvote 0
Look, Autosave only works with files stored on the cloud.
 
Upvote 0
You're welcome.

It strikes me too that Autosave might be a nice feature for local file systems. If you feel strongly enough, make your opinion known; go here, sign up for an account, and write a suggestion.
https://excel.uservoice.com/forums/...op-application/filters/top?category_id=143394

An Autosave discussion has already been initiated about a different topic that is annoying many users - you can vote for the idea and write an opinion, if you like.
https://excel.uservoice.com/forums/...ion/suggestions/31049020-options-for-autosave
Even Bill Jelen is infuriated by Autosave, as he demonstrates in this video. https://www.youtube.com/watch?v=gwwCI7sbBPA&t=1s
 
Last edited:
Upvote 0
Thanks for letting me know your views on this, thought I was missing something.
I guess it's a policy decision to tie people to onedrive.
I'll look into your earlier suggestion to add some code to Autosave.

David
 
Upvote 0

Forum statistics

Threads
1,223,098
Messages
6,170,099
Members
452,301
Latest member
QualityAssurance

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top