Duplicate names on copied worksheet

[Pat Conover]

Hi, I am using Excel 97 and every now and then when I copy a worksheet in
the same workbook to reuse as a new worksheet base, I get an error message:
"A formula or sheet you want to copy or move contains the name 'pat', which
already exists on the destination worksheet. Do you want to use this
version of the name?
To use the name defined in the destination sheet, click Yes.
To rename the range referred to in the formula or worksheet, click No, and
enter a new name in the Name Conflict dialog box.
Yes | No"

Any idea how to find the errors and fix them? I also posted separately on
microsoft.public.excel.links but haven't seen any responses. Thanks, Pat

 

[Dave Peterson]

Get a copy of Jan Karel Pieterse's (with Charles Williams and Matthew Henson)
Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

It'll help you clean up your problem.

These aren't really errors, though. You can only have one global (or workbook)
version of a name (Pat in your example). When you copy that sheet, excel is
smart enough to notice the name and convert it to a local (or worksheet level)
name.

 

[Pat Conover]

Dave, Thanks for the fast response. Still a bit confused about the name
conflicts. Does the NameManager.Zip work with Excel 97? Do I delete them
or rename them to something else? Thanks, Pat

 

[Dave Peterson]

I think it does, but you'll know after you try it.

And it really depends on what you want to do with that name.

If you only need that name on the original worksheet, then you can delete the
local version on the copied worksheet.

If you don't need the name at all, you could delete it to start and never worry
again.

 

[Pat Conover]

Dave thanks again. Is there anywhere I can read up on Excel names? I
searched Google but didn't find anything that explains it clearly. One of
the workbooks with this problem is for a big project and I can't afford to
screw it up! Could I make a copy of the workbook and then play with the
namemanager program, without affecting the original?
Thanks, Pat