Forum Discussion

jvan4's avatar
jvan4
Copper Contributor
Jun 15, 2023

excel hyperlinks not referencing in new sheet

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!

excel

1 Reply

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Jun 16, 2023
    Check out the HYPERLINK function, much more robust for internal hyperlinks:
    =HYPERLINK(CELL("address",Sheet1!A1),"Home")

Resources