You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 3
Next »
Introduced in build 8.3
Description
Returns the maximum number of items the pivot table's cache can support.
Depending on various factors such as what version of Excel your pivot table was originally created in, if it is a classic pivot table or not, etc, the pivot tables cache will have different maximum capacities of items it can retain. You can use the Max method to determine what the pivot table can support.