pivot tables

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

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.
 
Anyone got any help that doesn't cost anything?

trip_to_tokyo said:
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.
Click to expand...
 
how about creating VB code that you can have a button ?

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

Debar Dalgleish has some examples in her download at
http://www.contextures.com/PivotMultiPagesDiffChange.zip

--
Regards
Roger Govier

Mike said:
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.

__________ Information from ESET Smart Security, version of virus
signature database 4830 (20100203) __________

The message was checked by ESET Smart Security.

http://www.eset.com
Click to expand...

__________ Information from ESET Smart Security, version of virus signature database 4830 (20100203) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
Back
Top