title: Excel: Drop down list with dependent length changes reference spontaneously
body: <p>In an excel file I am using a drop down list with variable length dependent on a user selection. The length is given by following formula that counts all the rows in the list and offers a drop down containing all the values in it.</p>
  
  <pre><code>=SQL_Structure!T5:INDEX(SQL_Structure!$T:$T,COUNTA(SQL_Structure!$T:$T)+3)
  </code></pre>
  
  <p>When I save and close the reference in the name manager, the formula spontaneously changes to the different cell instead of reference to cell T5. The modification is seemingly random. I tried several times and the cell reference differed each time. When I run the macro that modifies the list the reference is lost completely as below.</p>
  
  <pre><code>=SQL_Structure!#REF:INDEX(SQL_Structure!$T:$T,COUNTA(SQL_Structure!$T:$T)+3)
  </code></pre>
  
  <p>Any idea on what might be causing it?</p>