pivot dropdown list

B

boris

In pivot, how do you refresh the list of options that
comes up on dropdown? Seems like once a piece of data is
there, even if removed from original list and then pivot
refreshed, item is still there. Also, how do you sort
that list alphabetically or otherwise?

Thanks. Boris
 
D

Debra Dalgleish

There are instructions here for clearing old items from a PivotTable
dropdown list:

http://www.contextures.com/xlPivot04.html

If you sort the field in the pivot table, the items in the field's
dropdown list should also be sorted.

To sort a column field, select a cell in the column area, and click the
A-Z button on the tool bar.
 

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

list or combo box 0
How to remove non-exist values in pull-down list in pivot table 1
Sorting the pivot table field list 4
Sorting Cube dimension names in a Pivot Table 0
Adding data to a 2007 pivot table 2
Pivot Table and Merged Cells Help 1
Pivot Item Displaying Incorrect Value? 1
Pivot Table Filters 2

Top