Hyperlink formular not working

User Support Data Management
,
1

Hello
I tried using the hyperlink formula for adding attachments to Xls file. When I use this (cut and paste) =HYPERLINK(“https://kc.humanitarianresponse.info/attachment/original?media_file=username/attachments/”&A2”) and edit the username and cell number, excel says the formula is wrong.

When I type in the formula myself excel says it has identify an error in the formula and wants to correct it, when I accept, the hyperlink is created but the link does not take me to the attachments even though an logged in on my default browser. I observed that the hyperlink created after accepting excel suggestion is different from the above. For example, the “?” after original is deleted.
Please help

2

Hi @RayRay,

Would you mind trying this out that has been discussed in the previous post (it should solve your issue):

Have a great day!

3

Hello
I tried the new formula and it did not work for me.

Capture
Capture1131×143 20.2 KB

4

Hi @RayRay

Please copy the generated text and paste in your browser. That should work.

I’m still trying to find a formula that will work on clicking but I keep getting the same challenge. Once I find a way, I’ll update the thread.

2 Likes
5

Hi @RayRay,

Here’s the update.

Seems like the issue is with Microsoft Office suite handling Internet transitions. There’s a fix online I just found but it involves editing your registry. Please be careful if you plan to implement this.

https://answers.microsoft.com/en-us/msoffice/forum/all/office-19-hyperlink-returns-cannot-download/4fe351a8-6438-4167-b008-7045a0ce1971

2 Likes
6

Hi @funmitoblessed
Thanks for the help. The copy and paste worked.

2 Likes
7

@funmitoblessed
Thanks for this. I don’t think I want to edit my registry. I would manage with either the copy and paste or I would download the attachments as a zip file.

Appreciate

1 Like