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")
HHDXB here
The problem has been resolved.
The problem was NOT in the HYPERLINK address box ( CTRL+K)
The problem IS in the MS notepad
When Hyper link is opened it wipes clean the notepad buffer
If you download a non MS notebook ( https://notepad-plus-plus.org/downloads/ ) and use the Notepad++ tool copy the required path to the HYPERLINK address bar ..... the created link works 100%
Thanks to Jan Karel Pieterse and Fisal for their support and comments