Hi Roger,

I was wrong. It IS a table. In Excel 2003, even though you were on a cell
from the returned data, you can still access the query. Apparently it is
different with Excel 2007.

Kip

"Kip" wrote:

Hi Roger,

It is not a table. It is data retreived from an ODBC source.

When I click outside of the data (an empty cell), the Get External Data
options are available.

Even though this is not a table, do I still have to click outside of the
data returned from my query to have access to the Get External Data options
to adjust my query?

Kip


"Roger Govier" wrote:

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.