SOLVED

Limits to number of co-authors

%3CLINGO-SUB%20id%3D%22lingo-sub-184802%22%20slang%3D%22en-US%22%3ELimits%20to%20number%20of%20co-authors%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-184802%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20any%20published%20information%20regarding%20limits%20to%20co-authoring%20in%20Office%20Online%3F%20I've%20received%20some%20reports%20that%20Excel%20sheets%20were%20nearly%20unusable%20when%20the%20number%20of%20co-authors%20went%20above%2010.%20I've%20personally%20never%20edited%20with%20this%20many%20authors%2C%20but%20I%20can't%20find%20any%20documentation%20with%20any%20hard%20limits%20around%20this.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-184802%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-334481%22%20slang%3D%22en-US%22%3ERe%3A%20Limits%20to%20number%20of%20co-authors%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-334481%22%20slang%3D%22en-US%22%3EDepends%20on%20the%20release%20settings.%20The%20auto%20save%20just%20started%20rolling%20out%20a%20few%20months%20ago%20to%20the%20Semi-Annual%20ring.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-334478%22%20slang%3D%22en-US%22%3ERe%3A%20Limits%20to%20number%20of%20co-authors%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-334478%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E%20good%20to%20know.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20you%20say%20recently..%20ball%20park%20are%20we%20talking%20the%20last%20year%20or%20is%20it%20available%20for%20longer%20than%20that%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-334459%22%20slang%3D%22en-US%22%3ERe%3A%20Limits%20to%20number%20of%20co-authors%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-334459%22%20slang%3D%22en-US%22%3ESync%20client%20is%20irrelevant%20to%20co-authoring.%20The%20problem%20with%20Excel%20usually%20is%20the%20version%20of%20Excel%2C%20it's%20just%20become%20recently%20available%20to%20co-author%20and%20many%20people%20don't%20have%20the%20newer%20version%20to%20do%20so.%20This%20article%20used%20to%20say%20what%20version%2C%20but%20usually%20I%20say%20if%20you%20have%20the%20Auto%20save%20icon%20in%20the%20top%20left%2C%20then%20you%20can%20coauthor%2C%20otherwise%20you%20most%20likely%20need%20to%20update.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%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%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%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%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-334451%22%20slang%3D%22en-US%22%3ERe%3A%20Limits%20to%20number%20of%20co-authors%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-334451%22%20slang%3D%22en-US%22%3E%3CP%3Eapologies%20for%20dragging%20up%20an%20old%20post..%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eprobably%20noteworthy%20that%20that%20the%20specific%20recommendation%20relating%20to%20Co-authoring%20doesn't%20include%20XLSX%20.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3E%22Coauthoring%20in%20Word%20and%20PowerPoint%20for%20.docx%2C%20.pptx%20and%20.ppsx%20files%20%22%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThough%20I%20recall%20(perhaps%20I'm%20mistaken)%20that%20at%20one%20point%20Co-authoring%20was%20NOT%20supported%20in%20Excel%20(unless%20the%20spreadsheet%20was%20a%20%22shared%20workbook%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20understood%20that%20co-authoring%20is%20now%20possible%20in%20Excel%20and%20has%20been%20for%20some%20time.%20However%2C%20I've%20recently%20heard%20people%20mentioning%20that%20they've%20struggled%20with%20co-authoring%20in%20Excel%20and%20people%20asking%20is%20co-authoring%20supported%20in%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20assume%20that%20there%20aren't%20issues%20if%20co-authors%2Fcollaborators%20are%20both%20using%20Excel%20Online%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20suspect%20that%20%22Open%20in%20Excel%22%20is%20used%20more%20than%20%22Open%20in%20%3CANY%20other%3D%22%22%20office%3D%22%22%20tools%3D%22%22%3E%22%20because%20the%20experience%20is%20better%20(or%20there%20are%20features%20of%20the%20worksheet%20that%20are%20unsupported%20in%20Online)%20.%3C%2FANY%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20%2C%20or%20rather%20WERE%20the%20issues%20with%20co-authoring%20in%20Excel%20%2C%20likely%20to%20be%20related%20to%20the%20older%20OneDrive%20Groove.exe%20sync%20client%3F%20i.e.%20the%20changes%20made%20locally%20were%20not%20being%20synchronised%20with%20the%20Online%20copy%20and%20therefore%20not%20synchronising%20with%20other%20co-authors%3F%20(One%20would%20assume%20that%20this%20will%20have%20improved%20therefore%20with%20the%20wider%20adoption%20new%20gen%20sync%20client)%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-184965%22%20slang%3D%22en-US%22%3ERe%3A%20Limits%20to%20number%20of%20co-authors%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-184965%22%20slang%3D%22en-US%22%3E%3CP%3EAnd%20keep%20in%20mind%20that%20Excel%20has%20always%20been%20a%20little...%20special%20when%20it%20comes%20to%20co-authoring.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-184863%22%20slang%3D%22en-US%22%3ERe%3A%20Limits%20to%20number%20of%20co-authors%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-184863%22%20slang%3D%22en-US%22%3E2016%20is%2010%20as%20well%20before%20degradation.%20So%20I%20mean%20it%20lines%20up%20with%20experience%20your%20having%20so%20I%20would%20think%20it's%20pretty%20much%2010%20as%20well%20for%20Online.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-184860%22%20slang%3D%22en-US%22%3ERe%3A%20Limits%20to%20number%20of%20co-authors%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-184860%22%20slang%3D%22en-US%22%3E%3CP%3ESince%20that%20article%20applies%20to%20Sharepoint%202013%2C%20do%20you%20think%20it%20is%20relevant%20here%3F%20It%20could%20be%20that%20co-authoring%20limits%20are%20the%20same%20across%20products%2C%20but%20I'm%20not%20certain%20of%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20the%20users%20in%20question%20were%20either%20using%20Office%20Online%20embedded%20in%20Teams%2C%20or%20using%20Office%20Online%20directly.%20We%20don't%20currently%20support%20the%20Office%20365%20Pro%20Plus%20deployments%2C%20and%20our%20Office%20client%20applications%20are%20not%20signed%20in%20to%20Office%20365.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-184846%22%20slang%3D%22en-US%22%3ERe%3A%20Limits%20to%20number%20of%20co-authors%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-184846%22%20slang%3D%22en-US%22%3EOk%2C%20So%2C%20recommended%20is%20no%20more%20than%2010%2C%20but%20the%20maxium%20is%2099%20%3AP%2C%20so%20I%20guess%20your%20experience%20is%20on%20par%20with%20expectations.%20Reference%20here%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2FSharePoint%2Finstall%2Fsoftware-boundaries-and-limits%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2FSharePoint%2Finstall%2Fsoftware-boundaries-and-limits%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%22Recommended%20maximum%20number%20of%20concurrent%20editors%20is%2010.%20The%20boundary%20is%2099.%3CBR%20%2F%3EIf%20there%20are%2099%20co-authors%20who%20have%20a%20single%20document%20opened%20for%20concurrent%20editing%2C%20each%20successive%20user%20sees%20a%20%22File%20in%20use%22%20error%2C%20and%20can%20only%20open%20a%20read-only%20copy.%3CBR%20%2F%3EMore%20than%2010%20co-editors%20will%20lead%20to%20a%20gradually%20degraded%20user%20experience%20with%20more%20conflicts%2C%20and%20users%20might%20have%20to%20go%20through%20more%20iterations%20to%20successfully%20upload%20their%20changes%20to%20the%20server.%20%22%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-184844%22%20slang%3D%22en-US%22%3ERe%3A%20Limits%20to%20number%20of%20co-authors%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-184844%22%20slang%3D%22en-US%22%3EMicrosoft%20has%20said%20hundreds%2C%20somewhere%20I%20had%20a%20post%20I'll%20go%20search%20for%20it.%20But%20I%20think%20it's%20one%20of%20those%20things%20where%20if%20you%20have%20one%20bad%20apple%20in%20the%20bunch%20it%20can%20cause%20issues.%20Also%20are%20they%20all%20using%20web%20browser%20or%20mix%20of%20Clients%20as%20well%3F%3C%2FLINGO-BODY%3E
Highlighted
Contributor

Is there any published information regarding limits to co-authoring in Office Online? I've received some reports that Excel sheets were nearly unusable when the number of co-authors went above 10. I've personally never edited with this many authors, but I can't find any documentation with any hard limits around this.

Thanks!

9 Replies
Highlighted
Microsoft has said hundreds, somewhere I had a post I'll go search for it. But I think it's one of those things where if you have one bad apple in the bunch it can cause issues. Also are they all using web browser or mix of Clients as well?
Highlighted
Ok, So, recommended is no more than 10, but the maxium is 99 :P, so I guess your experience is on par with expectations. Reference here https://docs.microsoft.com/en-us/SharePoint/install/software-boundaries-and-limits

"Recommended maximum number of concurrent editors is 10. The boundary is 99.
If there are 99 co-authors who have a single document opened for concurrent editing, each successive user sees a "File in use" error, and can only open a read-only copy.
More than 10 co-editors will lead to a gradually degraded user experience with more conflicts, and users might have to go through more iterations to successfully upload their changes to the server. "
Highlighted

Since that article applies to Sharepoint 2013, do you think it is relevant here? It could be that co-authoring limits are the same across products, but I'm not certain of this.

 

And the users in question were either using Office Online embedded in Teams, or using Office Online directly. We don't currently support the Office 365 Pro Plus deployments, and our Office client applications are not signed in to Office 365.

Highlighted
Best Response confirmed by Matt McNabb (Contributor)
Solution
2016 is 10 as well before degradation. So I mean it lines up with experience your having so I would think it's pretty much 10 as well for Online.
Highlighted

And keep in mind that Excel has always been a little... special when it comes to co-authoring.

Highlighted

apologies for dragging up an old post.. 

 

probably noteworthy that that the specific recommendation relating to Co-authoring doesn't include XLSX . 

 

"Coauthoring in Word and PowerPoint for .docx, .pptx and .ppsx files "

 

Though I recall (perhaps I'm mistaken) that at one point Co-authoring was NOT supported in Excel (unless the spreadsheet was a "shared workbook")

 

I understood that co-authoring is now possible in Excel and has been for some time. However, I've recently heard people mentioning that they've struggled with co-authoring in Excel and people asking is co-authoring supported in Excel.

 

I assume that there aren't issues if co-authors/collaborators are both using Excel Online?

 

I'd suspect that "Open in Excel" is used more than "Open in <any other Office tools>" because the experience is better (or there are features of the worksheet that are unsupported in Online) .

 

Are , or rather WERE the issues with co-authoring in Excel , likely to be related to the older OneDrive Groove.exe sync client? i.e. the changes made locally were not being synchronised with the Online copy and therefore not synchronising with other co-authors? (One would assume that this will have improved therefore with the wider adoption new gen sync client) 

 

Highlighted
Sync client is irrelevant to co-authoring. The problem with Excel usually is the version of Excel, it's just become recently available to co-author and many people don't have the newer version to do so. This article used to say what version, but usually I say if you have the Auto save icon in the top left, then you can coauthor, otherwise you most likely need to update.

https://support.office.com/en-us/article/Collaborate-on-Excel-workbooks-at-the-same-time-with-co-aut...
Highlighted

Thanks @Chris Webb good to know.

 

When you say recently.. ball park are we talking the last year or is it available for longer than that?

 

Cheers.

Highlighted
Depends on the release settings. The auto save just started rolling out a few months ago to the Semi-Annual ring.