I am confused now, i ran the same code on a different computer, seems works fine. data link; name2='=Hyperlink("#''AA''!A6","Next >>")'; run; ods excel file="hyperlinks.xlsx" options(flow='data,table' autofilter='yes' embedded_titles='yes' frozen_headers='yes' ); ods excel options(sheet_interval="none" sheet_name="sheet" ); proc report noheader data=link out=b style(header)={verticalalign=middle} style(column)={verticalalign=top just=c asis=on BACKGROUNDCOLOR=white color=blue font=("Arial",8pt,bold)}; columns name2 ; define name2/format =$200. style(column)={ width=1in} ; run; ods excel close; but on the computer i met the issue, it show me the following error, when i click the white cell to see the value, it is empty, which should be '=Hyperlink("#''AA''!A6","Next >>")' if executed correctly. but if i remove "style(column)={ width=1in} ;" in proc report, the result is good. just the column width is wider than expected.
... View more