PivotField.RepeatLabels Property (Excel)

Returns or sets whether item labels are repeated in the PivotTable for the specified PivotField. Read/write

Version Information

Version Added: Excel 2010

Syntax

expression .RepeatLabels

expression A variable that represents a PivotField object.

Return Value

Boolean

Remarks

True if item labels are repeated for the specified PivotField; otherwise False.

The setting of the RepeatLabels property corresponds to the Repeat item labels check box on the Layout & Print tab of the Field Settings dialog box for a field in a PivotTable.

To specify whether to repeat item labels for all PivotFields in a PivotTable in a single operation, use the RepeatAllLabels method.

See Also

Concepts

PivotField Object

PivotField Object Members