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 wrote:
>
> 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

[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" <petersod@verizonXSPAM.net> wrote in message
news:4421C663.117EC871@verizonXSPAM.net...
> 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 wrote:
>>
>> 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

[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 wrote:
>
> 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" <petersod@verizonXSPAM.net> wrote in message
> news:4421C663.117EC871@verizonXSPAM.net...
> > 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 wrote:
> >>
> >> 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

--

Dave Peterson