Pivot Table Labels: Pull-down orfer

P

pkeenan

When I update my pivot table with new data, the field pull-downs (with check
boxes) are not in alphabetical order. I belive that any new labels are
simply added to the bottom rather than inserted alphabetically. I've
obtained a macro that removes unused lables, but is there a way to correct
the order of the labels as well?
 
R

Roger Govier

If you double click on the filed name>Advanced>Sort Ascending

That should have read

If you double click on the field name>Advanced>Sort Ascending
 
Top