Hyperlinks in Excel

  • Thread starter Thread starter Art
  • Start date Start date
A

Art

I am using Excel to run a query against a SQL database.

One of the colums that is being returned is a web site
address (e.g., http://www.mywebsite.com)

Is there any way to format the column so that the data
being returned becomes a live hyperlink rather than just a
text string of the web site address?

Thanks
 
Hi Art,
What version of Excel, you have to have at least Excel 2002 to be able
to turn off hyperlinks, and at least Excel 97 to have hyperlinks.

See if the hand for a hyperlink appears you may have just formatted
it with a style so that the underlined blue indication is not present.

Does F2 then Enter create the hyperlink. That is just reentering it.
If that woks you could probably use the TrimALL macro, which you
might try even if F2 then Enter doesn't work.
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

If you have hyperlinks turned off then try
Creating Hyperlinks for all Cells in a Selection (#MakeHyperlinks)
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#MakeHyperlinks
or
MakeHyperlinkFormulas from URL address or Email addresses
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#MakeHyperlinkFormulas

If there is something else happening, I don't use SQL, if you want to leave
that cell untouched you could use
=HYPERLINK(a1,"[x]") and click on the [x] in the cell.
The purpose of the string '[x]" is just to have something short and
distinctive rather than also repeating what you already have visible.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
Back
Top