+ Reply to Thread
Results 1 to 3 of 3

Excel How to get Hyperlink updated if location is changed

  1. #1
    Registered User
    Join Date
    06-08-2009
    Location
    Michigan
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    29

    Excel How to get Hyperlink updated if location is changed

    Hello, I am using MS Office 365

    To create a link to another spreadsheet in the same workbook,
    • Right mouse click a cell
    • Select Link
    • On the left, select "Place in This Document", update the "Text to display, enter the cell reference, and select the spreadsheet in "place in this document"

    This link works.
    Problem is if I insert a line above the target cell in the spreadsheet that I want to link to, the cell that has the link still points to the original target cell location.

    For example:
    In Sheet2, create a link to jump to Sheet1 cell B3 using the procedure listed above
    In Sheet1, insert a blank line above row 2 so B3 is now B4
    If I click the link created in Sheet2, it will jump to Sheet1 cell B3

    Is there a way to create/setup the link so the link is automatically updated if the target cell is moved?
    Referring to the example above, I want the link to jump to Sheet1 cell B4 after a line is inserted

    Thank you for any advice you can provide.

  2. #2
    Registered User
    Join Date
    04-01-2019
    Location
    HK
    MS-Off Ver
    2010
    Posts
    32

    Re: Excel How to get Hyperlink updated if location is changed

    Name cell B3.

    Visit: support.office.com/en-us/article/define-and-use-names-in-formulas-4d0f13ac-53b7-422e-afd2-abd7ff379c64

  3. #3
    Registered User
    Join Date
    06-08-2009
    Location
    Michigan
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    29

    Re: Excel How to get Hyperlink updated if location is changed

    Cool. The link did not have what I was looking for but it gave me enough info to search for the right stuff.
    Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Showing the correct updated hyperlink on excel
    By itzfeng in forum Excel General
    Replies: 1
    Last Post: 08-18-2017, 07:02 AM
  2. [SOLVED] List All Changed Excel Files Today On Drive And Hyperlink (Incl. Subfolders)
    By alienware in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-10-2014, 03:18 AM
  3. Excel Hyperlink to location within same file from word within cell
    By dave1983 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-23-2014, 11:38 AM
  4. Excel VBA in a userform that create a hyperlink into a specific cell location
    By mikeflatley01 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-19-2013, 08:04 PM
  5. [SOLVED] Changed or Updated property?
    By Stefi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-14-2005, 03:30 AM
  6. [SOLVED] how do I hyperlink excel to a specific location in a PDF?
    By shakes in forum Excel General
    Replies: 0
    Last Post: 10-03-2005, 01:05 PM
  7. hyperlink an excel cell to a specific location wthin application f
    By dirtboy in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-17-2005, 05:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1