Auto refresh pivot tables vba code

[imran ashraf]

Hi. with VBA code i need that the all pivot tables in workbook updated when any make change in the sheets not with any button to click .just instantly changes happen when change the data.

Many Thanks

 

[mole999]

Private Sub Worksheet_Change(ByVal Target As Range)
ActiveWorkbook.RefreshAll
End Sub

 

[imran ashraf]

Thank ..can you help me the code auto refresh the pivot chart .
"Input Values " the name of sheet where i put the data
"Dashboard" the name of sheet where pivot chart.

i want when i put the data into sheet Input Values the Pivot chart auto refresh. Many Thanks