pivot tables

[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.

 

[Mike]

Anyone got any help that doesn't cost anything?

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.

 

[Don]

how about creating VB code that you can have a button ?

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

 

[Herbert Seidenberg]

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

 

[Roger Govier]

Hi Mike

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

--
Regards
Roger Govier

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

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

The message was checked by ESET Smart Security.

http://www.eset.com