Hi Kip

If I use DataList.Create List in XL 2003 it does create what is now
termed a Table in XL2007.
If I am on a cell within the "Table", Get external Data options are
greyed out for me.

As I said earlier, if you choose the option to convert back from table
to List in XL2007, you will find that those options are available to you
once more.

--
Regards

Roger Govier


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