In sheet1 I made a link to Sheet2!B7. All is well and clicking on the link in Sheet1 will take me to the B7 in Sheet2. Now I add ten rows above the object in Sheet2. The link in Sheet1 still takes me to B7 in Sheet2, but my intended target is now at B17.

Is there any way to make the link automatically follow the intended target if rows or columns are added or subtracted?