Continuation of this question.
I have an Excel 2010, 32-bit spreadsheet with a connection to SQL Server where one of the columns / 500ish rows is a =HYPERLINK(). My problem is, when I do a Data tab: Refresh, it posts the function in the cells NOT as a hyperlink, and it only renders like a hyperlink when I click in the cell and hit the <return> key.
the cell appears like this (mocked up)
=HYPERLINK("https://sg42.salesforce.com/001AA000018NXZx9ZIAS", "MATTHEWS, PATRICK")
only the name appears, blue and underlined.
Question: How to get the above function to render as a hyperlink when the Data>Refresh All is clicked?