Thread: Pivot Table Drop Down Boxes

I want to be able to limit the drop down box content to information relevant
to what I have seleced on the page. Example: I select Region A at the page
selection, then open the District drop down box, and all districts
countrywide are shown. I only want to see Districts to choose from in Region
A.

Excel 2003 - Windows XP

That feature isn't available in the pivot table dropdown lists.

Dave S wrote:
> I want to be able to limit the drop down box content to information relevant
> to what I have seleced on the page. Example: I select Region A at the page
> selection, then open the District drop down box, and all districts
> countrywide are shown. I only want to see Districts to choose from in Region
> A.
>
> Excel 2003 - Windows XP


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