Pivot Cache Properties

Name

Returns

Description

ADOConnection

Object

Read-only. Returns an ADO connection object if the PivotCache is connected to an OLE DB data source

Background Query

Boolean

Set/Get if the processing of queries in a PivotTable report is done asynchronously. False for OLAP data sources

CommandText

Variant

Set/Get the SQL command used to retrieve data

CommandType

XlCmdType

Set/Get the type of ComandText (for example, xlCmdSQL, xlCmdTable)

Connection

Variant

Set/Get the OLE DB connection string, ODBC string, web data source, path to a text file, or path to a database

EnableRefresh

Boolean

Set/Get whether the PivotTable cache data can be refreshed. Always False for OLAP data sources

Index

Long

Read-only. Returns the spot in the collection for the specific cache

IsConnected

Boolean

Read-only. Returns whether the PivotCache is still connected to a data source

Local

Connection

String

Set/Get the connection string to an offline cube file. Blank for non-OLAP data sources. Use with UseLocal-Connection

Maintain Connection

Boolean

Set/Get whether the connection to the data source does not close until the workbook is closed. Valid only against an OLE DB source

MemoryUsed

Long

Read-only. Returns the number of bytes used by the PivotTable cache

Missingltems Limit

XlPivot Table Missing Items

Set/Get the maximum number of unique items that are retained per PivotTable field, even when they have no supporting data in the cache records

OLAP

Boolean

Read-only. Returns whether the PivotCache is connected to an OLAP server

OptimizeCache

Boolean

Set/Get whether the PivotTable cache is optimized when it is built. Always False for OLE DB data sources

QueryType

xlQuery Type

Read-only. Returns the type of connection associated with the query table. (For example, xlOLEDBQuery, xlDAOQuery, xlTextlmport)

Name

Returns

Description

RecordCount

Long

Read-only. Returns the number of records in the Pivot-Table cache

Recordset

Object

Set/Get the recordset used as the data source for the PivotTable cache

RefreshDate

Date

Read-only. Returns the date the cache was last refreshed

RefreshName

String

Read-only. Returns the name of the person who last refreshed the cache

RefreshOnFile Open

Boolean

Set/Get whether the PivotTable cache is refreshed when the workbook is opened

RefreshPeriod

Long

Set/Get how long (in minutes) between automatic refreshes from the data source. Set to 0 to disable

RobustConnect

XlRobust Connect

Set/Get the method by which the PivotCache connects to its data source

SavePassword

Boolean

Set/Get whether an ODBC connection password is saved with the query table

Source

Connection

File

String

Set/Get the name of the file that was used to create the PivotTable

SourceData

Variant

Set/Get the data source for the PivotTable report

SourceData File

String

Read-only. Returns the name of the source data file for the PivotCache

TableSource

Type

Read-only. Returns a value that identifies the type of item being published

UpgradeOnRefresh

Boolean

Set/Get whether to upgrade the PivotCache and all connected PivotTables on the next refresh

UseLocal Connection

Boolean

Set/Get if the LocalConnection property is used to set the data source. False means the Connection property is used. Allows you to store some data sources offline

Version

Variant

Read-only. Returns the version in which the PivotTable was created

Workbook Connection

Variant

Read-only. Establishes a connection between the active workbook and the PivotCache object

0 0

Post a comment