Excel.Interfaces.PivotTableUpdateData interface
An interface for updating data on the PivotTable object, for use in pivotTable.set({ ... }).
Properties
| enable |
Specifies if the PivotTable allows values in the data body to be edited by the user. |
| name | Name of the PivotTable. |
| use |
Specifies if the PivotTable uses custom lists when sorting. |
Property Details
enableDataValueEditing
Specifies if the PivotTable allows values in the data body to be edited by the user.
enableDataValueEditing?: boolean;Property Value
boolean
Remarks
name
useCustomSortLists
Specifies if the PivotTable uses custom lists when sorting.
useCustomSortLists?: boolean;Property Value
boolean