Enable collaboration with others editting in Excel desktop
In Word and PowerPoint you can collaborate from the desktop as well as online. In excel, whenever anyone opens the document on desktop others get locked out of editing and can only view. This is a problem for our organisation since occasionally remote team members need to edit the file on desktop but failure to close down the document properly (either accidentally or because the OS somehow did not release the file lock which has happened on Mac's) means the entire team is suddenly unable to work for extended periods until we track down the culprit.
Collaborating in Excel has been available for current channel users, starting with version 1707 and version 1808 for Semi-Annual users
Note: This feature is only available if you have an Office 365 subscription
If you are an Office 365 subscriber, make sure you have the latest version of Office.
Zsombor Fritz commented
Why don't you close this item if it's done?
Lina Molina commented
Thanks! However, I cant use this feature as the company I'm working for does not use onedrive or sharepoint :-(
Hi, we tried to use collaboration of Excel file in the desktop app in combination with the file stored on OneDrive for Business. However this is very unreliable. Many times we experienced already the file was saved with an older version, so loosing changes made that day. It looks like it is happening when OneDrive hasn't completly synced yet and another users changes the file in the meantime. There are no pop-ups which inform us of the older versions set back. So this makes it very unreliable and makes us to stop using OneDrive. Do you know this problem?
Scott it would be great if Microsoft opened the API's to allow this collaboration in other cloud services like DropBox and Box - Is there any reason that has not/might not happen?
Hello - will this be avaialble for workbooks using get and transform? when pulling data from external sources and using power query the coauthoring feature doesnt seem to be an option.
Just doesn't work well. users are constantly getting "disconnected", only allowing them to save as a copy.
Craig Ferguson commented
I think it's just a fancy feature and forcing your users to use the "cloud" - I don't want to, our users don't want to. We just want a locally saved document that does not need to be opened in a browser and that can be shared with everyone - which includes tables.
I want to use Excel desktop with co authoring, a simple request but it appears to be a massive headache for Microsoft for some strange reason.
@eric Johnson, the reason it requires the cloud is a TON of work is being done by the server, not the Excel clients.
Brian Campbell commented
I don't believe there is. With the updated version of Office 2016 (c2r) the ability to use the legacy "shared workbook" with the file located on the LAN has been removed (as far as I can see). This has forced us to move all our "shared workbooks" to sharepoint and remove this legacy feature. If a previous excel file on the lan was configured as a "shared workbook" and a newer version of office 2016 opened the file it would work, but that new office 2016 version could not create a new excel file and share it in the legacy way.
I really wanted the co-authoring that we are using now, but I was unaware that it was an "either or" feature. As it stands I now have any multi-user accessed excel files on sharepoint and many more single user excel files still on a traditional file share.
Eric Johnson commented
Problem is that co-authoring requires cloud. Is there any way to co-author Excel files stored on a local network. We are still using the old style document sharing. Co-authoring would be a good feature but it is not usable for LAN based files not for very large files that can't use cloud services or for users without internet connectivity.
@anonymous - it depends. If you are in the semi-annual (targeted) channel, you'll get an update in March that should have it.
If you are in the semi-annual channel (i.e. non-targeted) you won't see it until July.
See https://docs.microsoft.com/en-us/deployoffice/overview-of-update-channels-for-office-365-proplus for more info on when each channel gets the new goodies.
when will this make its way to Semi-Annual channels
@caleb - this has been available to the Monthly Targeted channel (formerly insider slow) for at least 3 months. I am not sure if it is on the deferred channel yet.
Insider Fast has had it since February.
has this come out of the insider channel yet? When will it be in the standard release channel?
Looking forward to actually being able to use this (Semi-annual Channel (Targeted)).
Isaac Chua commented
The number of votes resulting from disabling the AutoSave feature for this purpose has far exceeded this one:
This is an extremely destructive feature. Please look into a kill switch for this feature immediately.
James Ward commented
This is great!
However, be wary in a split environment it has a tendency to break Excel workbooks when you're accidentally coauthoring on a document someone else is working on with a 'current' version of Excel.
Would be good to be able to disable this with a switch in the top right of the window when you know you're on a doc that others might be working on.
Agree with Robert's earlier comment - personal filtering would be a great improvement.
Robert Barker commented
When will co-author users be able to apply their own personal filters? Right now, if you apply a filter, the other co-authors view of the spreadsheet changes to reflect that filter settings.
We'll Excel Help, since the MS Sharepoint/OneDrive servers are doing A LOT of the work to make collaboration in Excel possible, leaving it on your network won't help. We moved all of our files to OneDrive any teams which uses sharepoint for files. We have collaboration, file versioning, and no worries on backups.
And we like to think of ourselves as normal people.