ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   concatenate and hyperlink functions (https://www.excelbanter.com/excel-worksheet-functions/104894-concatenate-hyperlink-functions.html)

Dave F

concatenate and hyperlink functions
 
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?


All times are GMT +1. The time now is 01:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com