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)
Syntax
'Declaration
Public Function PivotCaches As PivotCaches
'Usage
Dim instance As Workbook
Dim returnValue As PivotCaches
returnValue = instance.PivotCaches()
public PivotCaches PivotCaches()
public:
PivotCaches^ PivotCaches()
public function PivotCaches() : PivotCaches
Return Value
Type: PivotCaches
A PivotCaches collection that represents all the PivotTable caches in the specified workbook.
Examples
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 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
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.