Another Issue with Hyperlinks

[snaxxy]

Hi,

Please see my sample workbook:
Demo.xlsx

In the first few sheets I have 2 users. On the last one I have a Hyperlinks page. The reason for the Hyperlinks page is that when I update this page it will update the other two sheets (TEST & TEST2) with the new link.

However, on TEST & TEST2 where I have put a reference to the cell in HYPERLINKS sheet it is not showing as a hyperlink in TEST/TEST2, it only copies the text from the HYPERLINKS sheet. Is there any way I can fix this?

Thank you!

Gary

[dilipandey]

Hi Gary,

I am not able to find the sheets (test and test2) and there is no hyperlink in any of the sheets.. have you uploaded the correct file?

Regards,
DILIPandey

<click on below 'star' if this helps>