WorkbookBase.PivotCaches Method

Gets a Microsoft.Office.Interop.Excel.PivotCaches collection that represents all the PivotTable caches in the specified workbook.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

Syntax

'Declaration
Public Function PivotCaches As PivotCaches
public PivotCaches PivotCaches()

Return Value

Type: Microsoft.Office.Interop.Excel.PivotCaches
A Microsoft.Office.Interop.Excel.PivotCaches collection that represents all the PivotTable caches in the specified workbook.

Examples

The following code example uses the PivotCaches method to set each Microsoft.Office.Interop.Excel.PivotCache in the current workbook to update automatically each time the workbook is opened.

This example is for a document-level customization.

Private Sub WorkbookPivotCaches()
    Dim caches As Excel.PivotCaches = Me.PivotCaches()

    If Not (caches Is Nothing) Then 
        Dim i As Integer 
        For i = 1 To caches.Count
            caches(i).RefreshOnFileOpen = True 
        Next i
    End If 
End Sub
private void WorkbookPivotCaches()
{
    Excel.PivotCaches caches = this.PivotCaches();

    if (caches != null)
    {
        for (int i = 1; i < caches.Count; i++)
        {
            caches[i].RefreshOnFileOpen = true;
        }
    }
}

.NET Framework Security

See Also

Reference

WorkbookBase Class

Microsoft.Office.Tools.Excel Namespace