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")
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")
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 ... Sanitized ?? All files I create experience the same hyper link problem
I am convinced as I can manually type in the link address the problem lies with the notebook and not the hyperlink creation.
Meaning when I open the hyperlink dialoged box, I wipe the contents of the notepad buffer.
The attached ss experiences the hyperlink corruption can be seen in Colum M and your workaround can be seen in Colum D
Thank you
Richard
The attached new file i created has the
- 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.
