Skip to content

Latest commit

 

History

History
55 lines (33 loc) · 1.38 KB

Excel.PivotTable.DisplayEmptyRow.md

File metadata and controls

55 lines (33 loc) · 1.38 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
PivotTable.DisplayEmptyRow property (Excel)
vbaxl10.chm235153
vbaxl10.chm235153
Excel.PivotTable.DisplayEmptyRow
c1e20ff1-44db-47a0-8e4b-7db7d2ad7cb2
05/08/2019
medium

PivotTable.DisplayEmptyRow property (Excel)

Returns True when the non-empty MDX keyword is included in the query to the OLAP provider for the category axis. The OLAP provider will not return empty rows in the result set. Returns False when the non-empty keyword is omitted. Read/write Boolean.

Syntax

expression.DisplayEmptyRow

expression A variable that represents a PivotTable object.

Remarks

The PivotTable must be connected to an Online Analytical Processing (OLAP) data source to avoid a run-time error.

Example

This example determines the display settings for empty rows in a PivotTable. It assumes that a PivotTable connected to an OLAP data source exists on the active worksheet.

Sub CheckSetting() 
 
 Dim pvtTable As PivotTable 
 
 Set pvtTable = ActiveSheet.PivotTables(1) 
 
 ' Determine display setting for empty rows. 
 If pvtTable.DisplayEmptyRow = False Then 
 MsgBox "Empty rows will not be displayed." 
 Else 
 MsgBox "Empty rows will be displayed." 
 End If 
 
End Sub

[!includeSupport and feedback]