title: How can I locate data ranges that fail to refresh in Excel that aren't listed in the connections list?
body: <p>I have a large workbook with several web and file connections. I have several macros that I run to update different sequences of these connections, the code is simply in the form:</p>
  
  <pre><code>ActiveWorkbook.Connections("XMLConnect3").Refresh
  ActiveWorkbook.Connections("XMLConnect4").Refresh
  </code></pre>
  
  <p>When this code runs I get 4 pop ups for every refresh attempt that is in the macro, </p>
  
  <ol>
  <li>"The following data range failed to refresh: XMLConnect"</li>
  <li>"The following data range failed to refresh: XMLConnect1"</li>
  <li>"The following data range failed to refresh: XMLConnect2"</li>
  <li>"The following data range failed to refresh: Table1"</li>
  </ol>
  
  <p>I can click Ok on each one and the data refreshes normally. If I manually fresh my connections, these pop ups do not show, only when VBA executes Connections.Refresh does this happen.</p>
  
  <p>In my connections list, there is no XMLConnect, XMLConnect1, or XMLConnect2. I used to have XML-web connections with those names but have since deleted them. I searched through all of my VBA code and looked in my Names list, I can't find any reference to them. </p>
  
  <p>Any help would be appreciated! </p>