hyperlinks in excell

T

tom jan

is there a way to make hyperlinks in excell 'relative'?
i'd like to copy files without having to change the link.
 
D

David McRitchie

Hi Tom,
This is an Excel group, if you have excell perhaps you should post in
an excell group, if there is such a thing.

An example of your problem would have been in your best interest
in getting a solution. Rather than forcing someone to guess.as to
your particular problem (and version of Excel/ I'm guessing you have
Excel 97 or Excel 2000, since Excel 2002 does not require the pathname.
The follow gets around having to specify a pathname for the same workbook...

=HYPERLINK("#C5",C5)
=HYPERLINK("#Sheet34!E6",Sheet34!E6)
=HYPERLINK("#'My Sheet'!E6",Sheet34!E9)

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

For more information see
http://www.mvps.org/dmcritchie/excel/sheets.htm#hyperlink
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: =HYPERLINK("#C5",C5)
=HYPERLINK("#Sheet34!E6",Sheet34!E6)
=HYPERLINK("#'My Sheet'!E6",Sheet34!E9)
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
Top