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)

Syntax

'Declaration
<GuidAttribute("0002441C-0000-0000-C000-000000000046")> _
<InterfaceTypeAttribute()> _
Public Interface PivotCache
'Usage
Dim instance As PivotCache
[GuidAttribute("0002441C-0000-0000-C000-000000000046")]
[InterfaceTypeAttribute()]
public interface PivotCache

Remarks

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.

See Also

Reference

PivotCache Members

Microsoft.Office.Interop.Excel Namespace