Import External Data

  • Thread starter Thread starter chris
  • Start date Start date
C

chris

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

linking external data 2
Disconnecting from an External Workbook Data Source 2
query to external data 3
Problem with external data and #reference error 2
External Data from SQL Server 1
Access Import & Link section grayed out MS Access 2010 1
Refreshing NON-embedded External Data Connections 1
Excel Import External Data Wizard 3

Back
Top