PivotTable.SmallGrid Property

True if Microsoft Excel uses a grid that’s two cells wide and two cells deep for a newly created PivotTable report. False if Excel uses a blank stencil outline. Read/write Boolean.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Property SmallGrid As Boolean
    Get
    Set
'Usage
Dim instance As PivotTable
Dim value As Boolean

value = instance.SmallGrid

instance.SmallGrid = value
bool SmallGrid { get; set; }

Property Value

Type: System.Boolean

Remarks

You should use the stencil outline. The grid is provided only because it enables compatibility with earlier versions of Excel.

See Also

Reference

PivotTable Interface

PivotTable Members

Microsoft.Office.Interop.Excel Namespace