View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Carla Bradley Carla Bradley is offline
external usenet poster
 
Posts: 4
Default 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
.