Hi,
We have all talked about some of the new features in the Excel 2007. But there is one feature that has been missed in the heap of all the new big features. The features on the extensibility.
Excel 2003 had some restriction on the size of data it can work with (Believe me I have faced it when need to present reports with huge amount of data.). The amount of data that excel 2007 can take is much more than excel 2003. Here is a small comparison between the 2.
Features Excel 2003 Excel 2007
Maximum Columns 256 16000 (WOW)
Maximum Rows 64,000 1,00,000
Maximum Number 30 255
of function argument
Formula Length 1,000 8,000
Nested Formula’s 7 64
These small enhancement in the capability of excel can make huge difference in its usage for large data.
Vikram