Hyperlink issues - Hyperlinking cell that is part of a query

[MrStrawb]

Morning All,

I'm looking for a little advice on hyperlinks,

I have a list of items within a table which has been drawn from a source file as a query.

I have attempted to hyperlink the text of each item name to a worksheet within the same document, however due to the data being drawn from a query table I'm having issues with the link not working once data has been refreshed.

Alternatively i attempted to add another column onto the table where i added my own link however when new data is added to the source file and the query updates the new column doesn't stay in the correct order?

Any advice would be greatly appreciated

Thank you in advance

Adam