Vlookup between two workbooks
 

I have two workbooks linked across a network with a Vlookup function for
information that is time sensitive and needs to be updated quickly. When I
enter a value in Workbook A which requires info that is recently entered at
the end of the list of the Workbook B, it doesn't return the correct info.
It returns a value several lines above almost as if there hasn't been a
recent update and what it is returning is the last thing it remembers . The
F9 manual function works but an extra keystroke is cumbersome with this
application, and the majority of the time the automatic update works. Is
there an update timer and a way to set it to very short intervals?