apologies for the late follow up.

It is quite strange that the values to be displayed (using
vlookup)appear initially when the base file is open....and not
otherwise. but once i open and close it, it does display the output
for sometime....but once i close the main enquiry sheet I again need to
open the base file once. Don't understand why & how it works like this

any clues?


--
shrutikhurana
------------------------------------------------------------------------
shrutikhurana's Profile: http://www.excelforum.com/member.php...o&userid=29868
View this thread: http://www.excelforum.com/showthread...hreadid=510466