| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Labels: Pull-down orfer
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Labels: Pull-down orfer
Hi
If you double click on the filed nameAdvancedSort Ascending -- Regards Roger Govier "pkeenan" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Labels: Pull-down orfer
If you double click on the filed nameAdvancedSort Ascending
That should have read If you double click on the field nameAdvancedSort Ascending -- Regards Roger Govier "Roger Govier" wrote in message ... Hi If you double click on the filed nameAdvancedSort Ascending -- Regards Roger Govier "pkeenan" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get labels to repeat in a pivot table? | Excel Worksheet Functions | |||
| entry not removed in pivot table pull down filter | Excel Worksheet Functions | |||
| How to pull extra info into Pivot table report | Excel Worksheet Functions | |||
| Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
| How do I repeat labels in a Pivot Table | Excel Discussion (Misc queries) | |||
Linear Mode
