Workbook.PivotCaches Method
| Excel Developer Reference |
Returns a PivotCaches collection that represents all the PivotTable caches in the specified workbook. Read-only.
Syntax
expression.PivotCaches
expression A variable that represents a Workbook object.
Return Value
PivotCaches
Example
This example causes the PivotTable cache to update automatically each time the workbook is opened.
| Visual Basic for Applications |
|---|
|
See Also