Forum Discussion
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...
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.
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.
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.
- Yes 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
