Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
clean up selection optinons in pivot tables
Hello,
XL 2002 I have a query that gives me the data for a pivottable. However, when the data changes the possible selections in the pivottable do not change, all former available options remain. How can I clean up? Eg. I have 100 customers in my pivottable, I update my data that has only 5 customers in the result. In the updated pivot table I can still select from the 100 customers where there should be only 5. The data and the pivot table are ok, the problem is the drop down list of the field of the pivottable. regards arno |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
clean up selection optinons in pivot tables
Hi
this is a known issue. See: http://www.contextures.com/xlPivot04.html for some soltuions -----Original Message----- Hello, XL 2002 I have a query that gives me the data for a pivottable. However, when the data changes the possible selections in the pivottable do not change, all former available options remain. How can I clean up? Eg. I have 100 customers in my pivottable, I update my data that has only 5 customers in the result. In the updated pivot table I can still select from the 100 customers where there should be only 5. The data and the pivot table are ok, the problem is the drop down list of the field of the pivottable. regards arno . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
clean up selection optinons in pivot tables
Thank you for the tip,
http://www.contextures.com/xlPivot04.html the macro there will do the job. arno |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Synchronize the Pivot table page field selection in 2 tables? | Excel Worksheet Functions | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Multiple Column selection in pivot tables | Excel Discussion (Misc queries) | |||
Multiple Pivot tables from One selection | Excel Discussion (Misc queries) | |||
Pivot Tables - Row Selection | Excel Discussion (Misc queries) |