There are only 65536 rows in a worksheet. You cannot use
all the rows. Split your sheet into sevral other sheets
and use another sheet to compile your records.
>I am using Excel 2000. Operating system is MS 2000. Ram
>I am running a large Excel file 65,536 rows by 24 columns.
>The columns may expand somewhat; say 5 extra rows as the
>The Excel file links to another Excel file to do some
>Some formatting is going on as well as Paste Special
>I get an out of error message and Excel stops.
>If I only have 50,000 rows it works fine.
>I have increased the virtual memory to the maximum, same