Excel 2003: Can the same range be used for a querytable and a list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to create a listobject based on a querytable range?
--Will the querytable still exist?
---If so, will the listobject expand or contract based on a subsequent
querytable refresh?
 
When you apply the list, it removes any connections to external data, so the
querytable would not exist. This obviates your second question.
 

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

listobjects and querytables 0
Question on Deleting Querytables 3
Hooking into Refresh/RefreshAll events from listobject 3
QueryTables, some basic questions 5
Connecting Questions on Querytables 1
help to understand 'querytable' 1
Help! Query Refreshing 2
How to obtain the row count of a QueryTable from a Web query 4

Back
Top