EnableRefresh Property

Applies To

PivotCache object, QueryTable object.

Description

True if the PivotTable cache or query table can be refreshed by the user. The default value is True. Read/write Boolean.

Remarks

The RefreshOnFileOpen property is ignored if the EnableRefresh property is set to False.

See Also

RefreshOnFileOpen property.

Example

This example sets the PivotTable so that it cannot be refreshed.

Worksheets(1).PivotTables("Pivot1") _
    .PivotCache.EnableRefresh = False