I have a pivot table that includes all the sales data for two brands, by
region, and sales person. The data in the query table comes from a query of
an oracle database. Now that we agree we'd like to keep this project moving,
we are trying to limit the data in the query so we can disburse the
information to gain additional feedback.

My problem is that when I change the query to exclude certain markets or
brands, I can still see those markets or brands in the drow downs in the
pivot table. This is strange, because these markets/brands are now excluded
from the query data and the pivot table has been refreshed.

Is there any way to fix this issue? I'd like the pivot table drop downs to
only include the items in our query data.

There are instructions here for clearing old items from a PivotTable
dropdown list:

http://www.contextures.com/xlPivot04.html


Excel GuRu wrote:
I have a pivot table that includes all the sales data for two brands, by
region, and sales person. The data in the query table comes from a query of
an oracle database. Now that we agree we'd like to keep this project moving,
we are trying to limit the data in the query so we can disburse the
information to gain additional feedback.

My problem is that when I change the query to exclude certain markets or
brands, I can still see those markets or brands in the drow downs in the
pivot table. This is strange, because these markets/brands are now excluded
from the query data and the pivot table has been refreshed.

Is there any way to fix this issue? I'd like the pivot table drop downs to
only include the items in our query data.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thank you Debra, I had just stumbled upon your website.

"Debra Dalgleish" wrote:

There are instructions here for clearing old items from a PivotTable
dropdown list:

http://www.contextures.com/xlPivot04.html


Excel GuRu wrote:
I have a pivot table that includes all the sales data for two brands, by
region, and sales person. The data in the query table comes from a query of
an oracle database. Now that we agree we'd like to keep this project moving,
we are trying to limit the data in the query so we can disburse the
information to gain additional feedback.

My problem is that when I change the query to exclude certain markets or
brands, I can still see those markets or brands in the drow downs in the
pivot table. This is strange, because these markets/brands are now excluded
from the query data and the pivot table has been refreshed.

Is there any way to fix this issue? I'd like the pivot table drop downs to
only include the items in our query data.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html