>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.
See if you can change the formula to a relative path. For example, if it is in the same directory, use only the file name; if it is in a subdirectory, something like 'MyDirectory\[MyFile.xls]'...
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
