Expand Minimize

XlLayoutFormType Enumeration (Excel)

Published: July 16, 2012

Specifies the way the specified PivotTable items appear—in table format or in outline format.

Version Added: Excel 2007

Name

Value

Description

xlOutline

1

The LayoutSubtotalLocation property specifies where the subtotal appears in the PivotTable report.

xlTabular

0

Default.

Community Additions

ADD
Show:
© 2014 Microsoft