Please double check the formula you posted, perhaps copy it exactly from the
workbook in question. I don't see a sheet name or valid name in the formula
you put up. Data[#All] is not a valid Name, and [] are not valid characters
in a worksheet name. At least I can't get a name defined as Data[#All] in
Excel 2007 (nor in 2003).

"zxcvbnm6000" wrote:

I keep receiving a #REF! error when I try to use VLOOKUP to find data in one
document and bring it to another. If both documents are open all the numbers
are fine. However when I close the book with the data I receive the error, or
when the vlookup book is opened it does it. If tell it to update the data
error, if I don't update error. What is weird is I have other documents that
work fine, with the same equation. Please help because I'm lost on this
issue. Happens Excel 2007 and 2010.

=VLOOKUP(A2,'C:\Users\USER\Documents\BOOK DATA.xlsx'!Data[#All],2,FALSE)