Export (0) Print
Expand All

PivotCache.UseLocalConnection Property

Office 2007
Returns True if the LocalConnection property is used to specify the string that enables Microsoft Excel to connect to a data source. Returns False if the connection string specified by the Connection property is used. Read/write Boolean.

Syntax

expression.UseLocalConnection

expression   A variable that represents a PivotCache object.

Example
This example sets the connection string of the first PivotTable cache to reference an offline cube file.

Visual Basic for Applications
With ActiveWorkbook.PivotCaches(1)
    .LocalConnection = _
        "OLEDB;Provider=MSOLAP;Data Source=C:\Data\DataCube.cub"
    .UseLocalConnection = True
End With
		



Community Additions

ADD
Show:
© 2014 Microsoft