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?