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?