Results 1 to 3 of 3

Thread: hyperlinks (XP)

  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    hyperlinks (XP)

    Can't specify a cell reference in another sheet in the same workbook. What am doing wrong?? Help please!

    Aunt Linda

  2. #2
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: hyperlinks (XP)

    Are you using the Insert Hyperlink dialog box to do this?

    Select the cell where you want the Hyperlink, choose Insert | Hyperlink
    Select the button, Place in this document
    Select the Sheet
    Type the cell reference
    Choose OK

    If you are doing this it should work. Else give us a little more detail to how you are doing it and in what context.
    Regards,
    Rudi

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: hyperlinks (XP)

    Well, Rudi - I've hit a new low. It really helps if you type the exact cell reference you'd like to link to when you're setting up the link - now I have to confess this fiasco to my Excel class next week because I showed them all how to use this wonderful tool called "Woody's Lounge" if they had a question they couldn't figure out and posted this question as an example of how to use the lounge.

    This morning, as I look at your reply, and go to my example spreadsheet used in class - I was instructing them - and - shame on them! - they didn't notice my error either - to type in an incorrect cell reference.

    Some days you just can't win - but we had a good class anyway.

    Thank you for your prompt and, of course, accurate response.

    Mea Culpa
    Aunt Linda

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •