@Dan_Miller wrote:
I know this question is now over a year old but I have come across it a couple of times while looking into how to do hyperlinks. Just found what your problem would have been related to while reading this:
http://blogs.sas.com/content/sgf/2017/02/20/tips-for-using-the-ods-excel-destination/
'When text wraps, a hard return is added automatically to the cell ' so you either need to set the width of the cell in which you want the hyperlink wide enough that it dosn't need to wrap or use the flow option to stop the automatic wrapping:
ods excel file="c:\temp.xlsx" options(flow="tables");
Hope this is useful to someone...
As I have switched jobs and no longer have my data to test this out, I would like to believe that this is the correct solution, but can't confirm it. Nevertheless, I thank you for the information, I have bookmarked this in case I run into this problem again.
... View more