problems with slicers

%3CLINGO-SUB%20id%3D%22lingo-sub-1595890%22%20slang%3D%22en-US%22%3Eproblems%20with%20slicers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1595890%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHello%2C%20when%20I'm%20sending%20file%20with%20slicers%2C%20custom%20sorting%20isn't%20working%2C%20for%20example%20names%20in%20my%20computer%20are%20sorted%20by%20custom%20sort%2C%20but%20recipients%20see%20them%20from%20A%20to%20Z%2C%20what%20to%20do%20to%20fix%20this%20problem%3F%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EAlso%20I%20have%20the%20same%20problem%20on%20pivot%20charts.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1595890%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1598304%22%20slang%3D%22en-US%22%3ERe%3A%20problems%20with%20slicers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1598304%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F763175%22%20target%3D%22_blank%22%3E%40Tamuna111%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20are%20you%20doing%20the%20custom%20sort%20%3F%20are%20manually%20dragging%20the%20fields%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Epls%20give%20inputs%20to%20advise%20you%20the%20correct%20solution%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%2FBest%20Answer%26nbsp%3Bto%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1598554%22%20slang%3D%22en-US%22%3ERe%3A%20problems%20with%20slicers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1598554%22%20slang%3D%22en-US%22%3E%3CP%3EI%20sorted%20data%20from%20%3CA%20href%3D%22mailto%3Asort%40filter%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Esort%26amp%3Bfilter%2C%20custom%20sort.%26nbsp%3B%26nbsp%3B%3C%2FA%3E%26nbsp%3BAlso%20checked%20boxed%20in%20slicer's%20and%20chart's%20options.%20you%20can%20see%20in%20attached%20files.%20Sheet's%20locked.%20And%20also%20sorting%20changes%20when%20recipient%20want%20to%20choose%20another%20bullet%20from%20slicers.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156456%22%20target%3D%22_blank%22%3E%40Faraz%20Shaikh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello, when I'm sending file with slicers, custom sorting isn't working, for example names in my computer are sorted by custom sort, but recipients see them from A to Z, what to do to fix this problem?
Also I have the same problem on pivot charts.

2 Replies

Hi @Tamuna111 

 

How are you doing the custom sort ? are manually dragging the fields ?

 

pls give inputs to advise you the correct solution 

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more

I sorted data from sort&filter, custom sort.   Also checked boxed in slicer's and chart's options. you can see in attached files. Sheet's locked. And also sorting changes when recipient want to choose another bullet from slicers.

@Faraz Shaikh