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



kcc wrote:
>
> 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

--

Dave Peterson
(E-Mail Removed)

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

"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>
>
> kcc wrote:
> >
> > 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
>
> --
>
> Dave Peterson
> (E-Mail Removed)

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

On Sat, 18 Sep 2004 15:46:28 GMT, "kcc" <(E-Mail Removed)> wrote:

>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
>
>"Dave Peterson" <(E-Mail Removed)> wrote in message
>news:(E-Mail Removed)...
>> 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
>>
>>
>>
>> kcc wrote:
>> >
>> > 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
>>
>> --
>>
>> Dave Peterson
>> (E-Mail Removed)
>