Excel Windows Client co-authoring

%3CLINGO-SUB%20id%3D%22lingo-sub-188318%22%20slang%3D%22en-US%22%3EExcel%20Windows%20Client%20co-authoring%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-188318%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20everyone%20-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20read%20a%20few%20other%20posts%20on%20this%20topic%2C%20but%20none%20of%20them%20seem%20to%20be%20a%20smoking%20gun%20for%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20co-author%20an%20excel%20document%20with%20other%20members%20of%20my%20team.%26nbsp%3B%20We%20are%20all%20running%20version%26nbsp%3B16.0.8431.2242.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20how%20we%20are%20attempting%3A%3C%2FP%3E%3CP%3E1.%26nbsp%3B%20We%20have%20an%20excel%20document%20that%20is%20part%20of%20an%20Office%20365%20Group.%3C%2FP%3E%3CP%3E2.%26nbsp%3B%20The%20O365%20group%20is%20synced%20to%20our%20machine%20using%20OneDrive%20for%20Business.%3C%2FP%3E%3CP%3E3.%26nbsp%3B%20The%20excel%20file%20has%20been%20shared%20with%20the%20members%20of%20the%20team.%3C%2FP%3E%3CP%3E4.%26nbsp%3B%20Whenever%20we%20attempt%20to%20get%20more%20than%201%20person%20in%20the%20file%2C%20the%20additional%20authors%20receive%20a%20message%20that%20the%20file%20is%20locked%20for%20editing.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAccording%20to%20what%20I%20have%20been%20reading%2C%20the%20version%20we%20are%20running%20should%20support%20co-authoring%20in%20the%20windows%20client%20app%2C%20correct%3F%26nbsp%3B%20I%20haven't%20seen%20many%20mentions%20of%20attempting%20this%20via%20groups%20%2F%20OFB%20-%20but%20if%20that%20is%20what%20is%20causing%20the%20issue%20-%20how%20should%20we%20be%20doing%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3ESteve%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-188318%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%20Groups%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Apps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOneDrive%20for%20Business%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EProPlus%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-188893%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Windows%20Client%20co-authoring%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-188893%22%20slang%3D%22en-US%22%3E%3CP%3EAnyway%2C%20if%20you%20don't%20upgrade%20Office%20in%20first%20place%2C%20it%20will%20never%20work...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-188892%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Windows%20Client%20co-authoring%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-188892%22%20slang%3D%22en-US%22%3E%3CP%3ESee%20this%20screenshot%20(in%20Italian%2C%20sorry...)%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20358px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F33296i8D7B09FC8555BDBA%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Immagine%20001.jpg%22%20title%3D%22Immagine%20001.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-188888%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Windows%20Client%20co-authoring%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-188888%22%20slang%3D%22en-US%22%3EThank%20you..%20We%20are%20using%20the%20correct%20file%20format.%20Still%20not%20working%3CBR%20%2F%3E%3CBR%20%2F%3EWhat%20is%20the%20correct%20setting%20in%20One%20Drive%3F%20We%20have%20shared%20the%20file%20to%20the%20relevant%20parties%20but%20have%20not%20adjusted%20any%20setting%20in%20One%20Drive%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-188879%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Windows%20Client%20co-authoring%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-188879%22%20slang%3D%22en-US%22%3E%3CP%3EAlso%2C%20be%20aware%20that%2C%20in%20order%20to%20coauthoring%20to%20work%2C%20the%20file%20format%20must%20be%20the%20latest%20one%20(i.e.%20Office%202016%20xlsx)%20and%20the%20relevant%20setting%20in%20OneDrive%20should%20be%20enabled.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-188463%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Windows%20Client%20co-authoring%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-188463%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20for%20the%20input%20-%20I%20was%20unaware%20that%20we%20didn't%20have%20channel%20defined%20in%20our%20configuration.xml%20-%20therefore%20it%20defaults%20to%20Branch%2C%20which%20is%20the%20semi%20annual%20channel.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20now%20downloading%20the%20current%20release%20from%20the%20Monthly%20channel.%26nbsp%3B%20Will%20test%20once%20I%20get%20that%20version%20installed%20and%20report%20back.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3ESteve%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-188429%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Windows%20Client%20co-authoring%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-188429%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20are%20running%20a%20very%20old%20Office%20version...%26nbsp%3B%3C%2FP%3E%3CP%3ECoauthoring%20in%20Excel%20is%20supported%20only%20on%20newer%20versions%2C%20I%20believe%20starting%20with%20Monthly%20Channel%20%3CSPAN%3EVersion%201707%20(Build%208326.2058).%20See%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Fmt465751%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Fmt465751%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EHave%20a%20look%20also%20at%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fcollaborate-on-excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fcollaborate-on-excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Frequent Contributor

Hey everyone -

 

I have read a few other posts on this topic, but none of them seem to be a smoking gun for me.

 

I am trying to co-author an excel document with other members of my team.  We are all running version 16.0.8431.2242.  

 

Here is how we are attempting:

1.  We have an excel document that is part of an Office 365 Group.

2.  The O365 group is synced to our machine using OneDrive for Business.

3.  The excel file has been shared with the members of the team.

4.  Whenever we attempt to get more than 1 person in the file, the additional authors receive a message that the file is locked for editing.

 

According to what I have been reading, the version we are running should support co-authoring in the windows client app, correct?  I haven't seen many mentions of attempting this via groups / OFB - but if that is what is causing the issue - how should we be doing this?

 

Thanks

Steve

6 Replies

You are running a very old Office version... 

Coauthoring in Excel is supported only on newer versions, I believe starting with Monthly Channel Version 1707 (Build 8326.2058). See https://technet.microsoft.com/en-us/mt465751

Have a look also at https://support.office.com/en-us/article/collaborate-on-excel-workbooks-at-the-same-time-with-co-aut...

Thank you for the input - I was unaware that we didn't have channel defined in our configuration.xml - therefore it defaults to Branch, which is the semi annual channel.  

 

We are now downloading the current release from the Monthly channel.  Will test once I get that version installed and report back.  

 

Thanks

Steve

 

 

Also, be aware that, in order to coauthoring to work, the file format must be the latest one (i.e. Office 2016 xlsx) and the relevant setting in OneDrive should be enabled.

Thank you.. We are using the correct file format. Still not working

What is the correct setting in One Drive? We have shared the file to the relevant parties but have not adjusted any setting in One Drive

See this screenshot (in Italian, sorry...):

 

Immagine 001.jpg

Anyway, if you don't upgrade Office in first place, it will never work...