[pivottables] multiple table selection fields update in one click... a.lagolep[ at ]caramail.com 21.09.2006 13:39:28 Hi On a worksheet, I have 100 pivot tables. Let's say one criteria of each pivot table is "month" Ho can I do in order to only type somewhere the month (let's say in A1 for example) and this month is then automatically populated to all pivot tables ? If this is easy... additional question : on the same worksheet, I have 100 pivot tables split in two columns. with the same "month "criteria. How can I do to have A1 for month setting for the 50 pivot tables of the 1rst column, and A2 to setup the month of the other 50 pivot table list ? Thanks, AL.

Re: [pivottables] multiple table selection fields update in one click... Debra Dalgleish <dsd[ at ]contexturesXSPAM.com> 22.09.2006 01:42:59 There's a sample file here where changing a page field in one pivot table changes the same field in other pivot tables: http://www.contextures.com/excelfiles.html Under PivotTables, look for 'PT0008 - Change Multiple Page Fields' It might help you get started with your workbook. a.lagolep[ at ]caramail.com wrote: [Quoted Text] > Hi > > On a worksheet, I have 100 pivot tables. Let's say one criteria of each > pivot table is "month" > > Ho can I do in order to only type somewhere the month (let's say in A1 > for example) and this month is then automatically populated to all > pivot tables ? > > If this is easy... additional question : on the same worksheet, I have > 100 pivot tables split in two columns. with the same "month "criteria. > How can I do to have A1 for month setting for the 50 pivot tables of > the 1rst column, and A2 to setup the month of the other 50 pivot table > list ? > > Thanks, > > AL. > -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html