Share via

Application.GenerateGetPivotData Property (Excel)

  • 아티클

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

Syntax

식 .GenerateGetPivotData

식 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.

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

참고 항목

개념

Application Object

Application Object Members