×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Problem with excel hyperlink inside excel

Problem with excel hyperlink inside excel

Problem with excel hyperlink inside excel

(OP)
When I use the formula:

=HYPERLINK('SheetName!A8,"●")

The hyperlink works.

When I copy the formula to other cells, like this:

=HYPERLINK('SheetName!A200,"●")

and follow the hyperlink, it puts me back into cell A8, not cell A200.  

Any ideas why?

RE: Problem with excel hyperlink inside excel

I cannot reproduce your problem with Excel-2003 (even allowing for an errant single quote or two).  What version are you using?

My experience with HYPERLINK is very limited.  The one time I tried to use it I had difficulties coming up with a format for jumping to cells on the same worksheet without having to embed the name of the worksheet in the function.  What I eventually got to work satisfactorily was
=HYPERLINK("#"&ADDRESS(ROW(A29),COLUMN(A29),4),"●")

This is probably not relevant to your problem, but I include it here just in case.
 

RE: Problem with excel hyperlink inside excel

(OP)
I'm using Excel 2007.

It is so weird.  The formula doesn't act the same, depending on the mood of microsoft.

Sometimes it jumps me to the wrong cell, sometimes it tells me it can't open the file.

I inserted the hyperlinks manually. In the end it took less time than hunting for a solution online.

RE: Problem with excel hyperlink inside excel

When you move the formula to another cell, Excel maintains the exact relationship (cell to cell) that was created in the first cell.  A way to avoid the cell location change is to place the cursor in the formula cell address(A200) and press F4 which makes the cell location an absolute address (Excell places the "$" in the address to make it an absolute value i.e. "$A$200")  Hitting F4 again will make the row absolute and hitting F4 again will make the column absolute

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources