Skip to content

Excel.Application.GenerateGetPivotData.md

Latest commit

 

History

History
47 lines (29 loc) · 1.15 KB

Excel.Application.GenerateGetPivotData.md

File metadata and controls

47 lines (29 loc) · 1.15 KB
title Application.GenerateGetPivotData property (Excel)
keywords vbaxl10.chm133275
f1_keywords
vbaxl10.chm133275
api_name
Excel.Application.GenerateGetPivotData
ms.assetid 83effd5f-5101-ba1b-ab45-722e26074ea7
ms.date 04/04/2019
ms.localizationpriority medium

Application.GenerateGetPivotData property (Excel)

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.

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

[!includeSupport and feedback]