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.