is there a way to force excel to use relative paths instead of the full
path to the file in which the table array resides?

right now, vlookup looks for a particular file in a particular
directory, but if the file is moved, it breaks all the formulas. it
would be great if it would use the relative path (e.g. the folder in
which it is placed) to avoid such an error.

thanks.


--
dreamz
------------------------------------------------------------------------
dreamz's Profile: http://www.excelforum.com/member.php...o&userid=26462
View this thread: http://www.excelforum.com/showthread...hreadid=469937