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
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies