SOLVED

Filtrage sur Excel navigateur

%3CLINGO-SUB%20id%3D%22lingo-sub-2168086%22%20slang%3D%22fr-FR%22%3EFiltering%20on%20Excel%20browser%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2168086%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20Excel%20Navigator%2C%20my%20colleagues%20and%20I%20work%20at%20the%20same%20time%20on%20the%20same%20file%20and%20have%20to%20make%20different%20filters.%20When%20I%20want%20to%20make%20a%20filter%20a%20small%20window%20opens%20and%20asks%20me%3A%20%22Do%20you%20want%20to%20display%20sorting%20and%20filtering%20other%20people's%20items%3F%22.%20I%20don't%20know%20if%20I%20should%20answer%20%22Show%20only%20my%20items%22%20or%20%22Show%20everyone's%20items%22%20if%20I%20don't%20want%20to%20move%20their%20filters.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20you%20help%20me%3F%3C%2FP%3E%3CP%3ECooperation%20on%20Excel%20is%20complicated%20until%20we%20know%20how%20to%20do%20it.%20Please%20help%20us.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2168086%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2168741%22%20slang%3D%22en-US%22%3ERe%3A%20Filtrage%20sur%20Excel%20navigateur%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2168741%22%20slang%3D%22en-US%22%3EWorking%20on%20file%20simultaneously%20you%20may%20sort%20and%20filter%20independently%20on%20each%20other%20using%20Sheet%20View%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fsheet-views-in-excel-0eea3dc5-d7d1-44c5-a953-25ebfbd6c1a6%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fsheet-views-in-excel-0eea3dc5-d7d1-44c5-a953-25ebfbd6c1a6%3C%2FA%3E%20.%20If%20you%20didn't%20select%20separate%20view%20your%20sorting%20and%20filtering%20affect%20other%20people%20who%20use%20the%20same%20view.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2174203%22%20slang%3D%22fr-FR%22%3ERe%3A%20Filtering%20on%20Excel%20browser%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2174203%22%20slang%3D%22fr-FR%22%3EThank%20you%20very%20much%20Sergei!%3C%2FLINGO-BODY%3E
New Contributor

Bonjour,

 

Sur Excel Navigateur, mes collègues et moi travaillons en même temps sur le même fichier et devons faire des filtres différents. Quand je veux faire un filtre une petite fenêtre s'ouvre et me demande : "Voulez-vous afficher le tri et le filtrage d'éléments d'autres personnes ?". Je ne sais pas si je dois répondre "Afficher uniquement mes éléments" ou Afficher les éléments de tout le monde" si je ne veux pas bouger leur filtres.

 

Pourriez-vous m'aider ?

La coopérations sur Excel est compliqué tant qu'on ne saura comment faire. Please help us.

4 Replies
best response confirmed by acoiffard (New Contributor)
Solution
Working on file simultaneously you may sort and filter independently on each other using Sheet View https://support.microsoft.com/en-us/office/sheet-views-in-excel-0eea3dc5-d7d1-44c5-a953-25ebfbd6c1a6 . If you didn't select separate view your sorting and filtering affect other people who use the same view.
Thank you very much Sergei !

@acoiffard , you are welcome

@Sergei Baklan 

Merci pour cette réponse.

Il me semble que la question "Voulez-vous afficher le tri et le filtrage d'éléments d'autres personnes" est mal formulée.

Je propose : "souhaitez-vous que vos modifications de filtre et de tri soient aussi pour les autres personnes ?

Mais je pense qu'on peut encore mieux trouver.