A function imports a row of hyperlinks into an Excel spreadsheet that look like text...
=HYPERLINK("https://webistename.aspx?ID=3&WA=1","A110912")
The problem is that they don't act as a hyperlink until I physically click in each cell and hit F2 or <enter>. After that they are displayed as needed. Is there a formatting option that will allow them to behave as hyperlinks without doing this?
Thanks.
=HYPERLINK("https://webistename.aspx?ID=3&WA=1","A110912")
The problem is that they don't act as a hyperlink until I physically click in each cell and hit F2 or <enter>. After that they are displayed as needed. Is there a formatting option that will allow them to behave as hyperlinks without doing this?
Thanks.
Last edited: