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.
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
