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.