Cannot copy a sheet
 

I'm posting this in the programming section because I
think I'll have to get into VBA to find the solution.
Although I may be a decent excel user, I bite at the
programming end.

I have a client with Excel 2002. She has a large linked
spreadsheet. Recently when she tries to copy one of the
sheets, she gets the following sequence of errors.

"A forumla or sheet you want to move or copy contains the
name 'Choices_Wrapper', which alredy exists on the
destination worksheet. Do you want to sue this version of
the name?
- To use the name as 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
Conflice dialog box"

If I click no, it will prompt me to rename. I pick
something and get the next error. If I click yes, I
immediately get the same error.

"A forumla or sheet you want to move or copy contains the
name 'Comp', which alredy exists on the destination
worksheet. Do you want to sue this version of the name?
- To use the name as 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
Conflice dialog box"

If I click no, it will prompt me to rename. I pick
something and get the next error. If I click yes, I
immediately get the same error.

"A forumla or sheet you want to move or copy contains the
name 'test', which alredy exists on the destination
worksheet. Do you want to sue this version of the name?
- To use the name as 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
Conflice dialog box"

Then the sheet copies. I've checked hidden sheets and
everything and there are no sheets named with those
names.

Any ideas?
Carla

Cannot copy a sheet
 

Ok I may have answered my own question. I went to names,
then define and saw them listed. I deleted them on my
version of the document and it copied with no errors.
However I don't know what they were using them for. Is
there an easy way to tell?

-----Original Message-----
I'm posting this in the programming section because I
think I'll have to get into VBA to find the solution.
Although I may be a decent excel user, I bite at the
programming end.

I have a client with Excel 2002. She has a large linked
spreadsheet. Recently when she tries to copy one of the
sheets, she gets the following sequence of errors.

"A forumla or sheet you want to move or copy contains
the
name 'Choices_Wrapper', which alredy exists on the
destination worksheet. Do you want to sue this version
of
the name?
- To use the name as 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
Conflice dialog box"

If I click no, it will prompt me to rename. I pick
something and get the next error. If I click yes, I
immediately get the same error.

"A forumla or sheet you want to move or copy contains
the
name 'Comp', which alredy exists on the destination
worksheet. Do you want to sue this version of the name?
- To use the name as 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
Conflice dialog box"

If I click no, it will prompt me to rename. I pick
something and get the next error. If I click yes, I
immediately get the same error.

"A forumla or sheet you want to move or copy contains
the
name 'test', which alredy exists on the destination
worksheet. Do you want to sue this version of the name?
- To use the name as 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
Conflice dialog box"

Then the sheet copies. I've checked hidden sheets and
everything and there are no sheets named with those
names.

Any ideas?
Carla
.

Cannot copy a sheet
 

Look at formulas that now show errors, probably #NAME errors.

--
Regards,
Tom Ogilvy

"Carla Bradley" wrote in message
...
Ok I may have answered my own question. I went to names,
then define and saw them listed. I deleted them on my
version of the document and it copied with no errors.
However I don't know what they were using them for. Is
there an easy way to tell?

-----Original Message-----
I'm posting this in the programming section because I
think I'll have to get into VBA to find the solution.
Although I may be a decent excel user, I bite at the
programming end.

I have a client with Excel 2002. She has a large linked
spreadsheet. Recently when she tries to copy one of the
sheets, she gets the following sequence of errors.

"A forumla or sheet you want to move or copy contains
the
name 'Choices_Wrapper', which alredy exists on the
destination worksheet. Do you want to sue this version
of
the name?
- To use the name as 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
Conflice dialog box"

If I click no, it will prompt me to rename. I pick
something and get the next error. If I click yes, I
immediately get the same error.

"A forumla or sheet you want to move or copy contains
the
name 'Comp', which alredy exists on the destination
worksheet. Do you want to sue this version of the name?
- To use the name as 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
Conflice dialog box"

If I click no, it will prompt me to rename. I pick
something and get the next error. If I click yes, I
immediately get the same error.

"A forumla or sheet you want to move or copy contains
the
name 'test', which alredy exists on the destination
worksheet. Do you want to sue this version of the name?
- To use the name as 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
Conflice dialog box"

Then the sheet copies. I've checked hidden sheets and
everything and there are no sheets named with those
names.

Any ideas?
Carla
.