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

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

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