Hi, I am Ian Malik. Within the same Workbook I have created a link in Worksheet1 to a specific cell on Worksheet2. Later, I inserted a new row into Worksheet2 above the referenced cell, so now the link in Worksheet1 refers to the wrong cell. Please advise if my link can be auto-updated and how to do it. Thank you and kind regards..... I am using Excel 2019.
Last edited by ianmalik; 09-07-2020 at 10:55 PM. Reason: Update info
When you say, "I have created a link", did you actually go to INSERT, LINK, INSERT LINK, or are you just referencing the cell (Meaning in the cell on Sheet2 you entered something like =Sheet1!B5?
Thank you for your response Gregb11. I actually inserted a link in Worksheet1 via: INSERT / LINK / INSERT HYPERLINK to a specific cell in Worksheet2.
Give the cell a "Defined Name" so then if you insert rows/columns the link will still go there.
Done and tested. Problem solved and very much appreciated. Thank you!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks