I have 2 .xlsx files, one of which has about 135,000 rows and the other with about 5,000 rows.
The files have a common key so that I can do a VLOOKUP to pull selected data from the big file to the small one.
When I try the VLOOKUP, I get the error,
"Invalide reference. This file version cannot contain formulas that reference cells beyond a worksheet size of 256 columns (column IW or higher) or 65,536 rows."
How is this even possible? I am using Excel 07 and both of these files were created in 07!!!
jpf
The files have a common key so that I can do a VLOOKUP to pull selected data from the big file to the small one.
When I try the VLOOKUP, I get the error,
"Invalide reference. This file version cannot contain formulas that reference cells beyond a worksheet size of 256 columns (column IW or higher) or 65,536 rows."
How is this even possible? I am using Excel 07 and both of these files were created in 07!!!
jpf