Last row on spreadsheet is row # 65536. How can I add more rows?

[Margarita]

Need to add more rows beyond row # 65536 (the very last row on the
spreadsheet) to add more data to the pivot table. Thanks

 

[T. Valko]

If you're using Excel 2007 there are over 1 million rows. If you're using an
earlier version such as Excel 2003 then the limit is 65536.

 

[Jim Thomlinson]

Where is your data coming from. I assume you have not typed in 65,536 rows of
data. Assuming it is an external database then you can hook a pivot table
directly to the database. When you create a pivot table your first step is to
specify your data source. If you select External Data then you can hook
directly to your database. Doing this you are only limited by memory so you
will be good to up to a million or so rows of data...

 

[macropod]

Hi Biff,

In Excel 2007, the compatability mode limit is still 65,536.