One hyperlink in a huge excel file

Question

Hello,

I have an Alteryx workflow, which generates an .xlsx file daily. It has many columns but I want one specific column to be shown as a hyperlink in Excel (in fact, the fields in the column are links, I just want the user to be able to click on them directly).

Is it possible to achieve this without Render and Table tools, because when I use them the format of the whole spreadsheet gets distorted..

Thank you!

ed_hayter · Answer

Only seems possible by altering the users excel configuration:

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Excel-convert-field-value-to-hyperlink-in-output/td-p/359859

If you can mock up some dummy data we can try and get the reporting tools in a desired format and get the links working for you.

Prometheus · Answer

@insomned I know you said you don't want to use Reporting tools, but this solution shows how you can. Check it out: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Hyperlink-Excel-Formula/m-p/505209#M104549.