Auto Refresh PivotTable on Data change

[shill88]

I have a Data List on one Worksheet and a PivotTable that is using tha
Data List to retrieve its information. I would like the PivotTable t
automatically update itself as soon as there is a change to the Dat
List. I found something simular to this when I searched for aut
refresh Pivto Table but I could really understand what they were sayin
to do.

Thanks
Shaw

 

[Debra Dalgleish]

You could use an event procedure to refresh the pivot table when its
sheet is activated. For example:

Private Sub Worksheet_Activate()
ActiveSheet.PivotTables(1).PivotCache.Refresh
End Sub