Showing the correct updated hyperlink on excel

[itzfeng]

Hello,
I notice that everytime I bulk tried to find & replace the hyperlink inside a excel cell, once hover over or clicked on the link it will show the old original outdated link, I was wondering how can I have the new one to show everytime.

Below is a example of what I'm referring to.

 

[Scott T]

When you do the find and replace you are only editing the text that is displayed not where the link points to. You would need to right click on it and select edit hyperlink and change the destination of the link.

 

[itzfeng]

Thanks for your prompt reply.

Hmm... well that seems to be a lot of work, only reason I used find & replace is to speed up the hyperlink changed when importing into a software I used to read each value. I remember other sheets I do when I find & replace, the hyperlink will automatically change with it, not sure why this sheet doesn't. Is there possible a excel option or setting that can default this to automatically update link base on text changes, as if I have 100 hyperlink change, I don't really have the time to click and assign them one at a time.

 

[Scott T]

I am not aware of any settings for this but maybe someone else has a solution for you.