Hyplinking Question

[cclark]

I have to do many hyperlinks from one worksheet to another within the same
document. My problem is that I need to share this document with others and
the hyperlink references the path to: my documents>file_name>cell. Of course
this causes the link to "break" when others try to open it.

When selecting hyperlink within a spreadsheet from worksheet to worksheet,
how do make excel only reference the link "within the document" with no
reference to the saved path on my hard drive?

 

[Gary''s Student]

Try to assign Names to the destination cells and then after:

Insert > Hyperlink > Place in this Document > then use the names you have
Defined

 

[Sheeloo]

There is an option 'Place in This Document' when you Insert->Hyperlink...
Are you using this option and still getting the problem?

Send the file to me at (e-mail address removed) and I will create a few links
for demo purpose.