External Data Query

W

WhytheQ

I've got quite an External Data Query set up in
spreadsheet A. It is sourcing a data table in spreadsheet B.
When I refresh the query the spreadsheet B opens, and stays open. I've
tried
refreshing on a different machine and the source file always opens up.

Is there a setting in the query that needs to be changed so that on
refresh the source file B stays closed? ....or is it by design in Excel
that the source file is forced to open?

Do I need to get a vba workaround together?


Any help greatly appreciated.
Thanks,
Jason
 

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

query to external data 3
prevet users to view and modify MS query 2
Auto Refresh Query Table 4
Help, Query Refresh windowm appearing.... 2
Problem with external data and #reference error 2
Which runs first, Workbook_Open() or external query refresh? 4
Lookups - how to obtain data from a master spreadsheet into another 5
delete external data query 1

Top