Forum Discussion
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 excel worksheet ... the C&P works ... the full path is put in a new cell
2) However if I open the link : Insert Hyperlink : to existing file or web page> when I try to C&P the path to the address box ... nothing is copied ..... and If I close the link box and try a Ctrl+V back to the worksheet .... the buffer is empty
3) Also related Hyperlink problem: When I copy existing Hyperlinks to a new worksheet it gets courted ...
eg if my path was :...
.....… C:\0-IFA-4-Data\Databases\OTA day trading - training\HH-Spread Sheets\Design-Top--Index of files.xlsx
it becomes inside the hyperlink address bar
............. Design-Top--Index%20of%20files.xlsx ...... and the link fails
Please 1) ... how do I fix the Hyperlink C&P problem
Please 2) ... how do I stop excel corrupting all my existing hyperlinks
Thank you for your time
- 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")
17 Replies
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 bufferIf 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
- Hi HH Here again.... Still have Excel Hyperlink function failure .... How can I address this issue direct to Microsoft and get a response ?
Thanks- Open a file exhibiting the problem. Click File, feedback, I don't like something. Describe the problem.
- 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 .... your manual fix works 100% and is OK for a basic fix
... but to uses I need to create a manual created hyperlink and have the file path available on the same work sheet ..... this is very clumsy as I use many links at the top of my worksheets
so CTRL+K plus the CTRL+V still fails to create a hyperlink
....also..
I still do not know why excell saves existing hyperlinks with % a revised path which stops the hyperlink working !!!
eg .. Asset%20-%20Codes.xlsx
instead of the path ... C:\0-IFA-4-Data\Databases\OTA day trading - training\HH-Spread Sheets\Asset - Codes.xlsx
Who can I contact in Microsoft ?
..... Feedback > I dont like somthing > ... I have tried without results ...
Do you know and excell support direct email address ?
Thanks- You might contact Microsoft support (not free), but I would not count on a fix anytime soon, as this probably requires them to make changes to the programming of Excel.
Can you perhaps upload a sanitized copy of a file which contains such a hyperlink?
- Hi Jan
Thank you .... your solution works perfectly and I can continue with my work
Any Suggestions to whom I should address my questions as to why
1) Microsoft Excel Hyperlink address .... copy and paste has stopped working ?
2) Why Microsoft is randomly re-writing my Link paths (Design-Top--Index%20of%20files.xlsx) preventing them from working !!..?
Kind regards Richard- If there is anything you do not like in how Excel works, click File, Feedback (from Excel).
If there is a dialog about which you want to give feedback about, first take a screen-shot of that dialog and paste that onto your worksheet. Then click Feedback so you can include a screenshot with the dialog.
