Sending hyperlinks to Excel

[ZoeM]

Hello Community.

I have a request to send hyperlinks in a straight table through to Excel when the end user uses the "Send to Excel' shortcut icon. 

Is this possible? Would I need to create a button instead? I have searched the available comments and was not able to find anything that matches my requirement. All I have seen is by using macros and that is fine I do not mind but none of the macro examples are working. 

The URL's are working fine in QlikView but I only get the front text (Click Here) as text and no hyperlink. 

Any and every suggestion rendered will be appreciated. 

Thanks in advance. 

[Victor_Alumanah]

Hi There,  are you trying to get the hyperlink to work in excel when the users has sent the data from Qlikview to excel?  If that is the case, Excel will generally treat anything that looks like a url like a url.  Maybe you can add www. on the front and .com on the end to make them a hyperlink.

[Frank_Hartmann · Accepted solution]

one workaround might be to:

use your website field as expression like this:

=yourwebsitefield&'<url>'&yourwebsitefield

and declare the expression as a link (Expressions-> DisplayOptions->Representation->Link)

this will underline all links and you will be able to directly click and open the URLs.

When using the export button you will see that the weblinks in excel are now underlined. if you now double click into excelfield with URL and select an other field afterwards you will see that an active Hyperlink appears.