Prev: excel chart in word
Next: VB Code to Change the Color on boxes - gradient
From: Mike on 2 Feb 2010 15:13
So in 2007, I have two pivot tables that reference the same data set and have
the same report filters. Is there a way to set it up so I only have to
change the report filter selection on one pivot table and the data will be
updated in both? I am fairly comfortable with VBA so any solution/suggestion
is welcomed.

Thanks for any help.
From: trip_to_tokyo on 2 Feb 2010 15:27
Yes, you seem to want, "Synchronizing Two Pivot Tables with One Combo Box"
covered in detail in pages 225-229 of Pivot Table Data Crunching by Jelen /
Alexander.

"Mike" wrote:

> So in 2007, I have two pivot tables that reference the same data set and have
> the same report filters. Is there a way to set it up so I only have to
> change the report filter selection on one pivot table and the data will be
> updated in both? I am fairly comfortable with VBA so any solution/suggestion
> is welcomed.
>
> Thanks for any help.
From: Mike on 2 Feb 2010 15:41
Anyone got any help that doesn't cost anything?

"trip_to_tokyo" wrote:

> Yes, you seem to want, "Synchronizing Two Pivot Tables with One Combo Box"
> covered in detail in pages 225-229 of Pivot Table Data Crunching by Jelen /
> Alexander.
>
> "Mike" wrote:
>
> > So in 2007, I have two pivot tables that reference the same data set and have
> > the same report filters. Is there a way to set it up so I only have to
> > change the report filter selection on one pivot table and the data will be
> > updated in both? I am fairly comfortable with VBA so any solution/suggestion
> > is welcomed.
> >
> > Thanks for any help.
From: Don on 2 Feb 2010 16:40
how about creating VB code that you can have a button ?

ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh
ActiveSheet.PivotTables("PivotTable2").PivotCache.Refresh

"Mike" wrote:

> So in 2007, I have two pivot tables that reference the same data set and have
> the same report filters. Is there a way to set it up so I only have to
> change the report filter selection on one pivot table and the data will be
> updated in both? I am fairly comfortable with VBA so any solution/suggestion
> is welcomed.
>
> Thanks for any help.
From: Herbert Seidenberg on 2 Feb 2010 22:32
Excel 2007 PivotTable
Sync multiple PT Report Filters.
Show filter selection on PivotChart
With macro.
http://www.mediafire.com/file/ydwximyxjwx/02_02_10.xlsm
 |  Next  |  Last
Pages: 1 2
Prev: excel chart in word
Next: VB Code to Change the Color on boxes - gradient