AutoSave Master Switch rather than an "I Told YOu So!" later
Microsoft has added a new feature to help users co-author files. Whether you are for or against this feature is not my point here: it needs Excel's AutoSave switched on to work. That's fine. But it shouldn't be the default. It is accepted that Office is trying to make various apps consistent, but Excel is used differently. What makes it the most popular software in the world is the ability to experiment without consequences.
Made a mistake? No fear, close without saving and re-open. Accidentally delete a sheet? Don't worry, close without saving and re-open. Replaced all formulae with =RAND()? Etc etc.
For those working in the Cloud, yes you can restore earlier versions - when it works. But many don't. And some can't (no internet, company policies, etc.).
What does the new setting mean? Make a mistake? You're stuffed. Fed up of re-doing files? Tough. Where is my earlier version of Excel? I will go back to it and to heck with Office 365. Yes, AutoSave as default is going to hurt people. Including Microsoft's strategies to adopt O365.
Please vote for this. All I want is a master switch where the default setting for AutoSave is off, so if things go wrong, you only have yourselves to blame. It's not asking too much, is it..?
Don't come here and vote when you have realised it's a good idea, do it now so you don't pay the consequences. Please... For all our sakes!!
We have been listening to your feedback and are updating AutoSave with the ability to turn AutoSave off if desired. There are three patterns in this feedback thread that we are addressing now. The first pattern is that you want AutoSave off because you make temporary edits or hypothetical edits that you don’t want to save (we call this what-if analysis). The second pattern is that you start a new file from an existing file after making some changes to the existing file (like a Template or Invoice). The third is that sometimes the “Last Modified” timestamps are changing even when no edits were made.
In response to the feedback about a desire for AutoSave to be off by default due to temporary or hypothetical edits (what-if), we have added some new functionality and options for AutoSave:
1. You can turn AutoSave off for a specific file. While a document is open, clicking the AutoSave toggle disables AutoSave for the current document for that user. The next time the same user opens the document, AutoSave will be off. If they open a different document, AutoSave will not be affected by their choice in the other document.
2. To avoid accidental edits by others, the owner of a file can set it to Always Open Read-Only. This can be done by setting the file to open in Read-Only Recommended (File > Info > Protect Document/ Workbook/ Presentation > Always Open in Read-Only) or by Sharing the file without allowing others to edit (File > Share > People with the link can edit > Uncheck the “Allow Editing” box).
3. You can set AutoSave to be off by default for all files opened in that specific application (Word, Excel, PowerPoint) on that device. Go into File > Options > Save and uncheck the “AutoSave OneDrive and SharePoint Online files by default on Excel”
All of these solutions are described in more detail in this support article: support.office.com/en-us/article/what-it-ad..
In response to the feedback about Templates and Invoices, we are releasing a new dialog reminding you to “Save a Copy” prior to using an existing template if you want to save changes only in the new document.
To address the issue with last modified information changing unexpectedly, we have made some changes in how we determine if a file should be saved when it is opened. In all cases where a file isn’t edited or only “view” changes are made (such as changing selection or active sheet), no save will happen and the Last Modified fields will not change. We now also will not trigger AutoSave for some features that edit the file one open (such as volatile functions). We are still looking into other ways the timestamp changes to see if there are other places where we may be inadvertently updating it, so please let us know if you see any cases we missed.
You can also learn more about AutoSave in general and how to use it in this support article: support.office.com/en-us/article/what-is-au..
Let us know if you have any questions or comments on these changes or for AutoSave in general.
Excel Program Manager
+1 Re: "What does the new setting mean? Make a mistake? You're stuffed."
This has to fall into the "what were they thinking?" category. You would think just once they would ask their users first. Keep in mind Undo not available when working in VBA.
Aaron Margosis commented
+1 on at least offering a way to disable AutoSave by default rather than on a per-document basis. I like to open saved spreadsheets, select one of several tabs, apply filters to find the information I'm looking for, then close the spreadsheet and not save the changes. With AutoSave enabled, I never get the "save" prompt and end up writing changes back. It's different with Word and PowerPoint, because searching for information doesn't change the file
Michael Oloishuro commented
Kindly consider reversing this idea. Ability to undo changes has been great, and expecially due to the fact that many people make mistakes and would like to save time in the available option to revert to previos version.
Ed Hansberry commented
The problem is without AutoSave is it locks the file I believe because it is no longer in constant communication with the server.
- restore an older file from office 365 - this only work in Office 365 where Sharepoint constantly makes backups, so just get yesterday's file, or this morning's file.
- Excel has an absurd number of UNDO levels. Undo doesn't undo everything (sheet deletion for example) but it undoes quite a few bits of experimentation
- it is a bright green "on" button in the QAT. Easy to see and turn off. I have it off for 2-3 files, but leave it on for most.
I think it is going to be hard to argue that Excel AutoSave should work differently than PowerPoint/Word AutoSave. I certianly don't want to have to train my users to turn AS "on" in Excel but not worry about it in PPT and Word. The end result is, they will never turn it on, which will impact the overall experience for our company.
Maybe MS could consider a "Don't enable AS by default when I am in a file" that turns it off when you, a power user, opens it, and turns it back on when you close it. You could always turn it on during a session to collaborate.
Almir Jorge commented
Sou contrário a proposta.
Wyn Hopkins commented
This would be crazy, collaboration, while fantastic, will be niche and applicable to a small % of users. One thing that completely un-nerves me about Excel online is autosave. I'd love to be able to turn it off when required.
Please don't make this a default setting in Excel Desktop
I wonder how VBA save routines would be affected?
Não a função.
Pedro HSA commented
Eu quero dizer que esta função é desnecessárias devido as simulações que temos que fazer, pois no meu caso eu trabalho com cronogramas e preciso fazer simulações e isso vai atrapalhar os trabalhos que nós planejadores fazemos constantemente
Eu quero dizer que esta função é desnecessárias devido as simulações que temos que fazer, pois no meu caso eu trabalho com cronogramas e preciso fazer simulações e isso vai atrapalhar os trabalhos que nós planejadores fazemos constantimente>