The PivotTableSettings class contains the set of properties specific to pivot tables. To get a PivotTableSettings object, use PivotTable.PivotTableSettings.
PivotTableSettings
public sealed class PivotTableSettings
Public NotInheritable Class PivotTableSettings
Name
Description
RefreshOnOpen