Pivot Table Labels: Pull-down orfer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Sort Order 1
pivot 2
Excel Pivot Table - Sort Report Filter Values 3
Pivot Table 2
Repeat labels in Pivot Tables 2
Excel 2002 - Pivot Table : How to rearranged columns by draging ? 2
Pivot Table Items 3
Pivot table row field order 6

Back
Top