How do pivot tables get numbered

[Dave_DI]

I'm creating pivot tables with VBA and I'd like to know how excel determines the number that the pivot table uses:
Example - TableName:= "PivotTablex" where x is some number. Is there a way that I can control that number?

[CK76]

It's in order of creation within given workbook. Even if you delete one, number is always incremented by 1 from largest in workbook.

You can control it by naming PivotTable using code.
Ex:Assuming you are creating pivot cache as you create pivot table.

Please Login or Register  to view this content.

So table name is set using TableName:="string". You can construct this using variable and control what number is tacked on at the end, if so desired.

Note: PivotTable name must be unique within given workbook.