Forum Discussion

DataQue's avatar
DataQue
Copper Contributor
Feb 28, 2020

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 ...
excel
PReagan's avatar
PReagan
Bronze Contributor
Feb 28, 2020

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.

  • DataQue's avatar
    DataQue
    Copper Contributor
    Mar 03, 2020

    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!

Resources