how can I display another cell as hyperlink text?

**Andy Pope** · 10-17-2008, 07:14 AM

Again it works for me when I reference a non local folder.

=HYPERLINK("#[Book3.xls]Sheet1!$A$1",'\\<servername>\jobs3\Transit\[Book3.xls]Sheet1'!A1)

**scorpioscouse** · 10-17-2008, 07:25 AM

I dunno what Im doing wrong then?!?! The link works fine, but it isn't displaying the text?! I think I'm just gonna make a work around! Thanks for all ya help. Much appreciated.

Scouse.

**jcelyn** · 01-08-2010, 03:44 AM

Hi. I'm facing the same problem as well; however, I'm really new at Excel, so I don't know where to write the hyperlink. Could you please guide me? Thank you.

**DonkeyOte** · 01-08-2010, 04:48 AM

jcelyn, welcome to the board, however, please note...

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.