PivotTable.InGridDropZones Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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.

public:
 property bool InGridDropZones { bool get(); void set(bool value); };

public bool InGridDropZones { get; set; }

Public Property InGridDropZones As Boolean

Property Value

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.

Applies to