PivotTableRefreshOption class

Represents the options of refreshing data source of the pivot table.

The PivotTableRefreshOption type exposes the following members:

Constructor	Description
`__init__(self)`	Represents the options of refreshing data source of the pivot table.

Property	Description
reserve_missing_pivot_item_type	Represents how to reserve missing pivot items.
is_keep_original_order	Indicates whether to keep pivot items’ original order as old data source.
keep_cached_local_group_data	Indicates whether to keep cached local group data if the maximum and minimum values remain unchanged. The default value is false which means refreshing group with local setting.