Microsoft says Excel 07 to support unlimited rows
I get quite a bit of traffic for Excel 2007, and wanted to make sure that the old post was accurate.
In the beta release of Excel, it only supported 1,048,576 rows, which is often not nearly enough for data analysis (although a huge improvement over the current number).
I’ve been informed by Microsoft that Excel will support an unlimited number of rows.
Might want to beef up on your computer’s memory though, currently it takes a solid gig of RAM to easily work with a 75mb excel file. With unlimited rows, those pivot tables could easily break the 500mb mark.