An issue with hyperlinks...

N

nerdman

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...???
 
D

Dave Peterson

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.)
 
Top