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.
|