Hi,
Im trying to use the following VBA code to auto-refresh some pivot tables:
Private Sub Worksheet_Activate()
Dim pt As PivotTable
For Each pt In Me.PivotTables
pt.RefreshTable
Next pt
End Sub
However, i want the code to be amended so that the pivot tables on the worksheet...