| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need more rows
I have a lot of data and I need about 300K rows, is there a way I can get
more? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need more rows
hi
if you have 2007 then you have 1,048,576 rows and 16,384 columns. if you have 2003 or lower, then you have 65536 and 256 columns and no way to increase that. regards FSt1 "Lindsey" wrote: I have a lot of data and I need about 300K rows, is there a way I can get more? Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need more rows
Hi Lindsay,
What version of Excel are you using? Excel 2003 has 65,536 rows Excel 2007 has 1,048,576 rows -- Regards Michelle Mathews MCT, MCASI, MMI, IC3 AI, JEB TDip ITS, JEB TDip ITA, MITBTI "Lindsey" wrote: I have a lot of data and I need about 300K rows, is there a way I can get more? Thanks! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need more rows
Buy Excel 2007
"Lindsey" wrote: I have a lot of data and I need about 300K rows, is there a way I can get more? Thanks! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need more rows
Yes, I have the 2003. I wish I had 2007, but it is not my choice. :(
"Mike H" wrote: Buy Excel 2007 "Lindsey" wrote: I have a lot of data and I need about 300K rows, is there a way I can get more? Thanks! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need more rows
Then you'll have to do with the rows you have
"Lindsey" wrote: Yes, I have the 2003. I wish I had 2007, but it is not my choice. :( "Mike H" wrote: Buy Excel 2007 "Lindsey" wrote: I have a lot of data and I need about 300K rows, is there a way I can get more? Thanks! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need more rows
If you can use a pivot table then you are not limited to 65k rows. The pivot
cache is only bounded by memory so you can potentially have over a million rows in xl2003... -- HTH... Jim Thomlinson "Lindsey" wrote: I have a lot of data and I need about 300K rows, is there a way I can get more? Thanks! |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need more rows
If you have Excel 2003 and you are limited to 65,536 rows you might think of
using a Pivot Table. -- Regards Michelle Mathews MCT, MCASI, MMI, IC3 AI, JEB TDip ITS, JEB TDip ITA, MITBTI "Lindsey" wrote: Yes, I have the 2003. I wish I had 2007, but it is not my choice. :( "Mike H" wrote: Buy Excel 2007 "Lindsey" wrote: I have a lot of data and I need about 300K rows, is there a way I can get more? Thanks! |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need more rows
You can use MS Access. Many rows available there. Depends on what you are
trying to accomplish. "Lindsey" wrote: Yes, I have the 2003. I wish I had 2007, but it is not my choice. :( "Mike H" wrote: Buy Excel 2007 "Lindsey" wrote: I have a lot of data and I need about 300K rows, is there a way I can get more? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting characters in multiple rows when rows meet specific criteria | Excel Worksheet Functions | |||
| Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
| Get number of rows that data takes up, including blank rows | Excel Worksheet Functions | |||
| Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) | |||
| Pivot Tables: How do I show ALL field rows, including empty rows?? | Excel Worksheet Functions | |||
Linear Mode
