## PivotTableCalculateOption class

Rerepsents the options of calcuating the pivot table.

## Constructors

| Name | Description |
| --- | --- |
| [PivotTableCalculateOption](#constructor) |  |

## Properties

| Name | Type | Description |
| --- | --- | --- |
| [RefreshData](#refreshdata) | boolean | Indicates whether refreshing data source of the pivottable. |
| [RefreshCharts](#refreshcharts) | boolean | Indicates whether refreshing charts are based on this pivot table. |
| [ReserveMissingPivotItemType](#reservemissingpivotitemtype) | Number | Represents how to reserve missing pivot items. The value of the property is ReserveMissingPivotItemType integer constant |
| [RefreshOption](#refreshoption) | PivotTableRefreshOption |  |

### PivotTableCalculateOption() {#constructor}

### PivotTableCalculateOption.RefreshData property {#refreshdata}

Indicates whether refreshing data source of the pivottable.

**Type:** boolean

### PivotTableCalculateOption.RefreshCharts property {#refreshcharts}

Indicates whether refreshing charts are based on this pivot table.

**Type:** boolean

### PivotTableCalculateOption.ReserveMissingPivotItemType property {#reservemissingpivotitemtype}

Represents how to reserve missing pivot items. The value of the property is ReserveMissingPivotItemType integer constant. Only works when RefreshData is true.

**Type:** Number

### PivotTableCalculateOption.RefreshOption property {#refreshoption}

**Type:** PivotTableRefreshOption