Thank you...unfortunately I'm on Excel 2003, sorry I should have mentioned.
I do have the automatic update of links enabled in the options.

"Sheeloo" wrote:

I tested with Excel 2007...

The value got update even when the source file was closed.

I had to enable 'Automatic update of links'....

"Kathy L." wrote:

Hello - are there limitations around having the 'Table Array' in the vlookup
formula be another workbook? In other words, does the other workbook have to
be open to work, or any other limitation? I ask, because I'm trying to have
a vlookup to another workbook, and do not want users to have to open this
other workbook. When they open the file with the vlookup formula, we are
getting the prompt asking if they want to Update the data. When I select
Update, it doesn't seem to work. It seems to only show the values from the
vlookup from the last time I saved the file, or works if I open the other
workbook with the destination data. I hope that makes sense. Thank you.