Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Last row on spreadsheet is row # 65536. How can I add more rows?
Need to add more rows beyond row # 65536 (the very last row on the
spreadsheet) to add more data to the pivot table. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Last row on spreadsheet is row # 65536. How can I add more rows?
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. -- Biff Microsoft Excel MVP "Margarita" wrote in message ... Need to add more rows beyond row # 65536 (the very last row on the spreadsheet) to add more data to the pivot table. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Last row on spreadsheet is row # 65536. How can I add more rows?
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... -- HTH... Jim Thomlinson "Margarita" wrote: Need to add more rows beyond row # 65536 (the very last row on the spreadsheet) to add more data to the pivot table. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
more than 65536 rows | Excel Discussion (Misc queries) | |||
How to put in over 65536 rows? | Excel Discussion (Misc queries) | |||
Add more than 65536 rows? | Excel Worksheet Functions | |||
Why does rngDataSource.Rows.Count = 65536 when worksheet Rows=95? | Excel Discussion (Misc queries) | |||
Can I increase row capacity beyond 65536 rows | Excel Worksheet Functions |