Forum Discussion
Solved
Insert Hyperlink tool : Cut and paste fail into Hyperlink address & corruption of existing link
Hi I run MS office Home & Buis 2019 which I have just downloaded and re-installed, in an attempt to clear this Excel problem ..... It did not !! 1) If I use Ctrl+C and Ctrl+V on a path in an ex...
- Perhaps use the HYPERLINK function instead of hard-coded hyperlinks.
With the text of the link in cell A1:
=HYPERLINK("file:"&A1,"Click to open file")
Thanks Jan
.......Sorry I am not that well educated in tech to use the information as a prompt to discover the reason
Richard
.......Sorry I am not that well educated in tech to use the information as a prompt to discover the reason
Richard
HHDXB You wrote an email to me explaining that the issue is with Notepad emptying the clipboard because if you use another text editor like Notepad++, you can paste the hyperlink.
Great to know the root cause of your issue.
My suggestion to prevent hyperlinks from changing: don't use the Insert Hyperlink feature, but use the HYPERLINK function with a helper table like in the attached example.