View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sephiroth Sephiroth is offline
external usenet poster
 
Posts: 2
Default data with more than 65536 lines

Dear,

I have an excel file with tons of data, multiple sheets (~63MB in size). I
want to compile it into one sheet and make use of vlookup. But I encounter
the limit which one sheet cannot exceed 65536 lines...appreciate any
suggestions ^_^