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.
=SQL_Structure!T5:INDEX(SQL_Structure!$T:$T,COUNTA(SQL_Structure!$T:$T)+3)
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.
=SQL_Structure!#REF:INDEX(SQL_Structure!$T:$T,COUNTA(SQL_Structure!$T:$T)+3)
Any idea on what might be causing it?
