You can add fields to the page area. When you select from the dropdown
list in a field there, the table is filtered to show only that item.

bobf wrote:
> When using a pivot table, is there any way of
> automatically selecting from a drop down menu.
> By this I mean if I can select one of 5 colours,
> If I put "red" in cell A1, can the pivot table be made to
> take the value in cell A1 as the colour selection, rather
> than me selecting red from the drop down list.
>
> thanks in advance


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