Hi there,
I'm trying to reset the pivot table name that gets generated when you create
a pivot table without having to shut down Excel. For example, I create
PivotTable1 and PivotTable2 in a workbook and when I switch to another
workbook, the next pivot table that gets created is named PivotTable3. How do
I reset the name, as opposed to just naming it while using either the wizard
or programmatically - if I name it PivotTable1, the subsequent one generated
is still named PivotTable4. I'm using Excel 2003.
Assistance appreciated.