How many rows does Excel XP have?!!!!!!!!
Posted by Matt on October 16, 2001 12:05 PM
I am running office 97 and I'm constantly hitting the 65K limit of Excel. Someone told me that XL has many more rows. Can someone please tell me if this is true?
Thanks soooo much for the response.
Matt
Posted by Matt on October 16, 2001 12:07 PM
I meant XP in the message below -- not XL! It's almost 5 and I'm wiped out. Forecasts suck (especially in this quarter!).
Matt
Posted by Mark W. on October 16, 2001 12:51 PM
64 x 1,024 = 65,536 rows (nt)
Posted by Mark W. on October 16, 2001 12:58 PM
BTW... Control+Down Arrow shows the last row (nt)
Posted by Travis on October 16, 2001 3:09 PM
WHY???
I have always thought it was stupid to have this limit. Is there a reason for this? I see Mark posted 64X1024 which leads me to believe there is. : I meant XP in the message below -- not XL! It's almost 5 and I'm wiped out. Forecasts suck (especially in this quarter!). : Matt :
Posted by Dan on October 16, 2001 6:43 PM
Re: WHY???
Who knows? Maybe Excel's memory manager isn't efficient if it's trying to do calculations on that many cells, so they limit it. Remember this is a spreadsheet program, not a database program. If you need more rows then you will need to separate it on another worksheet. I have always thought it was stupid to have this limit. Is there a reason for this? I see Mark posted 64X1024 which leads me to believe there is.
Posted by Mark W. on October 17, 2001 6:04 AM
Why do you think this limit is "stupid"? (nt)
Posted by Matt on October 18, 2001 4:32 AM
Re: WHY???
I originally asked the question of how many rows because I know the constraints of Office 97 and had heard that Office XP may have been designed with new architecture (something about a 64 bit instead of a 32 bit) so perhaps the mathmatical constraints that limit me to 65,536 would be gone. I am maxing out worksheets quite a bit and I needed to know if I should hurry out and get a copy of XP for the extra rows. I guess I should keep what I have.
