SOLVED
Home

Co-authoring in Microsoft Teams

%3CLINGO-SUB%20id%3D%22lingo-sub-299094%22%20slang%3D%22en-US%22%3ECo-authoring%20in%20Microsoft%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-299094%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20open%20an%20Excel%20file%20in%20the%20Microsoft%20Teams%20app%2C%20and%20then%20select%20to%20open%20in%20Excel%2C%20the%20file%20gets%20locked%20to%20me%20for%20editing.%20Other%20users%20cannot%20open%20that%20same%20document%20for%20co-authoring.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20the%20expected%20default%20behavior%2C%20and%20if%20so%20is%20there%20a%20setting%20to%20change%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20message%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F62415i86FB3E4FED45CB11%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22MS%20Teams%20Workbook%20Locked.png%22%20title%3D%22MS%20Teams%20Workbook%20Locked.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-299094%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECo-Authoring%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-299167%22%20slang%3D%22en-US%22%3ERe%3A%20Co-authoring%20in%20Microsoft%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-299167%22%20slang%3D%22en-US%22%3EOk!%20Thanks!%20As%20said%20before%20it%E2%80%99s%20due%20to%20the%20desktop%20client%20version%20not%20supporting%20coauthoring%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-299157%22%20slang%3D%22en-US%22%3ERe%3A%20Co-authoring%20in%20Microsoft%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-299157%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20question.%20I%20am%20on%20the%20semi-annual%20channel%20and%20I%20don't%20have%20the%20autosave%20button.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-299143%22%20slang%3D%22en-US%22%3ERe%3A%20Co-authoring%20in%20Microsoft%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-299143%22%20slang%3D%22en-US%22%3EIf%20you%20have%20Office%20365%20installed%20and%20AutoSave%20enabled%20in%20the%20Excel%20file%2C%20co-authoring%20should%20work...We%20have%20already%20used%20in%20different%20scenarios%3A%20two%20or%20more%20users%20opening%20the%20Excel%20file%20with%20the%20desktop%20client%2C%20some%20users%20opening%20with%20the%20desktop%20clients%20and%20others%20with%20Excel%20Online.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-299137%22%20slang%3D%22en-US%22%3ERe%3A%20Co-authoring%20in%20Microsoft%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-299137%22%20slang%3D%22en-US%22%3EFollow%20up%20Reference%20article%20covering%20co-authoring.%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FDocument-collaboration-and-co-authoring-EE1509B4-1F6E-401E-B04A-782D26F564A4%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FDocument-collaboration-and-co-authoring-EE1509B4-1F6E-401E-B04A-782D26F564A4%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EFor%20excel%3A%20%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%3CBR%20%2F%3E%3CBR%20%2F%3EIn%20the%20FAQ's%20it%20talks%20about%20the%20file%20lock%20issue.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20any%20clients%20that%20don't%20support%20it%20or%20have%20it%20turned%20on%20open%20the%20files%20it%20will%20cause%20the%20lock%2C%20and%20most%20likely%20your%20current%20issue!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-299133%22%20slang%3D%22en-US%22%3ERe%3A%20Co-authoring%20in%20Microsoft%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-299133%22%20slang%3D%22en-US%22%3E%3CP%3EI%20agree%20with%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%2C%20I%20expect%20it%20will%20be%20your%20version%20of%20Excel.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20are%20using%20Excel%20Pro%20Plus%20in%20the%20semi-annual%20channel%2C%20the%20one%20Microsoft%20recommend%20for%20enterprise%20usage%2C%20then%20Excel%20doesn't%20yet%20support%20co-editing.%20I%20think%20it's%20in%20the%20next%20release%20that%20comes%20out%20in%20January.%20It%20was%20held%20back%20from%20Semi-Annual%20for%20nearly%20a%20year.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-299114%22%20slang%3D%22en-US%22%3ERe%3A%20Co-authoring%20in%20Microsoft%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-299114%22%20slang%3D%22en-US%22%3EHave%20it%20worked%20before%3F%20Only%20happening%20when%20opening%20in%20desktop%20excel%3F%20What%20about%20Word%20files%3F%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-299112%22%20slang%3D%22en-US%22%3ERe%3A%20Co-authoring%20in%20Microsoft%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-299112%22%20slang%3D%22en-US%22%3EIt's%20going%20to%20depend%20on%20your%20client.%20If%20it's%20locking%20there%20are%20a%20few%20things%20it%20could%20be%20but%20most%20likely%20it's%20due%20to%20using%20older%20excel%20version%2C%20and%20or%20I%20want%20to%20say%20%22Auto%20Save%22%20must%20be%20on%20as%20well%20for%20co-authoring%20to%20work%20on%20newer%20versions%20of%20excel.%20Check%20if%20this%20is%20off%20as%20well.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-299107%22%20slang%3D%22en-US%22%3ERe%3A%20Co-authoring%20in%20Microsoft%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-299107%22%20slang%3D%22en-US%22%3EAlso%20what%20version%20of%20excel%20are%20you%20running%3F%20Do%20you%20have%20the%20auto%20save%20toggle%20in%20the%20left%20upper%20corner%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-299106%22%20slang%3D%22en-US%22%3ERe%3A%20Co-authoring%20in%20Microsoft%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-299106%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%20this%20is%20a%20general%20issue.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-299102%22%20slang%3D%22en-US%22%3ERe%3A%20Co-authoring%20in%20Microsoft%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-299102%22%20slang%3D%22en-US%22%3EIs%20this%20the%20behavior%20when%20you%20open%20a%20file%20from%20other%20teams%20as%20well%3F%20What%20happens%20with%20other%20users%20when%20they%20do%20it%3F%3C%2FLINGO-BODY%3E
Frequent Contributor

When I open an Excel file in the Microsoft Teams app, and then select to open in Excel, the file gets locked to me for editing. Other users cannot open that same document for co-authoring.

 

Is this the expected default behavior, and if so is there a setting to change it?

 

The message:

MS Teams Workbook Locked.png

10 Replies
Is this the behavior when you open a file from other teams as well? What happens with other users when they do it?

Yes, this is a general issue.

Also what version of excel are you running? Do you have the auto save toggle in the left upper corner?
It's going to depend on your client. If it's locking there are a few things it could be but most likely it's due to using older excel version, and or I want to say "Auto Save" must be on as well for co-authoring to work on newer versions of excel. Check if this is off as well.
Have it worked before? Only happening when opening in desktop excel? What about Word files?

I agree with @Chris Webb, I expect it will be your version of Excel.

 

If you are using Excel Pro Plus in the semi-annual channel, the one Microsoft recommend for enterprise usage, then Excel doesn't yet support co-editing. I think it's in the next release that comes out in January. It was held back from Semi-Annual for nearly a year.

Solution
Follow up Reference article covering co-authoring. https://support.office.com/en-us/article/Document-collaboration-and-co-authoring-EE1509B4-1F6E-401E-...

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

In the FAQ's it talks about the file lock issue.

If any clients that don't support it or have it turned on open the files it will cause the lock, and most likely your current issue!
If you have Office 365 installed and AutoSave enabled in the Excel file, co-authoring should work...We have already used in different scenarios: two or more users opening the Excel file with the desktop client, some users opening with the desktop clients and others with Excel Online.

Good question. I am on the semi-annual channel and I don't have the autosave button.

Ok! Thanks! As said before it’s due to the desktop client version not supporting coauthoring