View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Cimjet[_3_] Cimjet[_3_] is offline
external usenet poster
 
Posts: 157
Default What If a Table has a Million Rows?!

Hi again
Try this one
http://office.microsoft.com/en-us/ex...010073849.aspx
Hope this one works
John
"Cimjet" wrote in message
...
Hi Mike
This is a link to XL07, I don't know exactly the specification for 2010 but
for rows and columns,
It should be the same, not less.
http://office.microsoft.com/en-us/ex...73849.aspxFrom
that link, you may find the information for 2010.RegardsJohn"Mike"
wrote in message
Dec
10, 9:50 am, "Cimjet" wrote: Hi Mike You will need to
upgrade to XL2007. 2007 has over a million rows and 16384 columns per sheet.
You can't increase the amount of rows or column in XL2003 or older. HTH
John "Mike" wrote in message
...
Hi Everyone, You know Excel has a limited capacity on the number of

rows, around 65000 Does it mean Excel can't handle bigger data files?
What if a table or datafile has a million or so rows? Is there a way to
go around this? Thanks, Mike- Hide quoted text - - Show quoted
text -You know exactly how many rows in Excel 2007 is the limit? How
aboutExcel 2010?Thanks