Using "Get Data" with Hyperlinked cells

[KAPPA_DOGFACE]

Hi,

I currently have 2 spreadsheets, where I am using the "Get Data" function to pull data from one to the other.

One of the columns I am pulling through contains "hardcoded" hyperlinks (not using any formula), where the content of each cell is the name of a file, and the hyperlink to said file has been applied manually (using right click > Link)

When this data is pulled through, the content of the cell is kept, but the hyperlink is removed.

Is there a way I can retain the hyperlinks applied in this way after the data has been pulled through? (preferably not using VBA, if possible)

I have tried looking this up, but have found no one with a similar issue.

I would appreciate any help. I am using Office 2016.

Thanks!

 

[KAPPA_DOGFACE]

Is there someone who is able to help please?