expression.GenerateGetPivotData
expression Required. An expression that returns one of the objects in the Applies To list.
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