Skip to content

Latest commit

 

History

History
42 lines (26 loc) · 1.13 KB

Excel.PivotCache.UseLocalConnection.md

File metadata and controls

42 lines (26 loc) · 1.13 KB
Raw
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
PivotCache.UseLocalConnection property (Excel)
vbaxl10.chm227096
vbaxl10.chm227096
Excel.PivotCache.UseLocalConnection
ce54adf2-22f3-f4dc-8b97-276d6ca53478
05/03/2019
medium

PivotCache.UseLocalConnection property (Excel)

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.

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

[!includeSupport and feedback]