Import external data, data includes Excel function
 

Hi,

I'm trying to import data from a SQL server view. The view includes an email
address . I want this email address to be a hyperlink so I
included another column in the view with the Excel function for a hyperlink
=HYPERLINK("mailto: " & ").

The problem is that excel seems to treat =HYPERLINK("mailto: " &
") as text rather than a function i.e the cell displays
=HYPERLINK("mailto: " & "). If you click in and then out of
the formula bar Excel refreshes the cell to show .

Any ideas?