Share via


PivotCache.RefreshPeriod Property (Excel)

Returns or sets the number of minutes between refreshes. Read/write Long.

Syntax

expression .RefreshPeriod

expression A variable that represents a PivotCache object.

Remarks

Setting the period to 0 (zero) disables automatic timed refreshes and is equivalent to setting this property to Null.

The value of the RefreshPeriod property can be an integer from 0 through 32767.

Example

This example sets the refresh period for the PivotTable cache (PivotTable3) to 15 minutes.

Set objPC = Worksheets("Sheet1").PivotTables("PivotTable3").PivotCache 
objPC.RefreshPeriod = 15

See Also

Concepts

PivotCache Object

PivotCache Object Members