W
WhytheQ
I've got quite a few External Data Queries set up in various
spreadsheets. They are sourcing tables in other Excel files. When I
refresh these queries the source file opens and stays open. I've tried
refreshing on a different machine and the source file stays open.
Is there a setting in the query that needs to be changed so that on
refresh the source file stays closed?
Any help greatly appreciated.
Thanks,
Jason
spreadsheets. They are sourcing tables in other Excel files. When I
refresh these queries the source file opens and stays open. I've tried
refreshing on a different machine and the source file stays open.
Is there a setting in the query that needs to be changed so that on
refresh the source file stays closed?
Any help greatly appreciated.
Thanks,
Jason