Hi All,
Im trying to create an hyperlink inside a result column from an sql
query
inside an excel worksheet.


If I type the text manually into a cell, as in (example)
=HYPERLINK("#Sheet1!A1", "Value")


it works fine, that is, it shows as "Value" underlined, just like a
hyperlink, and when I click it, it opens the browser.


However, if this text is the column text of an SQL query (by using the
Database Query feature) , it doesnt work (it shows the
"=HYPERLINK..." text, instead of the friendly name text ("Value"), but
oddly
enough,
it shows underlined (so it shows that excel is trying to do something
with
it). Futhermore, clicking it does nothing.


On changing the value of the cell with formula by simply pressing F2
and then enter convert it into a link.


Cannot understand why this is happening.
Can you suggest a way out of this problem

With Warm regards
Jatinder