An issue with hyperlinks...

I am making a big document for school in Excel that involves hyperlinks to other worksheets and a menu. I work on a Mac OS X and use the Excel X. The problem is that i create a hyper link to another worksheet, everything is fine and lovely. the problem begins when i move the file to another folder or file. When that happens it just cant find the file because the link or path still links to the file's previous location. Every one else who uses excel in windows dont have any problems at all! Where can i find the option or whatever...???

I like to use the =hyperlink() worksheet function. I've never had trouble with
them getting confused:

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)

If you used insert|hyperlink, did you point to the workbook or point at "Place
in this document". (I guess I don't have a suggestion no matter which one you
used.)

nerdman wrote:
>
> I am making a big document for school in Excel that involves hyperlinks
> to other worksheets and a menu. I work on a Mac OS X and use the Excel
> X. The problem is that i create a hyper link to another worksheet,
> everything is fine and lovely. the problem begins when i move the file
> to another folder or file. When that happens it just cant find the file
> because the link or path still links to the file's previous location.
> Every one else who uses excel in windows dont have any problems at all!
> Where can i find the option or whatever...???
>
> --
> nerdman
> ------------------------------------------------------------------------
> nerdman's Profile: http://www.excelforum.com/member.php...o&userid=29614
> View this thread: http://www.excelforum.com/showthread...hreadid=500647

--

Dave Peterson