View Single Post
  #5  
Old June 4th, 2010, 02:23 AM posted to microsoft.public.excel.newusers
tapori tapori
external usenet poster
 
Posts: 1
Default Excel 2007 - "Insert/Table" grayed out for a worksheet

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" wrote in message
...

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...ta-grids-.aspx