KAPPA_DOGFACE
New Member
- Joined
- Jan 22, 2019
- Messages
- 2
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!
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!
