Application.GenerateGetPivotData Property

Syntax

expression.GenerateGetPivotData

expression A variable that represents an Application object.

Example

In the following example, Microsoft Excel determines the status of getting PivotTable report data and notifies the user. This example assumes a PivotTable report exists on the active worksheet.

Sub PivotTableInfo() ' Determine the ability to get PivotTable report data and notify user. If Application.GenerateGetPivotData = True Then MsgBox "The ability to get PivotTable report data is enabled." Else Msgbox "The ability to get PivotTable report data is disabled." End If End Sub

See also:

• Application Object
• Application Object Members