Excel 2007 - connect range to external data source



When I use query to connect to an external ODBC data source a table is
automatically created. I really don't want a table, I just want a data range
that can be refreshed. If I convert the table to a data range, the
query/connection information is deleted. How can I connect a data range to
the ODBC source?


Hi there,

Just wondering if you ever managed to resolve this issue, I have just
noticed this issue having recently started using 2007 with external links.
Never had this problem in 2003. It stops me from being able to use the
subtotal function.


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