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.

Syntax

expression.SheetPivotTableUpdate(Sh, Target)

expression   An expression that returns a Workbook object.

Parameters

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

Example

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

ADD
Show:
© 2015 Microsoft