Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating pivot tables | Excel Discussion (Misc queries) | |||
pivot tables not updating correctly | Excel Discussion (Misc queries) | |||
updating pivot tables using dynamic data source | Excel Discussion (Misc queries) | |||
Pivot Tables - updating individual columns | Excel Worksheet Functions | |||
updating pivot tables | Excel Discussion (Misc queries) |