AllowEdits Property

  • Article

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

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.AllowEdits

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