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.