I am updating data from an external source into excel. One of the columns is supposed to be a url link that the end user can double click on to open a picture. The trouble that I am having is the link imports as
=HYPERLINK("http://.........(...(represents urls that are in the data)) which requires that I run a search and replace on this column replacing "=" with "=" at which point it does convert to "link to pdf" and will work as such. This is preventing this report from being automated. Anyone know of a way to fix this?
=HYPERLINK("http://.........(...(represents urls that are in the data)) which requires that I run a search and replace on this column replacing "=" with "=" at which point it does convert to "link to pdf" and will work as such. This is preventing this report from being automated. Anyone know of a way to fix this?