software

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.

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

David McRitchie posted this and it might help you:

=HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,C5),C5)
=HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,sheetone!C5),sheeton e!C5)
=HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,'sheet two'!C5),'sheet two'!C5)

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

--

Dave Peterson