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