Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
refresh event pivot
I'd like to know simple code to trigger my code on a refresh or change event
on a pivot. Just not sure how to get it to activate.. thanks, -- Regards, Donica |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
refresh event pivot
If you are using XL2002 or better then there is a refresh table event in VBA.
In the sheet with the pivot table add this code... Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable) End Sub If you are using a version of XL prior to 2002 then there is no event and you need to catch the calculate event or something similar which carries a lot of overhead with it... -- HTH... Jim Thomlinson "Donica" wrote: I'd like to know simple code to trigger my code on a refresh or change event on a pivot. Just not sure how to get it to activate.. thanks, -- Regards, Donica |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create refresh button in worksheet to refresh Pivot Table Data | Excel Worksheet Functions | |||
refresh a new worsheet on pivot table refresh | Excel Worksheet Functions | |||
Timing of automatic query refresh and macro pivot table refresh | Excel Programming | |||
Pivot Table Refresh VBA Event | Excel Programming | |||
Pivot Table REFRESH Flaw -- Saves Old Data in Selection Area AFTER REFRESH | Excel Programming |