Thread: HYPERLINK function without filename

I am trying to insert a hyperlink that refers to a cell in a different sheet of the same workbook using the =HYPERLINK function.

I can get it to work with a formula like:

=HYPERLINK("[Book2.xls]Sheet1!A1","test")

However when I remove the filename so the formula looks like

=HYPERLINK("Sheet1!A1","test")

I get a "cannot open specified file error"

I really don't want to include the filename -- what if it changes?

Is there any way to do this (other than using =CELL("filename"))?

I also don't want to use the "Insert > Hyperlink" menu command, because I will eventually want to use a formula to create the address for the link.

Thanks. In brief, I needed to add a hash sign to the reference:

=HYPERLINK("#Sheet1!A1","test")