Page History

{introducedin: 8.4}


{description}
{excerpt}Returns the maximum number of items the PivotTable's cache can support.{excerpt}
{signature:C#}
public System.String Max{ get; }
{signature}{signature:vb.net}
Public ReadOnly Property Max() As String
{signature}
{remarks}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.
{remarks}
{scrollbar}