Two files, both .xlsb - File B looks to File A. File A has 15 columns and 270,000 rows of data.
If the VLOOKUP in File B refers to the full unnamed range in File A, everything OK. File B saves as an .xlsb with no issues.
If the VLOOKUP in File B refers to a partial unnamed range in File A (say 15 columns and 15 rows), everything OK. File B saves as an .xlsb with no issues.
If the VLOOKUP in File B refers to a partial NAMED range in File A (say 15 columns and 15 rows titled "SHORT"), everything OK. File B saves as an .xlsb with no issues.
BUT...
If the VLOOKUP in File B refers to the full NAMED range in file A (15 columns and 270,000 rows titled "LONG"), file B will not save as an .xlsb, saying that "Some features cannot be saved".
Has anyone encountered this? Try on your version. I'm baffled as I can find no information that .xlsb is limited to a set number of rows, and it works just fine if the range is unnamed. As soon as you name it, it doesn't work. But, as I stated, this only seems to apply to large number of rows. If small numbers of rows, named ranges are OK.
????
Bookmarks