title: Excel not responding during long SQL query
body: <p>I'm looking for advice on how to avoid Excel not responding during a long SQL query. </p>
  
  <p>If I run my VBA code with the data already in place, the execution takes less than one second. When running the code with the SQL query, execution time jumps up to about 11 seconds, which is the same amount of time it takes for the query to run in Microsofts SQL Server Management Studio. </p>
  
  <p>While the code finishes without further problems every time, Excel turns unresponsive after about 6 seconds, showing a blank screen and a "Not responding" text. ScreenUpdating, Calculation, and Events are all disabled.</p>
  
  <p>The user doesn't need to see anything happening while the macro is running, but I'd rather not have my colleagues see a blank screen with the "Not responding" text every time they run the macro. </p>
  
  <p>Any general advice or reading on how to fix this?</p>