Forum Discussion
Web links no longer works after data refresh
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 ...
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.
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!