This documentation is archived and is not being maintained.

PivotCache Interface 

Represents the memory cache for a PivotTable report.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in

Public Class ivotCacheImplementation
	Implements PivotCache
End Class
Dim ivotCacheImplementation1 As New ivotCacheImplementation()

public interface PivotCache
public interface PivotCache
public interface PivotCache

The PivotCache object is a member of the PivotCaches collection.

Use the PivotCache method to return a PivotCache object for a PivotTable report (each report has only one cache).

Use PivotCaches(index), where index is the PivotTable cache number, to return a single PivotCache object from the PivotCaches collection for a workbook.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms