On Jan 7, 5:43*am, bw wrote:
Thanks Cory,

not the answer I was hoping for, but at least I know the direction I need to
go.



" wrote:
On Jan 4, 9:13 am, bw wrote:
Hi there,
I'm trying toresetthe pivottablename that gets generated when you create
a pivottablewithout having to shut downExcel. For example, I create
PivotTable1 and PivotTable2 in a workbook and when I switch to another
workbook, the next pivottablethat gets created is named PivotTable3. How do
Iresetthe 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 usingExcel2003.
Assistance appreciated.

I don't think that's possible because of the wayExcelworks. *When
you open a workbook you're also opening a single instance (copy) of
Excel. *Then, when you open a second workbook inExcel, that second
workbook resides within the first instance ofExcelso the memory is
shared between the two workbooks as far asExcelsees them (look in
Task Manager after opening the second workbook and you'll only see one
listing ofExcel.) *The only way around this, perhaps, would be to
open the second workbook by first opening another instance ofExcel
through the Start menu and then opening the workbook from within that
new instance (File--Open.) *This can be done programmatically also by
creating newExcelobjects for each workbook.

Wow, I hope you can follow that. *Sounded like a riddle reading back
on it.

Hope that helps,

Cory- Hide quoted text -

- Show quoted text -


bw,

I have the exact same problem as you. I've done a lot of searching
with no answer yet. Are you using this in a macro? Is there some
reason you cannot just have excel quit and reopen?