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?

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?

Roger,

Thanks for that information. It was very helpful. It took me a while to get
it all working but finally there. Thanks heaps

Monica

"Roger Govier" wrote:

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?