I have a pivot table in Excel which is connected to 3 slicers [Dep Slicer, Rep slicer, Date slicer].

I created custom list to sort the pivot table in order of Rep1, Rep2, Rep3 ..... Rep40, this works perfectly well but I do notice that when the report is being emailed out the users and the users use the slicers this change the order of the Rep slicer and the order of the pivot table

Can anyone help please.

I want the slicers not to change the order when they are being used and also the pivot table not to change when slicers are being used.