View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Hyplinking Question

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?