Vlookup limitation in Excel 2010? ‘INVALID REFERENCE. THIS FILE VERSION CANNOT CONTAIN FORMULAS THAT REFERENCE CELLS BEYOND A WORKSHEET SIZE OF 256 COLUMNS (COLUMN IW OR HIGHER) OR 65536 ROWS’
…. You gotta be kidding me.
How this error is triggered? When I perform vlookup from a file to destination file… How I resolve it? I had to copy the info from destination file into the same file that I am performing the vlookup, under a different worksheet. Seems like there’s a bug that limit vlookup from foreign files. I’ll get back to this later.
SPAM and Virus prevention by Barracuda Network Solutions
No comments:
Post a Comment