Excel.Interfaces.PivotTableUpdateData interface
An interface for updating data on the PivotTable object, for use in pivotTable.set({ ... })
.
Properties
allow |
Specifies if the PivotTable allows the application of multiple PivotFilters on a given PivotField in the table. |
enable |
Specifies if the PivotTable allows values in the data body to be edited by the user. |
name | Name of the PivotTable. |
refresh |
Specifies whether the PivotTable refreshes when the workbook opens. Corresponds to "Refresh on load" setting in the UI. |
use |
Specifies if the PivotTable uses custom lists when sorting. |
Property Details
allowMultipleFiltersPerField
Specifies if the PivotTable allows the application of multiple PivotFilters on a given PivotField in the table.
allowMultipleFiltersPerField?: boolean;
Property Value
boolean
Remarks
enableDataValueEditing
Specifies if the PivotTable allows values in the data body to be edited by the user.
enableDataValueEditing?: boolean;
Property Value
boolean
Remarks
name
refreshOnOpen
Specifies whether the PivotTable refreshes when the workbook opens. Corresponds to "Refresh on load" setting in the UI.
refreshOnOpen?: boolean;
Property Value
boolean
Remarks
useCustomSortLists
Specifies if the PivotTable uses custom lists when sorting.
useCustomSortLists?: boolean;
Property Value
boolean
Remarks
Office Add-ins
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for