View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Get External Data grayed out

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.