concatenate and hyperlink functions

D

Dave F

I entered the following formula:

=CONCATENATE("Creates function, ",HYPERLINK(ProjectTrackingDB_Queries!A2),"
which allows the GetSQL query to return the SQL statement of a given query.")

which yields the text string one would expect it to yield. However, when I
click the hyperlink I get an error, "Cannot open the specified file."

Cell A2, which is referenced in the formula above has the text "GetSQL".

Any ideas as to what I'm doing wrong?
 

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

Concatentate text and insert blank line 2
2002 Hyperlink issues 2
HYPERLINK() Help 1
Array formula works on first row only 5
evaluate a concatenate expression 3
Questions on importing data from websites 0
Hyperlink to another sheet within a workbook using formula 1
Most functions do not work and return #Name? 4

Top