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