An issue with hyperlinks...

  • Thread starter Thread starter nerdman
  • Start date Start date
N

nerdman

I am making a big document for school in Excel that involves hyperlinks
to other worksheets and a menu. I work on a Mac OS X and use the Excel
X. The problem is that i create a hyper link to another worksheet,
everything is fine and lovely. the problem begins when i move the file
to another folder or file. When that happens it just cant find the file
because the link or path still links to the file's previous location.
Every one else who uses excel in windows dont have any problems at all!
Where can i find the option or whatever...???
 
I like to use the =hyperlink() worksheet function. I've never had trouble with
them getting confused:

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

If you used insert|hyperlink, did you point to the workbook or point at "Place
in this document". (I guess I don't have a suggestion no matter which one you
used.)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

trying to create a link to a link in Excel (2007) 3
issue with hyperlinks 1
Hyperlinks to a destination in google drive - help please 2
Macro repairing links in hyperlink 1
Can't set hyperlink to Word bookmark 3
Help with hyperlinks 2
Find and Replace in Multiple HTML Files with an Excel list 1
Excel Multiple Worksheets - TransferSpreadsheet VBA 0

Back
Top