Pivot Table Macro issue.

[expeo]

I am trying to create a macro to create a pivot table with the data present. I have two issues below.

Please Login or Register  to view this content.

Is there a way I can predetermine the name or have the count of the PivotTable names reset (so it goes back to PivotTable1 instead of PivotTable3, PivotTable4, etc.) every time I run the macro?

[sktneer]

Don't use TableName parameter in CreatePivotTable statement and it will name the Pivot Table automatically to default on the basis of next available Pivot Table Index.