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.
Bookmarks