LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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 ^_^
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
data with more than 65536 lines Sephiroth Excel Discussion (Misc queries) 3 December 22nd 08 10:06 PM
How Can I import external data what is more than 65536 lines? KurtHan71 Excel Discussion (Misc queries) 2 February 14th 08 01:51 PM
Can I go beyond 65536 lines in a file? R.K.Anscombe Excel Discussion (Misc queries) 1 January 31st 06 11:17 PM
Excel should allow more than 65536 lines. mc Excel Worksheet Functions 1 January 19th 06 03:23 PM
Data which is over 65536 lines long KI Excel Discussion (Misc queries) 1 November 16th 05 10:17 AM


All times are GMT +1. The time now is 11:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"