Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Garland, Texas, USA
    Posts
    140
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hyperlinks in Excel 2003 (2003)

    Ok, may be a stupid question......but is there such a thing as "dynamic" hyperlinks in Excel. For instance, if I set up a reference to a cell in another worksheet, and that data that I need to link to is moved to another cell, is there a way to set it up so that the link follows it to the new cell reference? We are linking items to data in another worksheet that is modified from time to time and we want to maintain the hyperlink. Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Hyperlinks in Excel 2003 (2003)

    Give the cell you want to refer to a name (select the cell, and type the name in the address box on the left side of the formula bar, or select Insert | Name | Define...). You can create a hyperlink that refers to the defined name; it will still work if you drag the cell to another location.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Garland, Texas, USA
    Posts
    140
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlinks in Excel 2003 (2003)

    Thanks, will give a shot tomorrow at work!

Posting Permissions

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