Skip to content

Latest commit

 

History

History
46 lines (26 loc) · 1.23 KB

Excel.PivotTable.RepeatAllLabels.md

File metadata and controls

46 lines (26 loc) · 1.23 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
PivotTable.RepeatAllLabels method (Excel)
vbaxl10.chm235195
vbaxl10.chm235195
Excel.PivotTable.RepeatAllLabels
4ca1a7fa-4db6-20da-e37b-37445fee30cf
05/09/2019
medium

PivotTable.RepeatAllLabels method (Excel)

Specifies whether to repeat item labels for all PivotFields in the specified PivotTable.

Syntax

expression.RepeatAllLabels (Repeat)

expression A variable that represents a PivotTable object.

Parameters

Name Required/Optional Data type Description
Repeat Required XlPivotFieldRepeatLabels Specifies whether to repeat all field item labels in a PivotTable report.

Return value

Nothing

Remarks

Using the RepeatAllLabels method corresponds to the Repeat All Item Labels and Do Not Repeat Item Labels commands on the Report Layout drop-down list of the PivotTable Tools Design tab.

To specify whether to repeat item labels for a single PivotField, use the RepeatLabels property.

[!includeSupport and feedback]