CCkfm2000
02-20-2006, 10:26 AM
hi all..
i have a pivot table and i need it to update it when i go to the sheet.
i've come up with the following code see below.
but it only updates the table when i click on a cell.
Private Sub worksheet_selectionchange(ByVal target As Excel.Range)
ActiveSheet.PivotTables("PivotTable1").RefreshTable
End Sub
please help
thanks
i have a pivot table and i need it to update it when i go to the sheet.
i've come up with the following code see below.
but it only updates the table when i click on a cell.
Private Sub worksheet_selectionchange(ByVal target As Excel.Range)
ActiveSheet.PivotTables("PivotTable1").RefreshTable
End Sub
please help
thanks