GenerateGetPivotData Property

Returns True when Microsoft Excel can get PivotTable report data. Read/write Boolean.

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