I have a simple workbook that contains a pivot table worksheet. On that
worksheet I inserted the following code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
ActiveSheet.PivotTables(2).PivotCache.Refresh

End Sub

It does not work. It does not appear to be executing at all. When excel
opens the workbook, I do not get a warning about macros. How do I fix this
to get the code to run?

S. Jackson

I just realized that I had the code wrong and changed it, but the code will
still not run. It will run just fine on the sample TimeChart.xls file I
downloaded from http://www.contextures.com/excelfiles.html#Pivot

Here is the code I have on the worksheet containing the pivot table (fyi,
the source table is on a different sheet):

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


"S Jackson" wrote in message
...
I have a simple workbook that contains a pivot table worksheet. On that
worksheet I inserted the following code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
ActiveSheet.PivotTables(2).PivotCache.Refresh

End Sub

It does not work. It does not appear to be executing at all. When excel
opens the workbook, I do not get a warning about macros. How do I fix
this
to get the code to run?

S. Jackson