Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dave S
 
Posts: n/a
Default 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
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default Pivot Table Drop Down Boxes

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change Data In Pivot Table John Calder New Users to Excel 1 July 7th 05 11:41 PM
drop down arrow missing from pivot table Sim Excel Discussion (Misc queries) 0 July 5th 05 04:35 PM
Pivot Table Problems Rachel Gonsior Excel Discussion (Misc queries) 3 March 21st 05 08:24 PM
How do I remove items listed in a pivot table drop down list box Hart165Hour Excel Discussion (Misc queries) 3 March 16th 05 05:19 AM
Problem with Pivot Table Drop-Down Menus Mac Excel Worksheet Functions 4 November 7th 04 02:18 PM


All times are GMT +1. The time now is 04:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"