Watch out for these:
=CELL("filename")

It evaluates to the name of the drive/path/workbook and active sheet when excel
recalculated.

Better is to make sure that the function includes a reference to the worksheet
you want:

=CELL("filename", A1)
A1 can be any cell in that worksheet--including the cell with the formula.



Gary''s Student wrote:

=HYPERLINK("#"&MID(CELL("filename"),FIND("]",CELL("filename"),1)+1,255)&"!B9","goto")

1. copy the original worksheet
2. re-name the copy
3. save the file
This form of the equation will adapt to the copy & re-name

--
Gary''s Student - gsnu200741

"Gary''s Student" wrote:

Do not create hyperlinks using:
Insert Hyperlink
Instead use something like:

=HYPERLINK("#Sheet2!B9","goto")

This link will always be local. You can save theworkbook with any name and
the link will always take you to the local Sheet2.
--
Gary''s Student - gsnu200741


"andy62" wrote:

I have seen this question asked but not answered. I have a worksheet that
serves as a template; thus it is to be copied and filled in over and over.
It includes a couple hyperlinks for navigation. When the worksheet is
copied, the links point to the template, not to the new sheet. This imposes
major risks with my audience. How can I set up the hyperlinks so that when
the worksheet is copied, they point to the right cells in the NEW worksheet?
There has to be a way . . .

TIA

--

Dave Peterson