Excel.PivotTable.EnableDataValueEditing.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
PivotTable.EnableDataValueEditing property (Excel)	vbaxl10.chm235141	vbaxl10.chm235141	Excel.PivotTable.EnableDataValueEditing	57b4ed51-46d5-0d9f-d947-cdc45e523095	05/08/2019	medium

PivotTable.EnableDataValueEditing property (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. Read/write Boolean.

Syntax

expression.EnableDataValueEditing

expression A variable that represents a PivotTable object.

Remarks

Any editing performed on data values is lost upon refresh.

Example

This example determines the alert setting for overwriting values in the data area and notifies the user. The example assumes that a PivotTable exists on the active worksheet.

Sub CheckAlertSetting() 
 
 Dim pvtTable As PivotTable 
 
 Set pvtTable = ActiveSheet.PivotTables(1) 
 
 ' Determine alert setting. 
 If pvtTable.EnableDataValueEditing = False Then 
 MsgBox "Alert is enabled." 
 Else 
 MsgBox "Alert is disabled." 
 End If 
 
End Sub

[!includeSupport and feedback]