Dragging Pivot Fields

The PivotField object has some properties that can prevent the user from moving the field. They are as follows (all default values are True):

DragToColumn property

Set to False to prevent the field from being dragged to the column area.

DragToHide property

Set to False to prevent the field from being hidden by being dragged off of the pivot table.

DragToPage property

Set to False to prevent the field from being dragged to the page field area. DragToRow property

Set to False to prevent the field from being dragged to the row field area.

0 0

Post a comment