Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Worksheet.PivotTableUpdate Event

Office 2007
Occurs after a PivotTable report is updated on a worksheet.

Syntax

expression.PivotTableUpdate(Target)

expression   A variable that represents a Worksheet object.

Parameters

NameRequired/OptionalData TypeDescription
TargetRequiredPivotTableThe selected PivotTable report.

Return Value
Nothing

Example

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

Visual Basic for Applications
Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)

    MsgBox "The PivotTable connection has been updated."

End Sub



Community Additions

ADD
Show:
© 2015 Microsoft