Excel 2007 question - row and column limits

[jmcclain]

Does anyone know if MS has expanded the limit on the number of rows and
columns allowed in a worksheet?

I need the ability to manipulate data from UPS and the limits in Excel 2003
only allow me to work with 2-3 months of data at a time.

Thanks

Jon

 

[Don Guillett]

2007 promises that you WILL have room

 

[David Biddulph]

From:
http://blogs.msdn.com/excel/archive/2005/09/26/474258.aspx

The total number of available columns in Excel
Old Limit: 256 (2^8)
New Limit: 16k (2^14)
The total number of available rows in Excel
Old Limit: 64k (2^16)
New Limit: 1M (2^20)

so a factor of 64 increase on number of columns, and a factor of 16 increase
in rows.

 

[Bob Phillips]

1,048,576 rows
16,384 columns.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Dave Peterson]

1MB rows
16k columns
in xl2007

Does anyone know if MS has expanded the limit on the number of rows and
columns allowed in a worksheet?

I need the ability to manipulate data from UPS and the limits in Excel 2003
only allow me to work with 2-3 months of data at a time.

Thanks

Jon

 

[jmcclain]

Thanks to all for the assist.

2007 promises that you WILL have room