Forum Discussion
ChrisT72
Feb 27, 2024Copper Contributor
Hyperlinks within SQL data refresh Excel sheet
Hello, I'm testing a few things on a project. I have a worksheet that runs a SQL query and I have also included hyperlinks. Obviously when the data is refreshed the hyperlinks drop out. Is there a...
- Feb 28, 2024
ChrisT72 You are missing the point. The Hyperlink function should use data from the returned table to build that link. That means there must be some logic you can use to derive the link text from the data in the table.
JKPieterse
Silver Contributor
Add a column immediately to the right of your query table and use the HYPERLINK function to build that hyperlink. If all is set up the way it is supposed to, Excel will keep that hyperlink column when you refresh the query
ChrisT72
Feb 27, 2024Copper Contributor
Many thanks for the reply. However I need the Hyperlink to be 'linked' to specific data returned in the query table. See my example, if that makes sense.
The column added immediately to the right does remain once the sheet is refreshed however the hyperlink does not correspond to the data returned.
- JKPieterseFeb 28, 2024Silver Contributor
ChrisT72 You are missing the point. The Hyperlink function should use data from the returned table to build that link. That means there must be some logic you can use to derive the link text from the data in the table.
- ChrisT72Feb 29, 2024Copper ContributorYes I see now, makes sense. I am finance rather than IT so I have passed over to the guys that know what they are doing! Thanks