PivotTable.RepeatItemsOnEachPrintedPage Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

True if row, column, and item labels appear on the first row of each page when the specified PivotTable report is printed. False if labels are printed only on the first page. The default value is True. Read/write Boolean.

public:
 property bool RepeatItemsOnEachPrintedPage { bool get(); void set(bool value); };

public bool RepeatItemsOnEachPrintedPage { get; set; }

Public Property RepeatItemsOnEachPrintedPage As Boolean

Property Value

Boolean

Remarks

The PivotTable report must be the only one in the print area. To set an indented format for a PivotTable report, use the Format(XlPivotFormatType) method.

Microsoft Excel prints row and column labels in place of any print titles set for the worksheet. Use the PrintTitles property to determine whether print titles are set for the PivotTable report.

Applies to