Share via


PivotCache.MakeConnection Method

Establishes a connection for the specified PivotTable cache.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Sub MakeConnection
'Usage
Dim instance As PivotCache

instance.MakeConnection()
void MakeConnection()

Remarks

The MakeConnection method can be used after the cache drops a connection and the user wants to re-establish the connection.

Various objects and methods might return a run-time error if the cache is not connected. Use of this method assures a connection before executing other objects or methods.

This method will result in a run-time error if the MaintainConnection property of the specified PivotTable cache has been set to False, the SourceType property of the specified PivotTable cache has not been set to xlExternal, or if the connection is not OLEDB.

See Also

Reference

PivotCache Interface

PivotCache Members

Microsoft.Office.Interop.Excel Namespace