Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Drop Downs
When I apply a pivot table template to a new dataset, I always still have the
old field values in the drop down list. Anyone know how to "clear" the old values from a prior dataset when using a pivot table for a new dataset? For example, is column "A" is a filed named "Reference #" and held the values 1-20 and I used that field in a Pivot Table then the drop down for this field would have 1-20. If I then use a dataset that has "Refernce #" range of 100-199, I would expect only 100-199 to appear in the Pivot Table drop down for that field. However, the drop down would contain 1-20 AND 100-199 (1-20 from the first dataset and then 100-199 from the second). How can I get the Pivot drop down to ONLY display the values for the current dataset? Pivot tables seem to like to remember any prior values for some reason. -- Thanks, Chuck |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table drop downs | Excel Discussion (Misc queries) | |||
reading into pivot table drop downs | Excel Discussion (Misc queries) | |||
Vlookup using drop downs and table | Excel Worksheet Functions | |||
Can Pivot table drop-downs act like AutoFilter | Excel Discussion (Misc queries) | |||
Cross-referenced drop-down menu (nested drop-downs?) | Excel Worksheet Functions |