I'm having trouble adding a second pivot table to a worksheet. I'm using the
PivotTableWizard method (we use Excel 97) to add the table. The second table
accesses the same Excel database as the first one. Instead of getting a new
table added, I'm getting the first table moved and renamed. Code I'm using
is to create the first and second tables is
where "Name" is a string variable and "StLoc" is a range variable whose
values differ for each table. Any help would be greatly appreciated. Thanks!