Hi

I have a large, sorted and hidden dataset in a closed workbook $A$1:$G$15000 that I need to access from another workbook.

eg
=IF(C25="","",VLOOKUP($C25,'H:\Folder\[ClosedBook.xls]DataSheet'!$A$1:$G$15000,2,FALSE))

This works fine for me in 2007, however, in 2003 other users get a #NA for any data in rows 8583 and above - unless they open the source book (not ideal)

Is there another way that I can approach this, or have i reached a range limit?

thank you

Val