Web links no longer works after data refresh

[DataQue]

Hi,

I have a strange problem.  Hope someone can help.

I have an Excel file with data source linked to a sql table.  Within the table, one of the data fields contain the text url.  The values in this column are all like "=HYPERLINK("http://.....".  Once the values for this field shown in Excel properly, the user can click on the cell and linked web page will open.

The problem is: every time after data refresh, Excel does not recognise those values as web links.  Instead, it will just display them as text url, i.e., =HYPERLINK("http.......   I either have to double click on each cell and hit Return key to change it to a web link.  Alternatively, if I replace "=HYPERLINK" with "=HYPERLINK", then Excel will recognise those values as hyperlinks and the clicks are active.

If I don't use the data connection to refresh the Excel file but run the select query and paste the results of the same table into Excel, Excel will automatically recognise them as web links and display Friendly_name of the Hyperlinks in each cells.

Has anyone experienced the same problem?  Have you found a solution without using any macros?

Thanks!

[#2]

Hello @DataQue,

Perhaps the following will help:

https://excelribbon.tips.net/T013403_Hyperlinks_No_Longer_Work_in_a_Workbook.html

If not, please let me know and we can explore more options.

[#3]

Hi,

Thank you for your reply.  

No, that option doesn't fix the problem.  If I have fixed the web links for Excel to recognise it as web links instead of the text URL, once the file is saved and the links will continue to work.

The problem is after I select data refresh, Excel will display the links as text URL again.  I looked at the connection properties and I couldn't find anything that could affect this.

Any other thoughts will be appreciated.

Best wishes!