PivotTable.InGridDropZones PivotTable.InGridDropZones 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.

 property bool InGridDropZones { bool get(); void set(bool value); };
public bool InGridDropZones { get; set; }
Public Property InGridDropZones As Boolean

Property Value


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.

Applies to