Clickable hyperlinks in Word and Excel with Paginated reports SSRS

[DatamirHub]

I have a field that contains URLs, which I’m displaying in a table in a paginated report. The links are only clickable when exporting to PDF, but not in Excel or Word exports. How can I make them clickable in all formats?

[DatamirHub · Accepted solution]

I found a solution, you can make the Markup type: HTML in the placeholder properties

and make it with HTML tag 

="<a href='" & Fields!WEB_PAGE.Value & "'>" & Fields!WEB_PAGE.Value & "</a>"

 This works perfectly on Word and Excel
if some links dont work they need to be http:// or htttps:// so i suggest this piece of code also

=IIF(
    NOT(IsNothing(Fields!WEB_PAGE.Value)) AND Fields!WEB_PAGE.Value <> "", 
    "<a href='" & 
        IIF(Left(Fields!WEB_PAGE.Value, 4) = "http", Fields!WEB_PAGE.Value, "https://" & Fields!WEB_PAGE.Value) & 
        "'>" & Fields!WEB_PAGE.Value & "</a>", 
    ""
)

[Bmejia]

I don't believe there is an solution to this issue, because in Excel this column is actuall extracted as a text. 

Work around is that once the user select the URL cell in Excel, it add the link properties

Also, you could use the Hyperlink(A2) formula in excel to update all at the URL at the same time but I understand this wold have to be done by every single users that downloads the file.