software

Hi,

I am currently using these 2 links -Code:
--------------------
=HYPERLINK(quot;[2005-06.xls]'Timetable'!Aquot;amp;MATCH(Timetable!K2,Timetable!A:A,0) ,quot;TIMETABLEquot;)
--------------------
Code:
--------------------
=HYPERLINK(quot;[2005-06.xls]'Timetable'!Aquot;amp;MATCH(Timetable!K2,Timetable!A:A,0) ,quot;#9660; Goto Todayquot;)
--------------------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: www.excelforum.com/member.php...oamp;userid=29130
View this thread: www.excelforum.com/showthread...hreadid=532011Maybe....

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(quot;#quot;amp;CELL(quot;addressquot;,[book1.xls]Sheet2!$E$18),quot;click mequot;)

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(quot;#quot;amp;CELL(quot;addressquot;,C5),C5)
=HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,sheetone!C5),sheeton e!C5)
=HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,'sheet two'!C5),'sheet two'!C5)

mevetts wrote:
gt;
gt; Hi,
gt;
gt; I am currently using these 2 links -
gt;
gt; Code:
gt; --------------------
gt; =HYPERLINK(quot;[2005-06.xls]'Timetable'!Aquot;amp;MATCH(Timetable!K2,Timetable!A:A,0) ,quot;TIMETABLEquot;)
gt; --------------------
gt;
gt; Code:
gt; --------------------
gt; =HYPERLINK(quot;[2005-06.xls]'Timetable'!Aquot;amp;MATCH(Timetable!K2,Timetable!A:A,0) ,quot;#9660; Goto Todayquot;)
gt; --------------------
gt;
gt; The only problem is that if the file gets renamed then they stop
gt; working!
gt;
gt; Is there any way that I can get the same functionality, but using a
gt; method that doesn't involve file names?
gt;
gt; Many thanks.
gt;
gt; --
gt; mevetts
gt;
gt; ------------------------------------------------------------------------
gt; mevetts's Profile: www.excelforum.com/member.php...oamp;userid=29130
gt; View this thread: www.excelforum.com/showthread...hreadid=532011

--

Dave Peterson


Many thanks Dave, I'll take a look.--
mevetts------------------------------------------------------------------------
mevetts's Profile: www.excelforum.com/member.php...oamp;userid=29130
View this thread: www.excelforum.com/showthread...hreadid=532011