Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Difficulties with HYPERLINK
Hi, I am currently using these 2 links - Code: -------------------- =HYPERLINK("[2005-06.xls]'Timetable'!A"&MATCH(Timetable!K2,Timetable!A:A,0) ,"TIMETABLE") -------------------- Code: -------------------- =HYPERLINK("[2005-06.xls]'Timetable'!A"&MATCH(Timetable!K2,Timetable!A:A,0) ,"▼ Goto Today") -------------------- The only problem is that if the file gets renamed then they stop working! Is there any way that I can get the same functionality, but using a method that doesn't involve file names? Many thanks. -- mevetts ------------------------------------------------------------------------ mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130 View this thread: http://www.excelforum.com/showthread...hreadid=532011 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Difficulties with HYPERLINK
Maybe....
How does that file get renamed? If you're renaming it outside of excel (windows explorer???), then I think your formulas will break. If you have both workbooks open and use File|SaveAs to create that new workbook (kind of a rename??), then you could use a formula like: =HYPERLINK("#"&CELL("address",[book1.xls]Sheet2!$E$18),"click me") If you use a formula like this one and use windows explorer to rename the file, you can open the workbook with the =hyperlink() formula and use Edit|links|Change source to make your change. ps. 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) mevetts wrote: Hi, I am currently using these 2 links - Code: -------------------- =HYPERLINK("[2005-06.xls]'Timetable'!A"&MATCH(Timetable!K2,Timetable!A:A,0) ,"TIMETABLE") -------------------- Code: -------------------- =HYPERLINK("[2005-06.xls]'Timetable'!A"&MATCH(Timetable!K2,Timetable!A:A,0) ,"▼ Goto Today") -------------------- The only problem is that if the file gets renamed then they stop working! Is there any way that I can get the same functionality, but using a method that doesn't involve file names? Many thanks. -- mevetts ------------------------------------------------------------------------ mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130 View this thread: http://www.excelforum.com/showthread...hreadid=532011 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Difficulties with HYPERLINK
Many thanks Dave, I'll take a look. -- mevetts ------------------------------------------------------------------------ mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130 View this thread: http://www.excelforum.com/showthread...hreadid=532011 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink function fails when using variable row number | Excel Worksheet Functions | |||
answer to odd results when comparing hyperlink addresses | Links and Linking in Excel | |||
Hyperlink won't open any other XLS file | Excel Discussion (Misc queries) | |||
Using the Hyperlink Function and finding filenames | Excel Worksheet Functions | |||
Importing Data from an Access Database Including a Hyperlink Colum | Excel Discussion (Misc queries) |