QueryTable.EnableRefresh Property
True if the PivotTable cache or query table can be refreshed by the user. The default value is True. Read/write Boolean.
Syntax
expression.EnableRefresh
expression A variable that represents a QueryTable object.
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.