PivotTable.EnableDataValueEditing (Excel)

True to disable the alert for when the user overwrites values in the data area of the PivotTable. True also allows the user to change data values that previously could not be changed. The default value is False.

Any editing performed on data values is lost upon refresh.

ActiveCell.PivotTable.EnableDataValueEditing = True