Import External Data
 

I've been handed a few excel files that import external data from
stored procedures on an MS SQL Server and asked to make a few updates.
The problem that I'm running into is that for some reason the Import
Data, New Database Query, and Parameters dropdown menu options are
grayed out. The protection on both the sheet and workbook are turned
off, and I can run the Refresh Data command fine. The workbook
doesn't seem to have any macros or anything that I can think of that
would disable these options. I also can't figure out how to modify
the datasource, the Edit Query and Data Range options don't let you
alter where the data is being pulled from. I work mostly on
application/database development, so I'm feeling completely humbled
by this excel worksheet... please help.

Import External Data
 

One, make sure that all the options for data sources are installed on office.
Two, search the knowledge base for this problem.
Three, If the query is stored seperate of the excel worksheet it can be
edited with a text editor

"chris" wrote:

I've been handed a few excel files that import external data from
stored procedures on an MS SQL Server and asked to make a few updates.
The problem that I'm running into is that for some reason the Import
Data, New Database Query, and Parameters dropdown menu options are
grayed out. The protection on both the sheet and workbook are turned
off, and I can run the Refresh Data command fine. The workbook
doesn't seem to have any macros or anything that I can think of that
would disable these options. I also can't figure out how to modify
the datasource, the Edit Query and Data Range options don't let you
alter where the data is being pulled from. I work mostly on
application/database development, so I'm feeling completely humbled
by this excel worksheet... please help.