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