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.