PivotCache and PivotCaches Members

Use the PivotCache collection to create new pivot caches. Use the Workbook object’s PivotCaches property to get a reference to this collection. Use the PivotCache object to create new pivot tables from the cache, to set the data source, and to refresh the cache. The PivotCaches collection and PivotCache object have the following members. Key members (shown in bold) are covered in the following reference section:

1 Collection only

2 Object and collection

Add 1

ADOConnection

Application 2

BackgroundQuery

CommandText

CommandType

Connection

Count 1

CreatePivotTable

Creator 2

EnableRefresh

Index

IsConnected

Item 1

LocalConnection

MaintainConnection

MakeConnection

MemoryUsed

MissingItemsLimit

OLAP

OptimizeCache

Parent 2

QueryType

RecordCount

Recordset

Refresh

RefreshDate

RefreshName

RefreshOnFileOpen

RefreshPeriod

ResetTimer

RobustConnect

SaveAsODC

SavePassword

SourceConnectionFile

SourceData

SourceDataFile

SourceType

Sql

UseLocalConnection

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial