Cannot copy a sheet

  • Thread starter Thread starter Carla Bradley
  • Start date Start date
C

Carla Bradley

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
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
Copy adjacent Sheet and name from a list 42
Error Message ...move or copy contains the name xx, which alreadyexists.... 3
Named ranges and pasting formulas with named references 2
Paste Name Questions 10
Can I respond by program for prompt conflict name 1
Macro will copy formula instead of value 6
Create Sheets from a Range and Copy Data on copy Data on newlycreated Sheets with the Sheet Names 2

Back
Top