PivotCache Object Members

  • Article
Excel Developer Reference

Represents the memory cache for a PivotTable report.

Methods

  Name Description
Bb256066.methods(en-us,office.12).gif CreatePivotTable Creates a PivotTable report based on a PivotCache object. Returns a PivotTable object.
Bb256066.methods(en-us,office.12).gif MakeConnection Establishes a connection for the specified PivotTable cache.
Bb256066.methods(en-us,office.12).gif Refresh Causes the specified chart to be redrawn immediately.
Bb256066.methods(en-us,office.12).gif ResetTimer Resets the refresh timer for the specified query table or PivotTable report to the last interval you set using the RefreshPeriod property.
Bb256066.methods(en-us,office.12).gif SaveAsODC Saves the PivotTable cache source as an Microsoft Office Data Connection file.

Properties

  Name Description
Bb256066.properties(en-us,office.12).gif ADOConnection Returns an ADO Connection object if the PivotTable cache is connected to an OLE DB data source. The ADOConnection property exposes the Microsoft Excel connection to the data provider, allowing the user to write code within the context of the same session that Excel is using with ADO (relational source) or ADO MD (OLAP source). Read-only.
Bb256066.properties(en-us,office.12).gif Application When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
Bb256066.properties(en-us,office.12).gif BackgroundQuery True if queries for the PivotTable report are performed asynchronously (in the background). Read/write Boolean.
Bb256066.properties(en-us,office.12).gif CommandText Returns or sets the command string for the specified data source. Read/write Variant.
Bb256066.properties(en-us,office.12).gif CommandType Returns or sets one of the XlCmdType constants listed in the following table in the remarks section. The constant that is returned or set describes the value of the CommandText property. The default value is xlCmdSQL. Read/write XlCmdType.
Bb256066.properties(en-us,office.12).gif Connection Returns or sets a string that contains one of the following: OLE DB settings that enable Microsoft Excel to connect to an OLE DB data source; ODBC settings that enable Microsoft Excel to connect to an ODBC data source; a URL that enables Microsoft Excel to connect to a Web data source; the path to and file name of a text file, or the path to and file name of a file that specifies a database or Web query. Read/write Variant.
Bb256066.properties(en-us,office.12).gif Creator Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
Bb256066.properties(en-us,office.12).gif EnableRefresh True if the PivotTable cache or query table can be refreshed by the user. The default value is True. Read/write Boolean.
Bb256066.properties(en-us,office.12).gif Index Returns a Long value that represents the index number of the object within the collection of similar objects.
Bb256066.properties(en-us,office.12).gif IsConnected Returns True if the MaintainConnection property is True and the PivotTable cache is currently connected to its source. Returns False if it is not currently connected to its source. Read-only Boolean.
Bb256066.properties(en-us,office.12).gif LocalConnection Returns or sets the connection string to an offline cube file. Read/write String.
Bb256066.properties(en-us,office.12).gif MaintainConnection True if the connection to the specified data source is maintained after the refresh and until the workbook is closed. The default value is True. Read/write Boolean.
Bb256066.properties(en-us,office.12).gif MemoryUsed Returns the amount of memory currently being used by the object, in bytes. Read-only Long.
Bb256066.properties(en-us,office.12).gif MissingItemsLimit Returns or sets the maximum quantity of unique items per PivotTable field that are retained even when they have no supporting data in the cache records. Read/write XlPivotTableMissingItems.
Bb256066.properties(en-us,office.12).gif OLAP Returns True if the PivotTable cache is connected to an Online Analytical Processing (OLAP) server. Read-onlyBoolean.
Bb256066.properties(en-us,office.12).gif OptimizeCache True if the PivotTable cache is optimized when it’s constructed. The default value is False. Read/write Boolean.
Bb256066.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb256066.properties(en-us,office.12).gif QueryType Indicates the type of query used by Microsoft Excel to populate the PivotTable cache. Read-only XlQueryType.
Bb256066.properties(en-us,office.12).gif RecordCount Returns the number of records in the PivotTable cache or the number of cache records that contain the specified item. Read-only Long.
Bb256066.properties(en-us,office.12).gif Recordset Returns or sets a Recordset object that’s used as the data source for the specified PivotTable cache. Read/write.
Bb256066.properties(en-us,office.12).gif RefreshDate Returns the date on which the cache was last refreshed. Read-only Date.
Bb256066.properties(en-us,office.12).gif RefreshName Returns the name of the person who last refreshed the PivotTable cache. Read-only String.
Bb256066.properties(en-us,office.12).gif RefreshOnFileOpen True if the PivotTable cache is automatically updated each time the workbook is opened. The default value is False. Read/write Boolean.
Bb256066.properties(en-us,office.12).gif RefreshPeriod Returns or sets the number of minutes between refreshes. Read/write Long.
Bb256066.properties(en-us,office.12).gif RobustConnect Returns or sets how the PivotTable cache connects to its data source. Read/write XlRobustConnect.
Bb256066.properties(en-us,office.12).gif SavePassword True if password information in an ODBC connection string is saved with the specified query. False if the password is removed. Read/write Boolean.
Bb256066.properties(en-us,office.12).gif SourceConnectionFile Returns or sets a String indicating the Microsoft Office Data Connection file or similar file that was used to create the PivotTable. Read/write.
Bb256066.properties(en-us,office.12).gif SourceData Returns the data source for the PivotTable report, as shown in the following table. Read-write Variant.
Bb256066.properties(en-us,office.12).gif SourceDataFile Returns a String value that indicates the source data file for the cache of the PivotTable.
Bb256066.properties(en-us,office.12).gif SourceType Returns a XlPivotTableSourceType value that represents the type of item being published.
Bb256066.properties(en-us,office.12).gif UpgradeOnRefresh Contains information on whether to upgrade the PivotCache and all connected PivotTables on the next refresh. Read/write Boolean.
Bb256066.properties(en-us,office.12).gif UseLocalConnection 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.
Bb256066.properties(en-us,office.12).gif Version Returns the version of Microsoft Excel in which the PivotCache was created. Read-only.
Bb256066.properties(en-us,office.12).gif WorkbookConnection Establishes a connection between the current workbook and the PivotCache object. Read-only.