Updating all pivot tables at once

[Guest]

I have several pivot charts on different sheets of a workboard. I used the
camera tool to put them on 1 main sheet. What I would like to do is, from
the main sheet allow the person viewing the tables to choose either a month
&/or employee and have all the pivot tables show the information related to
that particular month and/or employee. Right now if I go to each separate
sheet and set the month and employee then go back to the main sheet all
information has been changed, but I would like to be able to do it from the
main sheet. Is this possible and if any suggestions on how to do it.
Thanks

 

[Debra Dalgleish]

You can do this with programming. There's a sample file here that may
help:

http://www.contextures.com/excelfiles.html

Under PivotTables, look for 'PT0008 - Change Multiple Page Fields'