title: Excel: How to halt calculations until all connections have been refreshed?
body: <p><strong>The question:</strong></p>
  
  <p>In an Excel workbook I've got about 50 connections to external sources (csv files). Every time I refres the connections, the entire workbook is bein recalculated. Is there a way to halt all calculations until all connections have been refreshed? Menu option? VBA script?</p>
  
  <p><strong>The details:</strong></p>
  
  <p>I thought something as simple as this would be the trick:</p>
  
  <pre><code>Sub RefreshAll()
  
      Application.Calculation = xlCalculationManual
      ThisWorkbook.RefreshAll
      Application.Calculation = xlCalculationAutomatic
  
  End Sub
  </code></pre>
  
  <p>However, this does not seem to be deactivating spreadsheet calculations between loading each connection as I had hoped. Any suggestions?</p>