This documentation is archived and is not being maintained.

EnableDataValueEditing Property [Excel 2003 VBA Language Reference]

Office 2003

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.


expression Required. An expression that returns a PivotTable object.


Any editing performed on data values is lost upon refresh.


This example determines the alert setting for overwriting values in the data area and notifies the user. The example assumes 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."
        MsgBox "Alert is disabled."
    End If

End Sub

Applies to | PivotTable Object