I use SQL Query Analyser to run T-SQL queries. It normally chooses the
most recent server I have been using as the server which is what I
want. When I try to place a hyperlink in Excel to an SQL file and
click on it, it will work fine for the first time, but then after a
while and I come back to and click on it again the server name changes
not the most recently used one but some text that appears in the
actual link instead.

Any ideas what is going on and how I can rectify this?