Saving excel file with > 64K rows as 2004/97

[Guest]

If I have more than 64K rows in a 2007 spreadsheet (great new feature) ..
what happens to the rows beyond the 2003 limit?

 

[Guest]

If you have more than 65,536 rows and attempt to save in earlier format,
Excel will give you the following message:
This workbook contains data in cells outside of the row and column limit of
the selected file format. data beyound 256 (IV) columns by 65,536 rows will
not be saved. Formula references to data in this region will return a #REF!
error.

 

[Guest]

If you have a need to do that kind of thing, there are a couple of pre-Excel
2007 format files I have that could help.

This file will read a .csv file with more than 64K rows into a workbook,
creating extra pages for the additional rows:
http://www.jlathamsite.com/uploads/ImportExcessRowsOfData.xls

With it you could take your 2007 sheet, save it in .csv format, then read it
back into a pre-2003 format file using that workbook - either at your end or
you could send the workbook and the .csv file to the recipient and let them
do the legwork.

Time to process (based on 2 columns of data - one column short text, 2nd
column decimal numeric values)
System: AMD 3200+, 1GB RAM
2,417 rows: 4 seconds 185,253 rows: 2m 50s, 436,615 rows: 4m 52s
attempted read of 1, 208,500 rows: system resources exhausted at 1,047,808
rows

System: Intel Core2 Duo E6600, 2GB RAM
2,417 rows: 4s, 185,253 rows: 1m 28s, 1,208,500 rows: 9m 05s

And if you have need to import data that has more columns than the version
of Excel you're using (perhaps from 2007 to earlier Excel version, or large
database into any version of Excel), then this one could assist you:
http://www.jlathamsite.com/uploads/ImportExcessColumnsOfData.xls