Hola to everybody,
I'm working with a Mac. I've the following situation.
in a dropbox directory called /Users/vin/Dropbox/ELWIDTJFU I've 2 directories called:
Master with file ELWIDTJFU.xlsx
T1 with file T1.xlsx
from the file ELWIDTJFU.xlsx I copy some data from the file T1 with the following URL
='Macinstoh HD:Users:vin:Dropbox:ELWIDTJFU:T1:[T1.xlsx]Students'!$GK$131 and everything is fine.
My problem starts if I open the file ELWIDTJFU.xlsx, in another computer as it doesn't recognize the path ='Macinstoh HD:Users:vin:Dropbox:ELWIDTJFU:T1:[T1.xlsx]Students'!$GK$131
I was wondering if it was possible to create a path which could actually work in all the computers, something that turns the path:
='Macinstoh HD:Users:vin:Dropbox:ELWIDTJFU:T1:[T1.xlsx]Students'!$GK$131 in
='../T1/[T1.xlsx]Students'!$GK$131 is anyone aware of something like this ?
Thanks in advanced, please don't hesitate to ask if you need further details.
Vin
Bookmarks