Hyplinking Question

  • Thread starter Thread starter cclark
  • Start date Start date
C

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?
 
Try to assign Names to the destination cells and then after:

Insert > Hyperlink > Place in this Document > then use the names you have
Defined
 
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.
 
Back
Top