Edit

Share via

PivotField.RepeatLabels property (Excel)

  • Article

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

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.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.