Aug 18 2020 06:30 AM
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.
Aug 19 2020 02:01 AM
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
Aug 19 2020 04:17 AM
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.