AllowEdits Property

Microsoft Office Web Components Visual Basic

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