Wednesday, October 01, 2008

Excel 2007 Limit List - How Accountants will love you, Excel, and EDD Professionals will hate you

Arvin's blog - Some Excel 2007 limitation

“Here is a list of all of the major changes we made to Excel 12 in the area of limits.

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)

…”

Arvin’s list is perfect. Simple and too the point.

Needless to say it, as a EDD (Electronic Data Discovery) professional, made me cry… The first time you see a single XLS explode into 25,000+ pages/images/tiff’s and realize that THAT was with 2003’s limits, well, that’s when you break out the tissue paper. 64K rows in 2003 and in 2007 “one million rows…” said in my best Dr Evil voice. Oh my…

No comments:

Post a Comment

NOTE: Anonymous Commenting has been turned off for a while... The comment spammers are just killing me...

ALL comments are moderated. I will review every comment before it will appear on the blog.

Your comment WILL NOT APPEAR UNTIL I approve it. This may take some hours...

I reserve, and will use, the right to not approve ANY comment for ANY reason. I will not usually, but if it's off topic, spam (or even close to spam-like), inflammatory, mean, etc, etc, well... then...

Please see my comment policy for more information if you are interested.

Thanks,
Greg

PS. I am proactively moderating comments. Your comment WILL NOT APPEAR UNTIL I approve it. This may take some hours...