What If a Table has a Million Rows?!
On Mon, 13 Dec 2010 21:48:42 -0800, "Bill Oertell"
wrote:
2^20
"Mike" wrote in message
...
On 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 about
Excel 2010?
Thanks
Go back and read the thread. It has already been stated (linked to).
|