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 |
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) |