Pivot Table

[saran26]

Hi All,

I jave a pivot table in my excel sheet with a specified range.

When values are changed in the excel sheet the pivot table is not changing its contents automatically.

I have top manualy do an refresh. How to avoid this


How to change the pivot table , so that when ever any thing is changed in the range, the pivot tables gets the values automatically.


Please let me knoW



Thanks
Saran

[Chance2]

Are you just talking about the data change or are you adding rows (selection change)?

If you are just talking about data, then you could add code to the data worksheet's SelectionChange module...

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Sheets("Sheet2").PivotTables("PivotTable2").PivotCache.Refresh
End Sub

In my example "Sheet2" is the sheet name with the pivot table and "PivotTable2" is the pivot table name.

It is a little more complicated if you are adding rows, but basically you could add your rows and then record a macro of the pivot wizard. You will still need some coding, but I think you'll get the idea.