Hi,

I have an excel sheet that has around 30 queries. Some of these queries are importing data from an Access database and others are importing from SQL database. For these queries that either import from Access or SQL sometimes end up not completing the background refresh. I then need to click the bottom left corner to open the queries that are currently not completing and manually force them to close. I cannot find any pattern as to which queries are responsible for the hanging just that they involve an import from Access or SQL.
Is anyone familiar with this problem and its solution? Is there a way to automatically close a running query that has been trying to run over a pre determined time limit?

cheers