EnableRefresh Property

See Also         Example         Applies To

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.

For OLAP data sources, setting this property to False disables updates.