This also creates an issue if you regularly open an existing workbook, make changes, and then Save As to save the file with a new name. You can hover above any cell to see who is editing that cell. In Figure 2, I’m editing cell A1 and someone else is editing C2. Excel will use various color cell outlines to show who is editing each cell. With multiple people working in the same file, this is great news. Co-Authoring works by saving your workbook to the server after every change. With AutoSave, that option is no longer possible. Without Undo available, closing the file without saving isn’t an option. And if you regularly run macros, you’ll find that Undo is not available to reverse any changes caused by the macro. Rather than trying to step back through Undo using Ctrl+Z or Alt+Backspace, it’s easier to simply close the file without saving. Or I delete a worksheet and then discover a horde of #REF! errors appear. Other times, I might inadvertently wipe out formulas by copying instead of cutting before a paste. I might open a file and change a few numbers to see the results-knowing that I plan to click “Don’t Save” when Excel asks if I want to save changes (see Figure 1). I regularly open Excel files with no intention of ever saving them. This feature is going to cause far more headaches. In order to introduce Co-Authoring, Microsoft also had to add a feature called AutoSave. For those cases where multiple people have to access the same workbook at the same time, Co-Authoring is a welcome addition. Their solution, which they call Co-Authoring, is now rolling out to Office 365 Subscribers. The Excel team has been working on a better solution. If turned on file sharing, you were prevented a number of key actions, including inserting rows or pivot tables. The former solution, Shared Workbooks, wasn’t practical. Then everyone else was locked out of the file needlessly. This often worked, until one coworker forgot to close the file and left for a long lunch break. One person would open the workbook for editing, and everyone else was forced into read-only mode. Accounting departments would handle this by taking turns. Until now, only one person could edit a workbook at a time.
#Check office auto save location update#
To get the update immediately, open any Office 2016 app and choose File > Account > Update Options > Update Now. This issue is now fixed in Version 1708 (Build 8431.2094). This issue impacts the Office 2016 August 2017 update, Version 1708 (Build 8431.2079) and later. Save to OneDrive or SharePoint Online if you want to use AutoSave. This file location doesn't support AutoSave.
Hovering over the AutoSave toggle, the tool tip will prompt you with the following message:ĪutoSave Not Available. I'm still looking into this.ĪutoSave is disabled for OneDrive, OneDrive for Business, and SharePoint locationsĪfter opening a file saved in OneDrive, OneDrive for Business, or SharePoint that is synced using a sync client, you may experience that the AutoSave is incorrectly disabled or greyed out. I have checked our build versions and though they're not the same, autosave is now disabled which is great news for us.
There is however some info i found in Excel help that talks about the build versions. So you might want to check the bit version and excel version. So we had to move the files back to disk (SAN) storage where its disabled.
We dont want autosave in my organisation, because when finance team work collaboratively they dont want to autosave every little thing they do. Autosave (for Excel) i think might be enabled only for 64-bit versions, and is automatically enabled for spreadsheets (xslx files only older versions of Excel arent affected) saved in OneDrive/SharePoint online.