Extend rows in Excel

[ranebow]

I have a dump from a main frame into a spreadsheet. If I select all the records I want it creates more rows that what Excel can handle. Is there any way to "Extend" the number of rows in a spreadsheet?

 

[AnotherHiggins]

Excel's limit is 65536 rows per spreadsheet. You can find this and other info by going to Excel Help and typing in "specifications".

You could truncate the data to the first 65536 records, then dump records 65537 and up to a different sheet, but that's not a good way to proceed.

Do you have MS Access? It is more much suitable for handling that much data.

[tt]_____
-John
[/tt]Help us help you. Please read FAQ181-2886 before posting.