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

Pivot Table - I can't delete unused values in selection drop-downs 2
Using VBA on Excel Pivot Tables 3
Pivot Table Page Fields Selection 1
How to build / refresh pivot table without ODBC?? 1
Pivot table drill down sort 0
Pivot Table Drop Lists Out of Order 2
Pivot Table groups Refresh 2
refreshing a pivot table 1

Top