Sheet name already exists

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When copying worksheets (especially multiple times on large spreadsheets), I
often get the following message:

"a form or sheet you want to move or copy contains the name
"wrn.Full._.TRAIL", which already exists on the destination worksheet. Do
you want to use this version of the name?"

If I click yes, I am presented with a number of other names (About 20) that
I don't recognize. Although the copy sheet operation works without causing
Excel to crash, I worry about the integrity of my worksheet.

Any others with this experience, and suggestions toresolve?
 
Excel creates hidden names when it wants. "wrn." can be created when you run
report manager. I've seen it other workbooks when I didn't use the report
manager, too.

I think 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

Then you can clean up those names nice and safely.
 
You must log in or register to reply here.

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

"Name" Issue? 1
'copy or move' name conflict 3
Causes of "A...sheet you want to move...contains "wrn.BCOMP"? 1
ERROR 2
"_Fill" and "_Key1" is contained in the worksheet I want to copy.. 1
Invisible Defined Names 3
Names exist, but I could not find them 1
Yes no drop down list and macros 4

Back
Top