PivotCache interface
Office 2013 and later
Represents the memory cache for a PivotTable report.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
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: