Multiple users editing a file in teams

%3CLINGO-SUB%20id%3D%22lingo-sub-320992%22%20slang%3D%22en-US%22%3EMultiple%20users%20editing%20a%20file%20in%20teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-320992%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20multiple%20users%20are%20editing%20in%20a%20file%2C%20and%20they%20start%20to%20filter.%20It%20knocks%20the%20other%20person%20from%20editing.%20Is%20there%20a%20way%20to%20restrict%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-320992%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-321215%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20users%20editing%20a%20file%20in%20teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321215%22%20slang%3D%22en-US%22%3ENothing%20we%20can%20do%20here%20to%20prevent%20users%20to%20make%20filtering%20in%20the%20Excel%20file...what%20you%20can%20do%20here%20is%20to%20start%20a%20chat%20with%20your%20colleagues%20and%20ask%20them%20to%20no%20apply%20filters%20in%20the%20Excel%20file%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-321018%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20users%20editing%20a%20file%20in%20teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321018%22%20slang%3D%22en-US%22%3EYeah!%20Afaik%20there%E2%80%99s%20no%20way%20out%20of%20this%20except%20not%20co-author%20in%20excel%20docs!%20Co-author%20in%20excel%20is%20working%20but%20to%20be%20honest%20not%20very%20recommended%20from%20my%20part!%20Also%20depends%20on%20what%20kind%20of%20content%20etc%20but%20generally%20people%20mess%20things%20up%20a%20lot!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-320997%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20users%20editing%20a%20file%20in%20teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-320997%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Juan%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20am%20editing%20a%20file%20and%20I%20filter%20a%20column.%20Someone%20else%20can%20be%20in%20this%20same%20file%20and%20start%20to%20edit%20and%20change%20the%20filters%20as%20I%20am%20editing.%20It%20messes%20me%20up%20cause%20I%20lose%20track%20of%20the%20columns%20I%20am%20working%20on%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-320996%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20users%20editing%20a%20file%20in%20teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-320996%22%20slang%3D%22en-US%22%3EDo%20you%20mean%20filter%20in%20the%20Office%20Desktop%20Client%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1584883%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20users%20editing%20a%20file%20in%20teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1584883%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F60%22%20target%3D%22_blank%22%3E%40Juan%20Carlos%20Gonz%C3%A1lez%20Mart%C3%ADn%3C%2FA%3EConsider%20a%20pop%20up%20message%20box%20on%20file%20open.%26nbsp%3B%20Could%20read%20%22Please%20Do%20No%20Apply%20Filters%22%20then%20save%20as%20macro%20enabled.%26nbsp%3B%20Not%20sure%20this%20would%20work%20in%20the%20TEAMS%20environment%20but%20it%20would%20be%20worth%20a%20try%20and%20nice%20to%20have%20a%20reminder%20popup.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1818514%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20users%20editing%20a%20file%20in%20teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1818514%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F757466%22%20target%3D%22_blank%22%3E%40DreyerDOL%3C%2FA%3E%26nbsp%3Bthis%20seems%20to%20have%20been%20worked%20on.%20Has%20it%20been%20fixed%20-%20if%20so%20what%20version%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

 

When multiple users are editing in a file, and they start to filter. It knocks the other person from editing. Is there a way to restrict this?

 

6 Replies
Do you mean filter in the Office Desktop Client?

Hi Juan,

 

When I am editing a file and I filter a column. Someone else can be in this same file and start to edit and change the filters as I am editing. It messes me up cause I lose track of the columns I am working on

 

Yeah! Afaik there’s no way out of this except not co-author in excel docs! Co-author in excel is working but to be honest not very recommended from my part! Also depends on what kind of content etc but generally people mess things up a lot!
Nothing we can do here to prevent users to make filtering in the Excel file...what you can do here is to start a chat with your colleagues and ask them to no apply filters in the Excel file

@Juan Carlos González MartínConsider a pop up message box on file open.  Could read "Please Do No Apply Filters" then save as macro enabled.  Not sure this would work in the TEAMS environment but it would be worth a try and nice to have a reminder popup.

@DreyerDOL this seems to have been worked on. Has it been fixed - if so what version?