Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
SheetPivotTableUpdate Event

Workbook.SheetPivotTableUpdate Event

Office 2007
Occurs after the sheet of the PivotTable report has been updated.


expression.SheetPivotTableUpdate(Sh, Target)

expression   An expression that returns a Workbook object.


NameRequired/OptionalData TypeDescription
ShRequiredObjectThe selected sheet.
TargetRequiredPivotTableThe selected PivotTable report.


This example displays a message stating that the sheet of the PivotTable report has been updated. This example assumes you have declared an object of type Application or Workbook with events in a class module.

Visual Basic for Applications
Private Sub ConnectionApp_SheetPivotTableUpdate(ByVal shOne As Object, Target As PivotTable)

    MsgBox "The SheetPivotTable connection has been updated."

End Sub

Community Additions

© 2015 Microsoft