table tool design tab is missing in Excel 2007

Andrew

unread,

Sep 6, 2007, 8:02:01 AM9/6/07

to

Hello.

I am running MS Office Home and Student 2007 on Windows XP and am having
issues with excel 2007.

I believe there is suppose to be a tab titled 'table tools design' that
appears when I click anywhere on the table.

However, for some reason this tab does not appear when i click on the table.
I recently had an addin (mindjet manager), which i have removed as i thought
there might have been a conflict, but still nothing.

I can see the tab in word 2007 but just not excel.

Any help massively appreciated..

With kind regards.

Bernard Liengme

unread,

Sep 6, 2007, 9:27:46 AM9/6/07

to

Have you actually made a Table using Insert | Table
If so, whenever you select one of its cells there is a context tab (top row
of Ribbon) called Table Tools
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Andrew" <And...@discussions.microsoft.com> wrote in message
news:C6A063CB-C410-482F...@microsoft.com...

Andrew

unread,

Sep 6, 2007, 9:58:05 AM9/6/07

to

I am so stupid!

Thankyou so much.

Really appreciated.

That was driving me crazy!

All the best, Andrew.

Bernard Liengme

unread,

Sep 7, 2007, 12:06:20 PM9/7/07

to

Glad to help. We are all 'stupid' at one time or another.

--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Andrew" <And...@discussions.microsoft.com> wrote in message

news:0A93E6F6-A4B8-45B7...@microsoft.com...

taporitapori

unread,

Jun 3, 2010, 9:23:18 PM6/3/10

to

I have a a worksheet in my spreadsheet that I get through an SQL database using "Data/Connections". I want to convert all the data on this spreadsheet in a "table" format so that I can do the sorting but this option is grayed out on this worksheet. For all other worksheets in the spreadsheet this option is present

I believe it has something to do with the way I am getting this data in this worksheet. I tried copying this data into new spreadsheet but still can't get the "Table" option back on the ribbon.

I will appreciate any help.

Thanks
TX

Bernard Liengme wrote:

Glad to help. We are all 'stupid' at one time or another.

07-Sep-07

Glad to help. We are all 'stupid' at one time or another.
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

Previous Posts In This Thread:

On Thursday, September 06, 2007 8:02 AM
Andre wrote:

table tool design tab is missing in Excel 2007
Hello.

I am running MS Office Home and Student 2007 on Windows XP and am having
issues with excel 2007.

I believe there is suppose to be a tab titled 'table tools design' that
appears when I click anywhere on the table.

However, for some reason this tab does not appear when i click on the table.
I recently had an addin (mindjet manager), which i have removed as i thought
there might have been a conflict, but still nothing.

I can see the tab in word 2007 but just not excel.

Any help massively appreciated..

With kind regards.

On Thursday, September 06, 2007 9:27 AM
Bernard Liengme wrote:

Have you actually made a Table using Insert | TableIf so, whenever you select
Have you actually made a Table using Insert | Table
If so, whenever you select one of its cells there is a context tab (top row
of Ribbon) called Table Tools
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Andrew" <And...@discussions.microsoft.com> wrote in message
news:C6A063CB-C410-482F...@microsoft.com...

On Thursday, September 06, 2007 9:58 AM
Andre wrote:

I am so stupid!Thankyou so much.Really appreciated.That was driving me crazy!
I am so stupid!

Thankyou so much.

Really appreciated.

That was driving me crazy!

All the best, Andrew.

"Bernard Liengme" wrote:

On Friday, September 07, 2007 12:06 PM
Bernard Liengme wrote:

Glad to help. We are all 'stupid' at one time or another.
Glad to help. We are all 'stupid' at one time or another.
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

Submitted via EggHeadCafe - Software Developer Portal of Choice
Distributed Data Grids - Share Objects Between Windows Service and ASP.NET
http://www.eggheadcafe.com/tutorials/aspnet/953ed61f-e440-4ca5-8b7a-1bb00e33db07/distributed-data-grids-.aspx