Dear Sir/Madam
I have a Excel Sheet which value are Linke to may other Excel sheet trough formula.
In the formula the reference is give of the closed excel sheet include its path in the formula.
e.g
=VLOOKUP(A4,'F:\DailyDocuments\CPO Sauda\[CPO Sauda.xls]CPO Sauda-New'!$A$1:$L$130,4,FALSE)
If I Copy my whole directory to another machine with same directory structure. Everything works fine but I cannot be sure of Drive Letter .
So I have to manually change the Drive letter in the formula.
Please suggest how to handle.
Thanks in Advance
Rahul