AllowEdits Property

GroupLevel object:  Returns or sets a Boolean that represents whether the user can edit records in the specified group. Set this property to False to prevent users from editing records in a group. The default value is True. Read/write.

PivotView object: Returns or sets a Boolean that represents whether the user can edit cells in the detail area of a PivotTable list. Set this property to True to allow the user to edit cells in the detail area. The default value is False. Read/write.

expression   Required. An expression that returns a GroupLevel or PivotView object.

Remarks

Changing a cell value results in a corresponding change in the source database. Fields that are marked as read-only in the source database cannot be edited in the PivotTable list.

Example

This example enables editing in the detail area of PivotTable1.

PivotTable1.ActiveView.AllowEdits = True