_QueryTable.MaintainConnection _QueryTable.MaintainConnection _QueryTable.MaintainConnection Property


True if the connection to the specified data source is maintained after the refresh and until the workbook is closed. The default value is True. Read/write Boolean.

 property bool MaintainConnection { bool get(); void set(bool value); };
public bool MaintainConnection { get; set; }
Public Property MaintainConnection As Boolean
Property Value


You can set the MaintainConnection property only if the QueryType property of the query table or PivotTable cache is set to xlOLEDBQuery.

If you anticipate frequent queries to a server, setting this property to True might improve performance by reducing reconnection time. Setting the property to False causes an open connection to be closed.

Applies to