Hi,

I have a pivot table / chart based on a large set of data. As I import more
data to the pivot data the selection lists are populated with the new data
but old data is retained in the list and the list is not re-sorted.

I cannot find a way to refresh these selection lists. They do not refresh
when the pivot table is refreshed...

Is there anyway to refresh these lists so that they should the latest values
in sorted order ?

Thanks
Scott