Hi,

I have a vlookup formula that references a range name in an external
workbook. When I have done this with earlier versions of Excel I don't
recall having any problems. However, now I keep losing my link to the lookup
table file, and my formula returns #REF! I always thought that with a
vlookup, it was not essential to have the lookup table file open. Maybe it
is.

Any ideas please?

Many thanks,

Karen.