Cyberiafreak

"Fortunate are those who take the first steps.” ― Paulo Coelho

Notable difference between Excel 2003 and Excel 2007

Howdy all,

Yesterday I happen to copy 1 lakh
rows from Sql table to Excel for data validation, interestingly I couldn’t
find rows after 65536 ( I knew excel supports only 2^16 rows, brushing aside this,
I declared looping variable to 1 Lk and end up with wasting time in debugging.
So decided to post about excel 2003 capability and 2007 solution for this.

Feature                                                                 Excel
2003           |               Excel 2007

Maximum columns                                             256  
                      |               16 Thousand

Maximum rows                                                    64
Thousand        |               1 Million

Max number of function arg                              30                           |
              255

Formula Length                                   1 Thousand          |
              8 Thousand char

No. of levels of nesting -formulas    7 
                            |               64

Gudoss
to MS Excel Team for pushing the Excel 2007 to a maximum level
J

Advertisements

June 27, 2007 - Posted by | Uncategorized

1 Comment »

  1. There\’s more at http://office.microsoft.com/en-us/excel/HA100738731033.aspx and one of the new features is Table in place of List. Besides that, you may wanna check out the What-If Analysis features like http://office.microsoft.com/en-us/excel/results.aspx?qu=Goal+Seek+Solver&av=ZXL120

    Like

    Comment by Enter | July 2, 2007 | Reply


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: