This documentation is archived and is not being maintained.

Application.GenerateGetPivotData Property

Office 2007
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.

Visual Basic for Applications
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



Show: