I have a table that consist of Account information and that table is
referenced from other Excel files. Most of the time the information it
returns is correct but sometimes it returns the wrong information or no
information and to clear it up, I simply open the VLookup table file. I don't
have to edit anything, just open the file and everything clears up, why is
that? and is there a way to fix it?

The problem is that Excel can only link to external arrays of a certain
size.

If I use a formula like this:

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

Where the source file contains 65536 rows of actual data.

That formula returns an #N/A error if the lookup_value is after row 16375 in
the source file when the source file is closed. If the source file is open
it works as expected.

--
Biff
Microsoft Excel MVP


"MParham" wrote in message
...
I have a table that consist of Account information and that table is
referenced from other Excel files. Most of the time the information it
returns is correct but sometimes it returns the wrong information or no
information and to clear it up, I simply open the VLookup table file. I
don't
have to edit anything, just open the file and everything clears up, why is
that? and is there a way to fix it?