Difficulties with HYPERLINK

[mevetts]

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.

 

[Dave Peterson]

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),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

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]

Many thanks Dave, I'll take a look.