Causes of "A...sheet you want to move...contains "wrn.BCOMP"?

R

ronilynn

When attempting to "move or copy" a worksheet I receive a message stating "A
formula or sheet you want to move or copy contains the name 'wrn.BCOMP.',
which already exists on the destination worksheet. Do you want to use this
version of the name?"
What causes this message or how do I correct whatever is on the sheet that
is causing it?
 
D

Dave Peterson

Excel creates names when it needs them. And some of those names are hidden from
the user.

Get 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

And you may find a bunch of hidden names that you never knew existed.

ps. I think some wrn.* names are created when you use Report Manager. (But
I've seen them in other workbooks/worksheets when I never used Report Manager,
too.)
 

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
HELP - A formula or sheet you want to move or copy contains the name .... 0
'copy or move' name conflict 3
ERROR 2
Yes no drop down list and macros 4
"Name" Issue? 1
Move/Copy sheet to another workbook error 2
Unexpected message when first opening this 2007 Excel file 1

Top