when copying sheet, warning that formula or sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark - 31 May 2005 19:29 GMT

When copying a sheet within a workbook, I sometimes get a warning that the
formula or sheet contains a name, do you want to proceed. Many times, the
name is my own name. How do I get rid of these embedded names?

Reply to this Message

Dave Peterson - 31 May 2005 20:37 GMT

I'd 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 decide what you want to do with the name.

> When copying a sheet within a workbook, I sometimes get a warning that the
> formula or sheet contains a name, do you want to proceed. Many times, the
> name is my own name. How do I get rid of these embedded names?

Signature

Dave Peterson

Reply to this Message

Mark - 31 May 2005 20:58 GMT

This seems much too complicated for me. Is there a more simple way? Also,
please see the next message in which I copied down the exact error message.

> I'd get a copy of Jan Karel Pieterse's (with Charles Williams and Matthew
> Henson) Name Manager:
[quoted text clipped - 9 lines]
>> the
>> name is my own name. How do I get rid of these embedded names?

Reply to this Message

Dave Peterson - 31 May 2005 21:09 GMT

Insert|Name|Define|select the name you want to delete and click delete.

Although, I think I'd to that complicated work to make sure I didn't break
something.

> This seems much too complicated for me. Is there a more simple way? Also,
> please see the next message in which I copied down the exact error message.
[quoted text clipped - 16 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message

Mark - 31 May 2005 21:26 GMT

Dave - that doesn't work, as 'mark' doesn't appear when I go to
insert/name/define.

Here is the error message that pops up:

a formula or sheet you want to move or copy contains the name 'mark' which
already
exists on the destination worksheet. Do you want to use this version of the
name?

This happens only once in a while, and I don't know why.

Is there any way to get rid of the name conflicts or whatever is causing
them?

> Insert|Name|Define|select the name you want to delete and click delete.
>
[quoted text clipped - 25 lines]
>> >
>> > Dave Peterson

Reply to this Message

Dave Peterson - 31 May 2005 21:30 GMT

The name may be hidden.

That utility has an option to show hidden names.

> Dave - that doesn't work, as 'mark' doesn't appear when I go to
> insert/name/define.
[quoted text clipped - 44 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message