InGridDropZones Property
Collapse the table of content
Expand the table of content

PivotTable.InGridDropZones Property

Office 2007
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 Boolean.

Version Information
 Version Added:  Excel 2007



expression   A variable that represents a PivotTable object.


When the InGridDropZones property 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.

© 2015 Microsoft