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 Liengm
Microsoft Excel MV
www.stfx.ca/people/bliengm
remove caps from email
Previous Posts In This Thread:
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.
Have you actually made a Table using Insert | TableIf so, whenever you select
Have you actually made a Table using Insert | Tabl
If so, whenever you select one of its cells there is a context tab (top row
of Ribbon) called Table Tool
best wishe
--
Bernard V Liengm
Microsoft Excel MV
www.stfx.ca/people/bliengm
remove caps from emai
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
:
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 Liengm
Microsoft Excel MV
www.stfx.ca/people/bliengm
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/tutorial...b7a-1bb00e33db07/distributed-data-grids-.aspx