Page tree
Skip to end of metadata
Go to start of metadata

Introduced in build 8.4


Returns the maximum number of items the PivotTable's cache can support.



Depending on various factors such as what version of Excel your PivotTable was originally created in, if it is a classic PivotTable or not, etc, the PivotTable's cache will have different maximum capacities of items it can retain. You can use the Max method to determine what the PivotTable can support.
  • No labels