Export (0) Print
Expand All
Expand Minimize

Workbook.PivotCaches Method (2007 System)

Gets a PivotCaches collection that represents all the PivotTable caches in the specified workbook.

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

public PivotCaches PivotCaches()

Return Value

Type: PivotCaches
A PivotCaches collection that represents all the PivotTable caches in the specified workbook.

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

This example is for a document-level customization.

private void WorkbookPivotCaches()
{
    Excel.PivotCaches caches = this.PivotCaches();

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

Community Additions

ADD
Show:
© 2014 Microsoft