Expand Minimize

Application.GenerateGetPivotData Property (Excel)

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

expression .GenerateGetPivotData

expression A variable that represents an Application object.

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
Show:
© 2014 Microsoft