clean up selection optinons in pivot tables

From: arno (schoblochr_at_azoppoth.at)
Date: 08/03/04 

Date: Tue, 3 Aug 2004 09:16:50 +0200

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

Relevant Pages

  • clean up selection optinons in pivot tables
    ... >I have a query that gives me the data for a pivottable. ... >data changes the possible selections in the pivottable do ... I have 100 customers in my pivottable, ... In the updated pivot table I can ...
    (microsoft.public.excel.programming)
  • RE: Varied product list
    ... I got the closest to what I was looking for by creating a pivot table. ... But how do I tie in the filter? ... customers names and only show the products that have -1 on them. ... line includes frozen foods, candy, condiments, produce, non-food items, etc. ...
    (microsoft.public.excel.misc)
  • Re: counting in pivot table
    ... using a dynamic range for the customers ... Suppose the source data is in Sheet1, ... > I am using a Pivot Table to view data from a very large database. ... > but since I am using it in a Pivot Table calculated field I used the ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Pivot Table services
    ... functionality however I have a couple other questions, ... >For question 1) try selecting the fifty customers you ... >> issues I am trying to solve with Excel's Pivot Table ... >> of dimension members that they report on. ...
    (microsoft.public.excel.misc)
  • RE: custom percentage calculation
    ... Col B is 'Total Customers' ... Right Click inside the pivot table. ... In the 'Name' box, Type 'My Calculation' ...
    (microsoft.public.excel.misc)