Hyperlink to another worksheet in the same workbook
 

When I hyperlink to another worksheet within the same workbook, I receive
Cannot open specified file. This file will be sent to others so I changed
the hyperlink base in properties.

Hyperlink to another worksheet in the same workbook
 

I find the =hyperlink() worksheet function much easier to work with.

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

Dgwood90 wrote:

When I hyperlink to another worksheet within the same workbook, I receive
Cannot open specified file. This file will be sent to others so I changed
the hyperlink base in properties.

--

Dave Peterson