Hi

Go to Debra Dalgleish's site
http://www.contextures.com/excelfiles.html#Pivot
PT008 Change Multiple Page fields

Debra has 2 downloads here which show you how to achieve this, depending
upon which version of XL you are using.

--
Regards

Roger Govier


"Monica" wrote in message
...
I have about six pivot tables all with the same information for
different
months. The different information that we use as drop down lists is
production information and sales information, OB and CB. What I want
to be
able to do is link the drop down lists to another cell so that I only
have to
change one cell which will automatically change all six pivot tables
for
analysing purposes. Any ideas?