Table Layout tab missing

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

Guest

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
 
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
(e-mail address removed)
web: www.nickhodge.co.uk

UK Excel User Conference In Cambridge
November 28th - December 1st 2007
Register Now @ http://www.exceluserconference.com/UKEUC.html
 
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 said:
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
(e-mail address removed)
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 said:
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
Click to expand...
Click to expand...
 
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
(e-mail address removed)
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 said:
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 said:
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
(e-mail address removed)
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
Hm, shouldn' there be a tab called Layout similar to that of Word?

Nick Hodge said:
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
(e-mail address removed)
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 said:
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 said:
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
(e-mail address removed)
web: www.nickhodge.co.uk

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



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
Click to expand...
Click to expand...
Click to expand...
 
Nope

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
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 said:
Hm, shouldn' there be a tab called Layout similar to that of Word?

Nick Hodge said:
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
(e-mail address removed)
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 said:
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.

:

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
(e-mail address removed)
web: www.nickhodge.co.uk

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



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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top