Update pivot when another pivot changes

[simico]

Hey,

Excel 2007 and Windows XP.

I'm trying to get one pivot table to refresh when the data showing on another one changes. I'm not really sure this is the best way to go, but here's what I have so far, that is not doing anything.

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
Sheet1.PivotTables(2).PivotCache.Refresh
End Sub

 

[simico]

Bump for morning ideas.....