Table Layout tab missing
 

Sometimes when I click in a table, the Layout tab is not shown under the
Table Tools tab group. I didn't find any special circumstances that would
case this compared to situations when the Layout tab is shown.

May I miss some conditions causing it to be hidden?

Any idea welcome.

Cheers,
Gus

Table Layout tab missing
 

Gus

I know of no occasions where this doesn't happen except if it is not a
'genuine' table. If it is just a square of contiguous cells it won't
recognise it. Next time it happens try entering a formula and clicking a
cell and you should get something like

=Table1[[#This Row],[3 Yr Cost]]-MAX([3 Yr Cost])

If it is a 'genuine' table, with references to the table rather than the
cell(s) or range name

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk

UK Excel User Conference In Cambridge
November 28th - December 1st 2007
Register Now @ http://www.exceluserconference.com/UKEUC.html



"Gus" wrote in message
...
Sometimes when I click in a table, the Layout tab is not shown under the
Table Tools tab group. I didn't find any special circumstances that would
case this compared to situations when the Layout tab is shown.

May I miss some conditions causing it to be hidden?

Any idea welcome.

Cheers,
Gus

Table Layout tab missing
 

Thanks for your time.

In fact, it was a genuine table inserted into an xlsx workbook and it uses
named references as you mentioned. Currently this one was created from a
range containing data imported from csv, however Excel asked upon creating
the table if I want to merge multiple ranges and disconnect from the original
source€”for which I answered yes. Anyway, I do not remember of such history in
the case of other tables.

But according to what you said: isn't it true that either no tabs should be
displayed or both Table tabs should be displayed at any given time?

Gus

PS: I have marked your reply as an answer since some may have faced with the
problem that you mentioned.

"Nick Hodge" wrote:

Gus

I know of no occasions where this doesn't happen except if it is not a
'genuine' table. If it is just a square of contiguous cells it won't
recognise it. Next time it happens try entering a formula and clicking a
cell and you should get something like

=Table1[[#This Row],[3 Yr Cost]]-MAX([3 Yr Cost])

If it is a 'genuine' table, with references to the table rather than the
cell(s) or range name

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk

UK Excel User Conference In Cambridge
November 28th - December 1st 2007
Register Now @ http://www.exceluserconference.com/UKEUC.html



"Gus" wrote in message
...
Sometimes when I click in a table, the Layout tab is not shown under the
Table Tools tab group. I didn't find any special circumstances that would
case this compared to situations when the Layout tab is shown.

May I miss some conditions causing it to be hidden?

Any idea welcome.

Cheers,
Gus

Table Layout tab missing
 

Gus

There is only one table tab (It is actually a TabSet, called 'Table Tools'
with a tab called 'Design' below), which two tabs are you expecting?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk

UK Excel User Conference In Cambridge
November 28th - December 1st 2007
Register Now @ http://www.exceluserconference.com/UKEUC.html



"Gus" wrote in message
...
Thanks for your time.

In fact, it was a genuine table inserted into an xlsx workbook and it uses
named references as you mentioned. Currently this one was created from a
range containing data imported from csv, however Excel asked upon creating
the table if I want to merge multiple ranges and disconnect from the
original
source€”for which I answered yes. Anyway, I do not remember of such history
in
the case of other tables.

But according to what you said: isn't it true that either no tabs should
be
displayed or both Table tabs should be displayed at any given time?

Gus

PS: I have marked your reply as an answer since some may have faced with
the
problem that you mentioned.

"Nick Hodge" wrote:

Gus

I know of no occasions where this doesn't happen except if it is not a
'genuine' table. If it is just a square of contiguous cells it won't
recognise it. Next time it happens try entering a formula and clicking a
cell and you should get something like

=Table1[[#This Row],[3 Yr Cost]]-MAX([3 Yr Cost])

If it is a 'genuine' table, with references to the table rather than the
cell(s) or range name

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk

UK Excel User Conference In Cambridge
November 28th - December 1st 2007
Register Now @ http://www.exceluserconference.com/UKEUC.html



"Gus" wrote in message
...
Sometimes when I click in a table, the Layout tab is not shown under
the
Table Tools tab group. I didn't find any special circumstances that
would
case this compared to situations when the Layout tab is shown.

May I miss some conditions causing it to be hidden?

Any idea welcome.

Cheers,
Gus

Table Layout tab missing
 

Hm, shouldn' there be a tab called Layout similar to that of Word?

"Nick Hodge" wrote:

Gus

There is only one table tab (It is actually a TabSet, called 'Table Tools'
with a tab called 'Design' below), which two tabs are you expecting?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk

UK Excel User Conference In Cambridge
November 28th - December 1st 2007
Register Now @ http://www.exceluserconference.com/UKEUC.html



"Gus" wrote in message
...
Thanks for your time.

In fact, it was a genuine table inserted into an xlsx workbook and it uses
named references as you mentioned. Currently this one was created from a
range containing data imported from csv, however Excel asked upon creating
the table if I want to merge multiple ranges and disconnect from the
original
source€”for which I answered yes. Anyway, I do not remember of such history
in
the case of other tables.

But according to what you said: isn't it true that either no tabs should
be
displayed or both Table tabs should be displayed at any given time?

Gus

PS: I have marked your reply as an answer since some may have faced with
the
problem that you mentioned.

"Nick Hodge" wrote:

Gus

I know of no occasions where this doesn't happen except if it is not a
'genuine' table. If it is just a square of contiguous cells it won't
recognise it. Next time it happens try entering a formula and clicking a
cell and you should get something like

=Table1[[#This Row],[3 Yr Cost]]-MAX([3 Yr Cost])

If it is a 'genuine' table, with references to the table rather than the
cell(s) or range name

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk

UK Excel User Conference In Cambridge
November 28th - December 1st 2007
Register Now @ http://www.exceluserconference.com/UKEUC.html



"Gus" wrote in message
...
Sometimes when I click in a table, the Layout tab is not shown under
the
Table Tools tab group. I didn't find any special circumstances that
would
case this compared to situations when the Layout tab is shown.

May I miss some conditions causing it to be hidden?

Any idea welcome.

Cheers,
Gus

Table Layout tab missing
 

Nope

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk

UK Excel User Conference In Cambridge
November 28th - December 1st 2007
Register Now @ http://www.exceluserconference.com/UKEUC.html



"Gus" wrote in message
...
Hm, shouldn' there be a tab called Layout similar to that of Word?

"Nick Hodge" wrote:

Gus

There is only one table tab (It is actually a TabSet, called 'Table
Tools'
with a tab called 'Design' below), which two tabs are you expecting?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk

UK Excel User Conference In Cambridge
November 28th - December 1st 2007
Register Now @ http://www.exceluserconference.com/UKEUC.html



"Gus" wrote in message
...
Thanks for your time.

In fact, it was a genuine table inserted into an xlsx workbook and it
uses
named references as you mentioned. Currently this one was created from
a
range containing data imported from csv, however Excel asked upon
creating
the table if I want to merge multiple ranges and disconnect from the
original
source€”for which I answered yes. Anyway, I do not remember of such
history
in
the case of other tables.

But according to what you said: isn't it true that either no tabs
should
be
displayed or both Table tabs should be displayed at any given time?

Gus

PS: I have marked your reply as an answer since some may have faced
with
the
problem that you mentioned.

"Nick Hodge" wrote:

Gus

I know of no occasions where this doesn't happen except if it is not a
'genuine' table. If it is just a square of contiguous cells it won't
recognise it. Next time it happens try entering a formula and clicking
a
cell and you should get something like

=Table1[[#This Row],[3 Yr Cost]]-MAX([3 Yr Cost])

If it is a 'genuine' table, with references to the table rather than
the
cell(s) or range name

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk

UK Excel User Conference In Cambridge
November 28th - December 1st 2007
Register Now @ http://www.exceluserconference.com/UKEUC.html



"Gus" wrote in message
...
Sometimes when I click in a table, the Layout tab is not shown under
the
Table Tools tab group. I didn't find any special circumstances that
would
case this compared to situations when the Layout tab is shown.

May I miss some conditions causing it to be hidden?

Any idea welcome.

Cheers,
Gus