Trigger running Macro on updating Pivot Table

[Ken_Star]

Is it possible to trigger a macro to run when I update a pivot table? I am running Excel 2016. I did do a search but can't find any information on this.

 

[Norie]

Have you looked at the various pivot table sheet events?

For example Worksheet_PivotTableAfterValueChange and Worksheet_PivotTableUpdate?

 

[Ken_Star]

Thanks Norie.

I am a novice in terms of VBA. Do I create a procedure like the following and call my procedure where the message box is?

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable) 
 
 MsgBox "The PivotTable connection has been updated." 
 
End Sub

 

[Ken_Star]

My macro is creating a an x-y scatter chart from the pivot table data. Unfortunately this type of chart isn't available as a pivot chart as far as I know. So I want the chart to update every time I refresh the pivot table.