I am not in same network, I did not know that Excelstors the most recent
values from the third-person file.
can excel can have an Embedded file for look up.

"Lotus123" wrote:


If I interpret your question correctly, it sounds like Excel has stored
the most recent values from the third-person file in the current file
you are using. This is one of the reasons using vlookup will bloat the
size of your Excel file. Not sure if that was the answer you were
looking for.


--
Lotus123
------------------------------------------------------------------------
Lotus123's Profile: http://www.excelforum.com/member.php...o&userid=28611
View this thread: http://www.excelforum.com/showthread...hreadid=486380