i have vlookup formula to external file, but what if that file moved or
renamed?? how to keep vlookup to find what i need?? there is formula extra
properties??

and is it possible to keep data once received? some cache, i mean if i have
some table full already, all needed data is taken from other file, do not
update this table any more.


there is any better alternative to this formula + changes above?
=VLOOKUP(K29;'C:\Data.xls]Data'!$A$5:$Z$568;12;FALSE)

thank you.