I have recently added 3 x hyperlink to my spreadsheet as its now some 138 rows in length.

All works fine with the 3 x hyperlinks & a click of whichever one moves me to different sections of the spreadsheet.

My problem is that when I copy the worksheet (right click on the tab, select move or copy) & then make a copy the hyperlink refers back to the original copy & I have to manually change it to relate to it's own copy.

is their anyway to stop Excel doing this so the hyperlinks when copied all relate to their own worksheet?

Thanks for any help.