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.