title: Refresh a specific external data connection
body: <p>I have an Excel file (2007) that has 50+ connections and takes about 5 minutes to refresh all.</p>
  
  <p>The workbook is refreshed daily by the users. Not all connections are ready to be refreshed in the morning. Some are ready and some are not, depending on the server status.</p>
  
  <p>I created a table that shows an estimated time to refresh (let's call it ETR table), which takes a second to refresh. I want the users to refresh only this ETR table while there is still pending work in the server. Once they have green lights on all the connections in ETR table, they can refresh all.</p>
  
  <p>The problem is that the main sheet to which the users have access is protected and cannot have any external connections (otherwise, the table won't refresh). Therefore, I placed the ETR table in a hidden but unprotected sheet and show the values in the main sheet using formulas. Since they cannot access ETR table directly, there's no good way for the users to refresh only the ETR table.</p>
  
  <p>Therefore, I'd like to make a command button (or anything that'd work) where the users can click and refresh just one specific table.</p>
  
  <p>I am very new to VBA, and have been researching it for days but I could only find codes to refresh Pivot tables, not external data connection.</p>