Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2006

Tip: Looking for answers? Try searching our database.

An issue with hyperlinks...

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
nerdman - 12 Jan 2006 14:53 GMT
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...???

Signature

nerdman

Dave Peterson - 12 Jan 2006 15:03 GMT
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.)

> 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
[quoted text clipped - 10 lines]
> nerdman's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29614
> View this thread: http://www.excelforum.com/showthread.php?threadid=500647

Signature

Dave Peterson

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.