I'm using Excel 2003.
I have a hyperlink in cell E4 in worksheet406R
to cell E4 in worksheet104S
. When I move E4 in worksheet104S
to another location (E16) or sort the data in this worksheet, the cell E4 in worksheet406R
still displays the content of the original linked-to cell, but when I click on it, it goes to cell E4 in worksheet104S
(which now contains new data), not to the new location (E16) as it should (but still displays its content). How can this be fixed (go to the new location of the linked-to cell).