PivotCache.MaintainConnection Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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.

public:
 property bool MaintainConnection { bool get(); void set(bool value); };

public bool MaintainConnection { get; set; }

Public Property MaintainConnection As Boolean

Property Value

Boolean

Remarks

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