Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get Excel to automatically calculate the value of a hyper
I've had this issue for years and have not been able to solve it.
I've got a query that is pulling data from a database and the query generates a column in the record set that is of the format of the Excel hyperlink function. E.g. =hyperlink("http://mysite/mylink?123",123) =hyperlink("http://mysite/mylink?124",124) .... When the query returns to Excel, I get the uncalculated text show above but what I really want in the column is a hyperlink with the value being 123. If I click on a cell in the result set and click the checkmark to resave it, Excel then computes the hyperlink value properly. But if my query contains hundreds of results, I don't want ot have to do that one by one. So, this cannot be that uncommon an excercise. I'd greatly appreciate the insight if someones got the answer. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get Excel to automatically calculate the value of a hyper
If you have a column of hyperlink functions that are "cold" and want to make
them "clickable", select the column and pull-down: Data Text to Columns and make sure the functions don't split this will change them into real hyperlinks -- Gary''s Student - gsnu200814 "virtualfergy" wrote: I've had this issue for years and have not been able to solve it. I've got a query that is pulling data from a database and the query generates a column in the record set that is of the format of the Excel hyperlink function. E.g. =hyperlink("http://mysite/mylink?123",123) =hyperlink("http://mysite/mylink?124",124) ... When the query returns to Excel, I get the uncalculated text show above but what I really want in the column is a hyperlink with the value being 123. If I click on a cell in the result set and click the checkmark to resave it, Excel then computes the hyperlink value properly. But if my query contains hundreds of results, I don't want ot have to do that one by one. So, this cannot be that uncommon an excercise. I'd greatly appreciate the insight if someones got the answer. Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get Excel to automatically calculate the value of a h
Fan-bloody-tasic!!!! That works well enough. Much appreciated.
"Gary''s Student" wrote: If you have a column of hyperlink functions that are "cold" and want to make them "clickable", select the column and pull-down: Data Text to Columns and make sure the functions don't split this will change them into real hyperlinks -- Gary''s Student - gsnu200814 "virtualfergy" wrote: I've had this issue for years and have not been able to solve it. I've got a query that is pulling data from a database and the query generates a column in the record set that is of the format of the Excel hyperlink function. E.g. =hyperlink("http://mysite/mylink?123",123) =hyperlink("http://mysite/mylink?124",124) ... When the query returns to Excel, I get the uncalculated text show above but what I really want in the column is a hyperlink with the value being 123. If I click on a cell in the result set and click the checkmark to resave it, Excel then computes the hyperlink value properly. But if my query contains hundreds of results, I don't want ot have to do that one by one. So, this cannot be that uncommon an excercise. I'd greatly appreciate the insight if someones got the answer. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Hyper Links | Excel Worksheet Functions | |||
Excel calculate the z factor automatically | Charts and Charting in Excel | |||
Excel calculate the z factor automatically | Charts and Charting in Excel | |||
How do I get Excel to automatically calculate salaries actually received in financial year? | Excel Discussion (Misc queries) | |||
how to calculate overtime automatically on Excel timesheets | Excel Worksheet Functions |