Pivot Table selection lists retain old values and are not re-sorte

S

scott56hannah

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
 
A

Anand.V.V.N

I guess you have tried the autosort method or autosortfield of pivottable,
did they work?

Anand.V.V.N
 

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

VBA Pivot Table: Determining item from one field based on anotherfield item 0
Changing pivot table ADO recordset 0
Refreshing Pivot table 1
Using VBA on Excel Pivot Tables 3
Pivot table drill down sort 0
Pivot Table refresh in VBA code not working 0
Pivot Table Page Fields Selection 1
Pivot Table - I can't delete unused values in selection drop-downs 2

Top