Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Row limit in Excel
I have around 75000 rows of data to be displayed in Excel sheet, but the data is getting truncated after 65536 rows because of the limit on number of rows that Excel allows. Is it possible to remove the row limit in the excel? or is it possible to add a new worksheet dynamically whenever one worksheet is full with 65536 rows? I am getting this large amount of data when I ran a nVision Report for Peoplesoft. In this, it runs a Query and outputs the result data to an excel sheet. Thanks in advance for any help. -- mannan ------------------------------------------------------------------------ mannan's Profile: http://www.excelforum.com/member.php...o&userid=33856 View this thread: http://www.excelforum.com/showthread...hreadid=536323 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Row limit in Excel
nope - you'll have to wait for excel 2007. Has a row limit approx 1000000 -- MattShoreson ------------------------------------------------------------------------ MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472 View this thread: http://www.excelforum.com/showthread...hreadid=536323 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Row limit in Excel
Hi Mannan,
See MSKB Knowledge Base Article # 120596 "Importing text files larger than 65536 rows" http://support.microsoft.com/default...b;en-us;120596 --- Regards, Norman "mannan" wrote in message ... I have around 75000 rows of data to be displayed in Excel sheet, but the data is getting truncated after 65536 rows because of the limit on number of rows that Excel allows. Is it possible to remove the row limit in the excel? or is it possible to add a new worksheet dynamically whenever one worksheet is full with 65536 rows? I am getting this large amount of data when I ran a nVision Report for Peoplesoft. In this, it runs a Query and outputs the result data to an excel sheet. Thanks in advance for any help. -- mannan ------------------------------------------------------------------------ mannan's Profile: http://www.excelforum.com/member.php...o&userid=33856 View this thread: http://www.excelforum.com/showthread...hreadid=536323 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Row limit in Excel
Hi mannan,
Do you really need to *display* 75,000 rows? Or just analyse them? If its the latter, you could load the data into an array, analyse it there with vba, then write the results to a worksheet (or even another file). I've processed data sets of 11,000,000 rows this way, far faster than loading them into worksheets and processing with formulae could possibly have permitted. Cheers "mannan" wrote in message ... I have around 75000 rows of data to be displayed in Excel sheet, but the data is getting truncated after 65536 rows because of the limit on number of rows that Excel allows. Is it possible to remove the row limit in the excel? or is it possible to add a new worksheet dynamically whenever one worksheet is full with 65536 rows? I am getting this large amount of data when I ran a nVision Report for Peoplesoft. In this, it runs a Query and outputs the result data to an excel sheet. Thanks in advance for any help. -- mannan ------------------------------------------------------------------------ mannan's Profile: http://www.excelforum.com/member.php...o&userid=33856 View this thread: http://www.excelforum.com/showthread...hreadid=536323 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
66,000 excel record limit | Excel Worksheet Functions | |||
Row limit in Excel | Excel Discussion (Misc queries) | |||
Row limit in Excel | Excel Discussion (Misc queries) | |||
Row Limit in Excel | Excel Discussion (Misc queries) | |||
Nested IF limit or Open parentheses limit | Excel Discussion (Misc queries) |