PivotTable.RepeatAllLabels Method (Excel)
Specifies whether to repeat item labels for all PivotFields in the specified PivotTable.
Version Information
Version Added: Excel 2010
Syntax
expression .RepeatAllLabels(Repeat)
expression A variable that represents a PivotTable object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Repeat |
Required |
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.