hi

my 'query' sheet picks up various values using vlookup from a different excel file

all my formulas...everything work fine...but once i close 'query' and open it again....it asked me to update links.....which i do so that data is updated.....however once i do this half of my formulae don't return a value. the thing is that if i goto the formula not working and click on the formula bar once and press enter...it updates the formula and it picks up the value....why is this strange thing happening??? also 'query' picks up the values missing once i open the origin sheet from which data is being picked up

any clues. why isn't everything automatic ??