Hyperlink from SQL to Excel

Question

Within MS Query I constructed a hyperlink field that looks like,

'=HYPERLINK("Notes://usnbkm301/Lab/LPM.nsf/0/'+[LabRequests].[Docid]+'?OpenDocument","Link")'

I confirmed the query returns the proper information to Excel to point to the object I’m looking to connect to but the field appears with the entire text as written above and not as a true hyperlink and to coax it to an actual hyperlink I have to go to edit each cell, without changing anything of course and then hit enter.  Is there a way to get this to populate hyperlinks properly in Excel without these additional steps?

Thanks for your help and take care,

Jim

Answer 1

Post here : http://social.technet.microsoft.com/Forums/en/excel/threads you might get some help...

Answer 2

I know this is an old one but do you  figured it out ?

Answer 3

Thanks, I'm giving this a try.