PivotCache interface

Represents the memory cache for a PivotTable report.

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

[InterfaceTypeAttribute()]
[GuidAttribute("0002441C-0000-0000-C000-000000000046")]
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.

Show: