LayoutForm Property

LayoutForm Property

         Example         Applies To

Returns or sets the way the specified PivotTable items appear—in table format or in outline format. Can be one of the following XlLayoutFormType constants: xlTabular or xlOutline. If xlOutline is specified or returned, the LayoutSubtotalLocation property specifies where the subtotal appears in the PivotTable report. The default value is xlTabular. Read/write XlLayoutFormType.

Remarks

You can set this property for any PivotTable field; however, the formatting appears only if the specified field is a row field other than the innermost (lowest-level) row field. The value of this property doesn’t change when the field is rearranged or when it is added to or removed from the PivotTable report.