Combining Workbooks - Issue with Names

  • Thread starter Thread starter kcc
  • Start date Start date
K

kcc

I've got a couple of workbooks that include a fair amount of data
from other people's workbooks, now I want to combine these 2.
I'm getting a warning about the pages from one book making
reference to a name that is also in the destination. The problem
is I can't find any indication that the names exists in either book.
At least there is nothing under Name/Define or in Styles.
The 2 names it asks about both are of the form _Table2_xxx.
There are no Tables in the books. I have a vague recollection of
variables starting with _ having some special meaning in some
programming language and thought it might be true here.
What things other than cells can be named? Would Excel create
the name?
kcc
 
I don't recognize the name, but excel does sometimes use names that start with
underscore. But developers can also create hidden names that could start with
an underscore.

You may want to get a copy of Jan Karel Pieterse, Charles Williams and Matthew
Henson's utility called NameManager. It'll help you determine what they
are--and make them visible and even delete.

You can find it at:
http://www.bmsltd.ie/mvp
 
Thanks Dave. The names in question refer to REF's, so whatever the original
purpose, I'm deleting them now. I was surprised to see the large number
of other names that were also hidden. Seems like a function MS should
have included this function in the first place.
kcc
 
kcc

Select several columns and Insert>Name>Create.

Click on Top Row and Left Column and OK.

If you then look at Name>Define you will find a whack of names all starting
with the underscore.

Gord Dibben Excel MVP

Thanks Dave. The names in question refer to REF's, so whatever the original
purpose, I'm deleting them now. I was surprised to see the large number
of other names that were also hidden. Seems like a function MS should
have included this function in the first place.
kcc
Click to expand...
 
Back
Top