If the file is moved or renamed, then excel won't have any idea where to look
for it. (It could have been deleted!)

You can use Edit|Links (in xl2003 menus) to change the source of the links.

If you mean that you don't need to update the values returned by your =vlookup()
formula, you could convert them to values.

irealtymods wrote:

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.

--

Dave Peterson