Edit

PivotCache.MakeConnection Method

  • Reference

Definition

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

Establishes a connection for the specified PivotTable cache.

public:
 void MakeConnection();
public void MakeConnection ();
Public Sub 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.

Applies to