Updating all pivot tables at once
 

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

Updating all pivot tables at once
 

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'

rascal wrote:
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
Contextures
http://www.contextures.com/tiptech.html