I have a data connection set up to import some sql server data into excel and it works without issue. However, I want to use one of the sql server fields as part of a hyperlink. I know I can create my own column, outside of the imported data and make a hyperlink, but, I'd like to just import the function (or whatever) using the data connection.
I have something like this in one of the fields in the data connection's definition:
+ mySqlField + '","' + friendlyNameField + '")'
which turns into this in the cell
The problem is that it shows up as just text in the cell (not a hyperlink). If I select that cell and hit return, it turns into a hyperlink (so I think I'm close).