Application.GenerateGetPivotData Property (Excel)
Returns True when Microsoft Excel can get PivotTable report data. Read/write Boolean.
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