PivotTable.EnableDataValueEditing Property
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. Read/write Boolean.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property EnableDataValueEditing As Boolean
Get
Set
'Usage
Dim instance As PivotTable
Dim value As Boolean
value = instance.EnableDataValueEditing
instance.EnableDataValueEditing = value
bool EnableDataValueEditing { get; set; }
Property Value
Type: System.Boolean
Remarks
Any editing performed on data values is lost upon refresh.