Pivot Tables

[Guest]

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 Govier]

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.

 

[Guest]

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