Home |
Search |
Today's Posts |
#1
|
|||
|
|||
hyperlinks in excell
is there a way to make hyperlinks in excell 'relative'?
i'd like to copy files without having to change the link. -- tj |
#2
|
|||
|
|||
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),sheeton e!C5) =HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5) For more information see http://www.mvps.org/dmcritchie/excel....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 "tom jan" wrote in message ... is there a way to make hyperlinks in excell 'relative'? i'd like to copy files without having to change the link. -- tj |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I view an excell document without excell (not installed wit. | Excel Discussion (Misc queries) | |||
Addressing hyperlinks in excel | Excel Discussion (Misc queries) | |||
Can I view an excell document without excell (not installed wit. | Excel Discussion (Misc queries) | |||
lable ranges in Excell | Excel Discussion (Misc queries) | |||
Hyperlinks in Excell | Excel Worksheet Functions |