GenerateGetPivotData Property [Excel 2007 Developer Reference]

Switch View :
Classic
Lightweight
ScriptFree
Application.GenerateGetPivotData Property
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

See Also