+ Reply to Thread
Results 1 to 4 of 4

Hyperlink cell references not updating when I insert a row

  1. #1
    Registered User
    Join Date
    06-24-2022
    Location
    Portsmouth, England
    MS-Off Ver
    Excel 2016
    Posts
    3

    Hyperlink cell references not updating when I insert a row

    My spreadsheet has a contents page on one worksheet and a contact list of contact numbers on another worksheet. I have created a hyperlink for each entry on the contents page referring to a range of cells on the contact list on another page. This makes it clear what each entry refers to.

    The problem is that when I insert a row into the contact list worksheet the cell range of the hyperlink on the contents page remains the same. This means the hyperlink on the contents worksheet no longer refers to the correct cell range on the contact list worksheet.

    Any idea of how I can fix this? Any help would be much appreciated.

    I've attached a before and after spreadsheet showing before and after inserting a row. It's a sample of my real spreadsheet without real names and phone numbers.
    Attached Files Attached Files

  2. #2
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    365(PC) V:2308
    Posts
    1,472

    Re: Hyperlink cell references not updating when I insert a row

    Make a Defined name for each of the description ranges. For example i made a name CLEANING for the range $A$7:$C$13 as shown below.
    Then when makeing your link, link to the defined name instead and it will update ranges accordingly when rows are added.
    Attached Images Attached Images
    <----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.

  3. #3
    Registered User
    Join Date
    06-24-2022
    Location
    Portsmouth, England
    MS-Off Ver
    Excel 2016
    Posts
    3

    Re: Hyperlink cell references not updating when I insert a row

    Thanks dosydos, that's worked a treat!

  4. #4
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    365(PC) V:2308
    Posts
    1,472

    Re: Hyperlink cell references not updating when I insert a row

    Glad to help. Thanks for the rep!

+ 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. updating cell references
    By San75 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-30-2016, 03:52 PM
  2. [SOLVED] Copying code down a column without all cell references updating.
    By RichardJSigKits in forum Excel General
    Replies: 28
    Last Post: 02-27-2014, 05:10 PM
  3. [SOLVED] Creating a Hyperlink using only cell references
    By rfaris in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 08-07-2013, 09:40 AM
  4. Conditional Formatting - Updating Cell References
    By NahRoots in forum Excel General
    Replies: 1
    Last Post: 10-27-2011, 05:00 PM
  5. Mass updating of cell references
    By DanielHutchison in forum Excel General
    Replies: 1
    Last Post: 07-01-2008, 11:08 AM
  6. Replies: 2
    Last Post: 12-08-2007, 09:29 PM
  7. Updating cell references...
    By ChrisMattock in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-02-2007, 11:05 AM

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