What's your formula look like:

When the source file is closed Excel "complains" if the table_array is more
than 16375 rows. If your using something like this:

=VLOOKUP(A1,'C:\TV\[xxx.xls]Sheet1'!A:B,2,0)

Use a smaller specific range in the table_array if you can.

--
Biff
Microsoft Excel MVP


"Kathy L." wrote in message
...
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.