CreatePivotTable Method


MakeConnection Method


Refresh Method


ResetTimer Method


SaveAsODC Method

PivotTable Object


Workbook Object

PivotCaches Collection Object


PivotTable Object

ADOConnection Property


Application Property


BackgroundQuery Property


CommandText Property


CommandType Property


Connection Property


Creator Property


EnableRefresh Property


Index Property


IsConnected Property


LocalConnection Property


MaintainConnection Property


MemoryUsed Property


MissingItemsLimit Property


OLAP Property


OptimizeCache Property


Parent Property


QueryType Property


RecordCount Property


Recordset Property


RefreshDate Property


RefreshName Property


RefreshOnFileOpen Property


RefreshPeriod Property


RobustConnect Property


SavePassword Property


SourceConnectionFile Property


SourceData Property


SourceDataFile Property


SourceType Property


UseLocalConnection Property

PivotCell Object


PivotFields Collection Object


PivotFormula Object


PivotItem Object


PivotItemList Collection


PivotLayout Object


PivotTable Object