expression.AllowDeletions
expression Required. An expression that returns a GroupLevel or PivotView object.
Remarks
Any records that are deleted from the detail area of a PivotTable list are also deleted from the source database. The user cannot delete records from the detail area of the PivotTable list if the source recordset does not allow deletions.
Example
This example allows the user to delete records from the detail area of PivotTable1.
PivotTable1.ActiveView.AllowDeletions = True