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.

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.

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.

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.

Roger

Just curious............

In 2007 is Insert Table the same as DataCreate List in 2003?


Gord Dibben MS Excel MVP

On Wed, 18 Apr 2007 18:54:14 +0100, "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.

Hi Gord

Yes, it is.
However, I had never really investigated the "List" properly in 2003.
But the "Table" in 2007 is an Object with it's own properties and the
way it behaves when trying to access the Autofilter dropdowns
(automatically created) is slightly different from accessing and
manipulating the autofilter in a standard "list" as Xl2007 would now
refer to a straightforward set of columns and rows. This is the same in
both 2003 and 2007

One you choose, Insert TabTable, having started from any cell within
your list, it defines the used range for you, asks whether there are
Headers, adds filters exactly the same as with Excel 2003. The table
automatically "grows" as you add more data the same as 2003 so it saves
creating dynamic ranges as an input to Pivot Tables for example.

The Object has a number of additional features over the 2003 model
however, including the neat facility of auto freeze panes on the header
when you scroll down the sheet, but, the column labels A,B,C etc.
disappear, with the actual header labels fixed.

Getting External data is the same in both versions, from within the
"Table", those options are greyed out.
--
Regards

Roger Govier


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Roger

Just curious............

In 2007 is Insert Table the same as DataCreate List in 2003?


Gord Dibben MS Excel MVP

On Wed, 18 Apr 2007 18:54:14 +0100, "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.

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.

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.

It sounds like the connection between your worksheet and the external data source has been lost or disabled. Here are a few steps you can try to resolve the issue:

1. Check if the data source is still available: Make sure that the external data source is still accessible and that you have the necessary permissions to access it. If the data source has been moved or deleted, you may need to update the connection information.
   
2. Check if the connection is enabled: Go to the Data tab in the Excel ribbon and click on Connections. Select the connection that you are using and click on Properties. Make sure that the Enable background refresh and Enable refresh on open options are checked.
   
3. Check if the connection is set to refresh automatically: In the same Properties window, check if the Refresh data when opening the file and Refresh every X minutes options are checked. This will ensure that your data is always up-to-date.
   
4. Check if the connection is set to refresh on demand: If the connection is set to refresh on demand, you will need to manually refresh the data by clicking on the Refresh All button in the Data tab.
   
5. Check if the connection is password protected: If the connection is password protected, you may need to enter the password before you can edit the query or refresh the data.

If none of these steps work, you may need to recreate the connection to the external data source. To do this, go to the Data tab in the Excel ribbon and click on From Other Sources. Select the type of data source you are using and follow the prompts to create a new connection. Once the connection is established, you should be able to edit the query and refresh the data as needed.