I was hoping to sort the data in the PivotField dropdowns. The macro
in Debra Dalgleish's example works a treat, though I'd like to sort
the list of items as well as remove redundant items..?


On Mar 30, 7:02 pm, "Andy Pope" wrote:
Not sure what it is you want to sort.

You could try using the macro recorder whilst you do the sorting and then
see if it works when added.

Cheers
Andy

--