Inserting Hyperlink from a Query

J

Jeffrey

I am doing a simple query that, as one of its columns,
returns an excel formula for a hyperlink. For example:

=HYPERLINK("http://researchportfolio.cancer.gov/cgi-
bin/abstract.pl?
ProjectID=14083","http://researchportfolio.cancer.gov/cgi-
bin/abstract.pl?ProjectID=14083")

I am using MS Query to an Oracle database. When I refresh
(or first get) the data, the formula and links come in
correctly, but they display as the text of the formula
instead of the result of the formula (thus, no working
hyperlink). When you double-click the cell and then leave
the cell, Excel resolves the formula and displays a
working link.

I tried the same thing using a simple SUM formula instead
of the hyperlink with the same result--excel displays the
text of the formula until you double-click and leave the
cell.

Anyone know of any way to handle this programatically
(preferably in the query but, if needed, a VBA solution
will suffice).

Thanks,
Jeffrey
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy hyperlinks 6
Unwanted Hyperlink 0
hyperlink to website and then to information in a certain cell 16
Help bringing in hyperlink into Excel from Web 3
Web Page Hyperlink not executing from Access 2003 query export 0
Adding hyperlink to access database from excel 1
hidden Hyperlink 1
HYPERLINK() Help 1

Top