| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
pivot table pull down filter
Everytime I added new data in the pivot table field and refreshed,items in
the pull down menu is not sorted in alphabetical order instead added in the bottom of the list randomly. I mean when I create Pivot table first time pull down has its item sorted aphabetically but when I update pivot table with new data items that are added later is not sorted in alphabetical order. Is there any work around for this?? thanks for you help sanj |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
pivot table pull down filter
Right-click on the field button, and choose Field Settings
Click the Advanced button Under AutoSort options, select Ascending, click OK, click OK Sanj wrote: Everytime I added new data in the pivot table field and refreshed,items in the pull down menu is not sorted in alphabetical order instead added in the bottom of the list randomly. I mean when I create Pivot table first time pull down has its item sorted aphabetically but when I update pivot table with new data items that are added later is not sorted in alphabetical order. Is there any work around for this?? thanks for you help sanj -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pull pivot table data | Excel Discussion (Misc queries) | |||
| Can I pull field as datafield or as a output from a pivot table re | Excel Discussion (Misc queries) | |||
| pivot table created from another pivot table | Excel Worksheet Functions | |||
| Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
Linear Mode
