Hi

Are you trying to do it from a cell within a Table?
If I try from within a Table, then it is Greyed out for me.
If I try from a cell outside of a Table, then the options are available.
If within the table, you can use Table ToolsDesignToolsConvert to
Range which will turn it back to a List, then the options become
available.
To go back to a Table after, InsertTable.
--
Regards

Roger Govier


"Kip" wrote in message
...
I have Excel 2007, and the workbook/worksheet is not protected. Under
Excel
2003 that function was available. However, since upgrading to Excel
2007,
Get External Data is greyed-out. I cannot access any of the
functions. How
do I have the Get External Data to be available?

"Gord Dibben" wrote:

Sounds like the sheet is protected.

Have you checked under ToolsProtection to see the status?


Gord Dibben MS Excel MVP

On Fri, 9 Feb 2007 10:43:00 -0800, Pat Brown
wrote:

My worksheet is linked to an external data source using ODBC
drivers. I can't
edit the query anymore because the Get External Data buttons are
grayed out.
The Edit Links button is grayed out also.