Home

Excel File locked when opening from teams

%3CLINGO-SUB%20id%3D%22lingo-sub-113290%22%20slang%3D%22en-US%22%3EExcel%20File%20locked%20when%20opening%20from%20teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-113290%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20an%20exscel%20file%20stored%20within%20a%20channel%20of%20teams.%26nbsp%3B%20Now%20when%20the%20first%20user%20opens%20this%20file%2C%20he%20receives%20message%20that%20it%20it%20has%20features%20that%20are%20not%20supported%20in%20excel%20online.%20Ok%20so%20far.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20when%20he%20opens%20it%20in%20Excel%20local%20version%2C%20another%20person%20can%20not%20open%20the%20file%20simultanously.%20The%20second%20person%20receives%20message%20that%20the%20file%20is%20locked.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20to%20open%20this%20file%20with%20two%20or%20more%20people%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-113290%22%20slang%3D%22en-US%22%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-204844%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20File%20locked%20when%20opening%20from%20teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-204844%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EYou%20mentioned%20a%20warning%20about%20features%20that%20are%20not%20supported.%26nbsp%3B%20Is%20the%20file%20a%20%22.xls%22%20or%20%22.xlsx%22%20format.%26nbsp%3B%20The%20%22.xls%22%20does%20not%20support%20co-authoring%20and%20will%20need%20to%20be%20converted%20to%20%22.xlsx%22%20before%20it%20can%20be%20edited%20by%20multiple%20people%20at%20the%20same%20time.%26nbsp%3B%20I'm%20not%20sure%20about%20the%20save%20button%20either%2C%20but%20typically%20there%20isn't%20one%20when%20editing%20in%20the%20browser%20and%20there%20is%20one%20when%20editing%20in%20the%20desktop%20application.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EGood%20luck!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-114226%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20File%20locked%20when%20opening%20from%20teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-114226%22%20slang%3D%22en-US%22%3E%3CP%3EAh%2C%20I've%20just%20found%20it.%20It%20seems%20to%20come%20and%20go.%20Not%20sure%20why%20it%20is%20there%20as%20I've%20got%20the%20same%20greyed%20out%20version%20of%20it%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-114224%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20File%20locked%20when%20opening%20from%20teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-114224%22%20slang%3D%22en-US%22%3E%3CP%3EAh%2C%20I've%20just%20found%20it.%20It%20seems%20to%20come%20and%20go.%20Not%20sure%20why%20it%20is%20there%20as%20I've%20got%20the%20same%20greyed%20out%20version%20of%20it.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-114220%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20File%20locked%20when%20opening%20from%20teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-114220%22%20slang%3D%22en-US%22%3E%3CP%3E1708%20Build%208431.2079.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20far%20as%20I%20know%20is%20this%20the%20last%20build%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-114162%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20File%20locked%20when%20opening%20from%20teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-114162%22%20slang%3D%22en-US%22%3E%3CP%3EHI%26nbsp%3B%40Deleted%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20which%20version%20of%20Excel%20are%20you%20seeing%20this%20button%3F%20I'm%20not%20seeing%20it%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-114157%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20File%20locked%20when%20opening%20from%20teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-114157%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Pieter%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20reply.%20Yes%20in%20testing%20it%20seems%20that%20co-authoring%20in%20excel%20is%20online%20working%20in%20excel%20online.%20But%20do%20you%20have%20an%20idea%20why%20there%20is%20a%20%22automatic%20save%22%20button%20on%20the%20upper%20left%20corner%2C%20which%20by%20the%20way%20most%20of%20the%20times%20is%20greyed%20out.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-113307%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20File%20locked%20when%20opening%20from%20teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-113307%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%40Deleted%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20just%20opened%20an%20Excel%20using%20Excel%20Online%20twice%20and%20the%20co-authoring%20works%20as%20expected.%20The%20normal%20Excel%20client%20however%20doesn't%20seem%20to%20join%20the%20Co-Authoring%20session.%20While%20i've%20got%20the%20document%20open%20twice%20in%20Excel%20Online%20Excel%20gives%20me%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%20556px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F21568i42CDC3589A5E62C6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22readonly.PNG%22%20title%3D%22readonly.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20it%20looks%20like%20Co-Authoring%20isn't%20supported%20in%20Excel%2C%20but%20it%20is%20in%20Excel%20online.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Deleted
Not applicable

We have an exscel file stored within a channel of teams.  Now when the first user opens this file, he receives message that it it has features that are not supported in excel online. Ok so far.

 

Then when he opens it in Excel local version, another person can not open the file simultanously. The second person receives message that the file is locked.

 

How to open this file with two or more people?

 

 

7 Replies

Hi @Deleted,

 

I just opened an Excel using Excel Online twice and the co-authoring works as expected. The normal Excel client however doesn't seem to join the Co-Authoring session. While i've got the document open twice in Excel Online Excel gives me:

 

readonly.PNG

 

So it looks like Co-Authoring isn't supported in Excel, but it is in Excel online.

 

 

Hi Pieter,

 

Thanks for your reply. Yes in testing it seems that co-authoring in excel is online working in excel online. But do you have an idea why there is a "automatic save" button on the upper left corner, which by the way most of the times is greyed out.

 

HI @Deleted,

 

In which version of Excel are you seeing this button? I'm not seeing it here.

1708 Build 8431.2079.

 

As far as I know is this the last build

Ah, I've just found it. It seems to come and go. Not sure why it is there as I've got the same greyed out version of it. 

Ah, I've just found it. It seems to come and go. Not sure why it is there as I've got the same greyed out version of it

You mentioned a warning about features that are not supported.  Is the file a ".xls" or ".xlsx" format.  The ".xls" does not support co-authoring and will need to be converted to ".xlsx" before it can be edited by multiple people at the same time.  I'm not sure about the save button either, but typically there isn't one when editing in the browser and there is one when editing in the desktop application.

 

Good luck!

Related Conversations
Team Owner - Can not see who is member of a team
Oskar Kuus in Microsoft Teams on
1 Replies
Teams error code - 6
damnit95 in Office 365 on
4 Replies
Sharing a Teams Calendar
Michael Krueger in Microsoft Teams on
16 Replies
Teams Updater Vulnerability
Andrew Matthews in Microsoft Teams on
15 Replies
Skype Room System stuck on signing in (Solved)
ckoppen in Microsoft Teams on
26 Replies