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

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

Insert Hyperlink Place in this Document then use the names you have
Defined
--
Gary''s Student - gsnu200804


"cclark" wrote:

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

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 and I will create a few links
for demo purpose.

"cclark" wrote:

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