Hi there,
New to this forum so please be kind.
Does anyone know what the Excel 2013 row limit is? I know for 2010 it's a little over 1million rows.
Thanks,
Lazz64
Hi there,
New to this forum so please be kind.
Does anyone know what the Excel 2013 row limit is? I know for 2010 it's a little over 1million rows.
Thanks,
Lazz64
65,536 is it
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Really? It couldn't possibly be less than 2010?
To clarify, I am after the row limit for Excel 2013 not 2003??
Ability to analyze data ranging from a few rows to hundreds of millions of rows
Yes this is correct.
Excel can analyze data that is being pulled from an external data source or multiple sheets/workbooks.
I am specifically after the row limit of a single sheet in Excel 2013??
Thanks
well since row/column numbers are not mentioned in any of the "new features" articles i think its probably safe to assume nothing has changed from 2010.
correction
i read an article that this is so as to preserve compatabillity with 2010/2007.
but it could be changed later
Last edited by martindwilson; 08-20-2012 at 05:26 AM.
It is unchanged.
Remember what the dormouse said
Feed your head
1,048,576 rows
http://office.microsoft.com/en-us/ex...614.aspx?CTT=1
Last edited by greek; 02-03-2013 at 10:31 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks