title: Excel create multiple MS Queries using one data connection between two sheets in the same workbook
body: <p>In Excel 2021, what exactly is a &quot;data connection&quot;, &quot;query&quot; and &quot;domain source name&quot;?</p>
  <p>Let's say I have a Workbook &quot;Manahil_Customer_Database.xlsm&quot; in which I have a sheet &quot;sht_Customer_Cities&quot; that has a table &quot;tbl_Customer_Cities&quot;. In a new sheet &quot;sht_Report&quot; I want to run two queries using one connection via MS Query. Now when I go through the MS Query route I get one Domain Name Source File &quot;Manahil_Customer_Database.dsn&quot; and one MS Query file &quot;Customer_Countries_Cities.dqy&quot; and one Connection file &quot;Customer_Countries_Cities.odc&quot;.</p>
  <p>However when I look at the &quot;Queries &amp; Connections&quot; it says 0 Queries and 1 Connection named &quot;Customer_Countries_Cities&quot;. I want to be able to establish a single Data Connection via MS Query from the &quot;sht_Report&quot; to the Workbook &quot;Manahil_Customer_Database.xlsm&quot; and than run multiple queries using the same connection.</p>