ConnectionParameter property. Flag indicating whether the query should automatically refresh when the contents of a cell that provides the parameter value changes. If true then external Data is refreshed using the new parameter value every time theres a change. If false then external Data is only refreshed when requested by the user or some other event triggers refresh e.g. workbook opened... If true, then external data is refreshed using the new parameter...change. If false, then external data is only refreshed when requested...