View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default What is the Max number of records/row allowed in Excel 2007

I haven't seen xl2007 in person, but if you just create a new workbook (not in
xl2003 (or below)) format, what do you see at the bottom?

KaySI wrote:

I saw this post but when I downloaded the trial version of Office 2007 and
did shift, end, down, it still said 65536. How do you display the rows so I
can see 100,000 rows, etc.?

"JRM" wrote:

Thanks all.

--JRM

"Dave Peterson" wrote:

And that's one million in computerese <bg: 1,048,576

http://blogs.msdn.com/excel/archive/...23/473185.aspx

JRM wrote:

Okay,

I know that until 2007 excel has a max allowed rows of around 65536. I have
read answers here that that cap is no long applied to excel 2007. What is
the cap in 2007 or what is the limiting factor now in excel 2007 for the
number of records/rows one can have in a worksheet.

--

Dave Peterson


--

Dave Peterson