| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table selection lists retain old values and are not re-sorte
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pivot Table selection lists retain old values and are not re-sorte
I guess you have tried the autosort method or autosortfield of pivottable,
did they work? Anand.V.V.N -- "Who will guard the guards?" "scott56hannah" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Field Selection for Pivot table Values Section | Excel Worksheet Functions | |||
| Pivot Table - I can't delete unused values in selection drop-downs | Excel Programming | |||
| how to remove old selection values in the pivot table | Excel Discussion (Misc queries) | |||
| Selection of multiple values for pivot table field | Excel Discussion (Misc queries) | |||
| pivot table with selection values not included in the base data | Charts and Charting in Excel | |||
Hybrid Mode
