excel hyperlinks not referencing in new sheet

Copper Contributor

hi, i am creating an excel sheet with multiple hyperlinks to photos. i am trying to create new sheets in the same workbook that reference back to the main sheet, but the hyperlinks are not transferring over and instead are showing as plain text. is there a way to make the hyperlinks work?

 

thank  you!

1 Reply
Check out the HYPERLINK function, much more robust for internal hyperlinks:
=HYPERLINK(CELL("address",Sheet1!A1),"Home")