Options for AutoSave
The AutoSave function is a great idea!!
Just not in practice...
In my business we re-use the same invoices made in excel for the same jobs, however save them as a new file each time in order to keep a record of the previous invoice.
The new AutoSave feature is extremely dangerous in this regard.
If I, or someone else, does not remember to turn off AutoSave, or save as a new file BEFORE making new changes, we LOSE our previous invoice.
Have options for AutoSave, the most important one being, DEFAULT OFF rather than default on.
Thank you all for your feedback regarding the new AutoSave functionality in Excel.
We’ve been working to better enable collaboration and AutoSave is a key component that. While it can take some getting used to, AutoSave helps users feel confident that their work is being saved. This is especially evident when working with other people, but it also helps when you’re working by yourself.
We understand that you may need to turn off AutoSave for some workflows, so we are excited to announce that it is now possible to turn off AutoSave for a particular file as well as to change whether AutoSave is or or not by default.
For instructions on how to do this please see here: https://support.office.com/en-gb/article/what-is-autosave-6d6bd723-ebfd-4e40-b5f6-ae6e8088f7a5#OfficeVersion=Windows
This functionality is currently available to O365 subscribers.
We hope you continue to leave feedback on Excel to help us improve.
Excel Program Manager
James Sturms commented
You can turn it off now.
Autosave is trash and no one wants it. Using templates in the workplace just became 10x less efficient. When I turn off autosave, I expect it to turn off autosave so maybe start there before removing the feature entirely.
For me, the autosave is an extremely important feature but I understand the problem you have. Instead of removing it, it would be much better to be optional and / or modifiable to suit the end user's needs, perhaps even for each file separately. In my case, I want autosave to be on by default but there are a few files where automatic / persistent autosave would be dangerous.
yes... i agree
Yes!! Please do this I hate it. It keeps toggling back on.
I want it off permanently for everything!!!
and allow local autosave instead of forcing users to use Microsoft cloud services
and allow the use of local auto save AND other cloud providers.
This shouldn't be restricted to Microsoft cloud services.
Bruno Eberle commented
I'm frequently using saved files as templates. With the new AutoSave function my old files get overwritten as soon as I start editing the file. I have to save the new one immediately with another name otherwise I'll loose the old one. This is annoying.
Pleas allow to deactivate AutoSave function in the Option settings.
Krause Wilson commented
This is a terrible feature to have turned on by default. disallows sorting by date if you open a file just to read it. Please allow the default to be set to "off".
The history of our Excel and Word documents is critical and 70% of the time we frequently create a new document from a previous one because it saves a lot of time. Invoicing, project budgets, modifying procedure templates for different customers.
We use excel for what if? scenarios also. I really don't want to have to save for the multiple data value scenarios I'm testing. Right now I change a couple of values, look at the summary data, move to the next change etc, it takes 5 mins to evaluate. Saving separately and then having to go back and delete is a time waster.
Please separate the recovery back-up and autosave features. I need the recovery feature for crashes, power outages, sorts that have gone drastically wrong etc. Right now I have autosave turned off and no recovery or previous versions are available. Very scary.
I think this is done and fixed, right? (Thank you!!) Should Microsoft close it?
Hi Microsoft Excel team,
I'm pleased to see the new prompt!
That's definitely a step in the right direction to maintaining the usability of the function while also giving users a chance return the document to how it previously was.
Andrew Hunkins commented
Just FYI, I'm now seeing an option to turn autosave off by default. Under Options -> Save, it's the very first check box.
Donall Quinn commented
I totally agree. I regularly open files where I want to perform what if scenarios and then close the file without saving. Now, if I don't remember to turn off AutoSave, my changes are saved and I have to spend more time undoing all my changes and saving again. I've been using Excel for over 30 years (since v2.0) and this has got to be the absolutely worst implemented new feature I've ever seen - bar none. Forcing people to change the way they have worked for years without putting in a setting to enable to turn off the feature is total madness. Either let users turn it off by default or get rid of it NOW!
Jeff H commented
I think a good idea here is to have a separate meta field to handle dates. Not sure how to implement this. But agree, even changing the sort fields automatically changes the last saved date on a file which messes with locating last changed files.
I find listening to politics in 2018 more pleasant than coping with autosave on excel. I loathe it.
Hi Microsoft Excel team,
One solution to this issue is to provide a prompt when closing a spreadsheet (that was changed since opening it in that instance) to remind the user that AutoSave occurred with the option to 'click here' to revert to what it was when the user first opened it.
Maybe there'd be an tick box option to not receive that prompt anymore so users can make AutoSave seamless, if that's what they want.
Another thought is a date limit to give a prompt. If I open something that hasn't been changed in over a month, there's a good chance I'm going to want to leave it the way it is (like what some of the other comments are saying templates, legacy invoices, etc.)
Perhaps there could be an option within the settings that allows this date range to be adjusted.
Whether the suggestions above make sense or not, I feel strongly that the current way should change: it can be very counter-productive.
YES, YES, YES. Has cost countless hours and LOST DATA. Horrible idea.
The other comments here have said it well. Most important for me: at least give an option to change the default and make sure it applies to all documents I create, so if someone else opens my file, it doesn't instantly change the last-modified date. I think this also means you need a Default Off per Excel user (and perhaps stored locally for the computer -- a user might want different defaults on different computers) and for each file. If EITHER of them is Off, set AutoSave to off for that user on that file. Only turn on AutoSave if both user and file have their AutoSave option turned on.
Please give the option for AutoSave to be off as default in Word and Excel. If I want to use a file as a template I lose the template when I edit it.