PivotTable.EnableDataValueEditing Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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.

public:
 property bool EnableDataValueEditing { bool get(); void set(bool value); };

public bool EnableDataValueEditing { get; set; }

Public Property EnableDataValueEditing As Boolean

Property Value

Boolean

Remarks

Any editing performed on data values is lost upon refresh.

Applies to