Export (0) Print
Expand All
Expand Minimize

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



Community Additions

ADD
Show:
© 2014 Microsoft