Dear all, I have arranged a sheet where a user just has to enter their server number and their folder name (which is their pay number).
Problem is i add the string of text together which exactly replicates the link string but it doesn't show the value from that sheet.
for example ='c:\documents and settings\my documents\linktest\123456\[link.xls]sheet1!a1
This is how the actual link looks, but when i combine columns of text into an exact replica of the above, No Link????
where am I going wrong and how do i get my combined text string to act as the link?
I hope someone out there knows what i am talking about and how to help?
thanks
Problem is i add the string of text together which exactly replicates the link string but it doesn't show the value from that sheet.
for example ='c:\documents and settings\my documents\linktest\123456\[link.xls]sheet1!a1
This is how the actual link looks, but when i combine columns of text into an exact replica of the above, No Link????
where am I going wrong and how do i get my combined text string to act as the link?
I hope someone out there knows what i am talking about and how to help?
thanks