file edit

%3CLINGO-SUB%20id%3D%22lingo-sub-1166651%22%20slang%3D%22en-US%22%3Efile%20edit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1166651%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20appreciate%20the%20help.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20shared%20an%20excel%20file%20on%20teams%2C%20however%20only%20one%20person%20can%20open%20the%20file%20and%20edit%20in%20the%20desktop%20app%20the%20rest%20have%20to%20use%20the%20online%20excel%20which%20has%20limited%20functions.%26nbsp%3B%20Is%20there%20a%20way%20that%20more%20than%202%20people%20with%20access%20to%20this%20file%20can%20open%20it%20in%20the%20desktop%20app%20at%20the%20same%20time.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20looks%20the%20file%20for%20editing%20if%20anyone%20else%20tries%20to%20open%20it%20in%20desktop%20excel%20app.%26nbsp%3B%20Thanks%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F169605%22%20target%3D%22_blank%22%3E%40Christopher%20Hoard%3C%2FA%3E%26nbsp%3B%20i%20see%20you%20have%20vast%20knowledge%20about%20teams%20could%20you%20please%20help%20me.%20Thanks%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1166651%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUser%20Interface%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1166667%22%20slang%3D%22en-US%22%3ERe%3A%20file%20edit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1166667%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F553363%22%20target%3D%22_blank%22%3E%40jaber60%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFew%20things%20to%20check%3A-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20The%20file%20has%20been%20converted%20to%20a%20docx%20and%20is%20not%20an%20old%20format%20doc%20file.%3C%2FP%3E%3CP%3E2.%20There%20are%20no%20complicated%20macros%20in%20the%20excel%20file%20as%20this%20will%20restrict%20Co-authoring.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAndy%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1166679%22%20slang%3D%22en-US%22%3ERe%3A%20file%20edit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1166679%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F214649%22%20target%3D%22_blank%22%3E%40Andrew%20Hodges%3C%2FA%3E%26nbsp%3BThanks%20for%20the%20response%20do%20we%20have%20to%20upload%20it%20as%20docx%20as%20i%20usually%20upload%20as%20xlsx%20%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1166707%22%20slang%3D%22en-US%22%3ERe%3A%20file%20edit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1166707%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F553363%22%20target%3D%22_blank%22%3E%40jaber60%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorry%20-%20yes%20xlsx.%20If%20the%20file%20is%20already%20an%20xslx%20then%20there%20maybe%20some%20functionally%20that%20is%20not%20compatible%20with%20co-authoring.%20Try%20opening%20the%20SharePoint%20Site%20and%20seeing%20if%20there%20is%20any%20different%2C%20I%20suspect%20not.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1167981%22%20slang%3D%22en-US%22%3ERe%3A%20file%20edit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1167981%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F553363%22%20target%3D%22_blank%22%3E%40jaber60%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20co-authoring%20to%20work%2C%20everyone%20need%20to%20use%20the%20latest%20version%20of%20Excel.%20Also%20Autosave%20needs%20to%20be%20ON.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi 

I would appreciate the help. 

 

I have shared an excel file on teams, however only one person can open the file and edit in the desktop app the rest have to use the online excel which has limited functions.  Is there a way that more than 2 people with access to this file can open it in the desktop app at the same time. 

 

It looks the file for editing if anyone else tries to open it in desktop excel app.  Thanks  

@Christopher Hoard  i see you have vast knowledge about teams could you please help me. Thanks 

 

4 Replies
Highlighted

@jaber60 

 

Few things to check:-

 

1. The file has been converted to a docx and is not an old format doc file.

2. There are no complicated macros in the excel file as this will restrict Co-authoring. 

 

Andy

 

Highlighted

@Andrew Hodges Thanks for the response do we have to upload it as docx as i usually upload as xlsx ? 

Highlighted

@jaber60 

 

Sorry - yes xlsx. If the file is already an xslx then there maybe some functionally that is not compatible with co-authoring. Try opening the SharePoint Site and seeing if there is any different, I suspect not. 

Highlighted

@jaber60 

For co-authoring to work, everyone need to use the latest version of Excel. Also Autosave needs to be ON.