PivotCache.RefreshPeriod Property
| Excel Developer Reference |
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.
| Visual Basic for Applications |
|---|
|
See Also