PivotTable.InGridDropZones Property
This property is used to toggle in-grid drop zones for a PivotTable object. In some cases, it also affects the layout of the PivotTable. Read/write.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property InGridDropZones As Boolean
Get
Set
'Usage
Dim instance As PivotTable
Dim value As Boolean
value = instance.InGridDropZones
instance.InGridDropZones = value
bool InGridDropZones { get; set; }
Property Value
Type: System.Boolean
Boolean
Remarks
When the InGridDropZonesproperty is set to True, the in-grid representation of the PivotTable is the same as it was in Excel 2003. When the property is set to False, there are no in-grid drop zones. The PivotTable layout also changes with this property.