Duplicate names on copied worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pat Conover - 22 Mar 2006 20:28 GMT

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

Reply to this Message

Dave Peterson - 22 Mar 2006 22:49 GMT

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.

> 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:
[quoted text clipped - 8 lines]
> 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

Signature

Dave Peterson

Reply to this Message

Pat Conover - 23 Mar 2006 01:59 GMT

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

> Get a copy of Jan Karel Pieterse's (with Charles Williams and Matthew
> Henson)
[quoted text clipped - 29 lines]
>> on
>> microsoft.public.excel.links but haven't seen any responses. Thanks, Pat

Reply to this Message

Dave Peterson - 23 Mar 2006 13:11 GMT

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.

> 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
[quoted text clipped - 37 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message

Pat Conover - 23 Mar 2006 18:19 GMT

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

>I think it does, but you'll know after you try it.
>
[quoted text clipped - 54 lines]
>> >
>> > Dave Peterson

Reply to this Message