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

2007 promises that you WILL have room

--
Don Guillett
SalesAid Software

"jmcclain" wrote in message
...
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

Thanks to all for the assist.

"Don Guillett" wrote:

2007 promises that you WILL have room

--
Don Guillett
SalesAid Software

"jmcclain" wrote in message
...
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

From:
http://blogs.msdn.com/excel/archive/...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.
--
David Biddulph

"jmcclain" wrote in message
...
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

1,048,576 rows
16,384 columns.

--
---
HTH

Bob

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



"jmcclain" wrote in message
...
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

1MB rows
16k columns
in xl2007

jmcclain wrote:

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

--

Dave Peterson