Excel Limit

Below are some main metrics for Microsoft Excel:-

Microsoft Excel 7.0 (95)

Maximum Sheet Size : 16,384 rows by 256 columns
Column Width : 0 to 255 characters
Maximum length of cell contents (text): 255 characters

Microsoft Excel 8.0 (97)

Maximum Sheet Size : 65,536 rows by 256 columns
Column Width : 0 to 255 characters
Maximum length of cell contents (text): 32,000 characters

Microsoft Excel 2000, 2002 and 2003
Worksheet size : 65,536 rows by 256 columns
Column Width : 255 characters
Length of cell contents (text): 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.

Setting Excel Range

The Excel Range field will now take additional options as well as Named Ranges.
Here are some examples:

=Sheet1!$B$2:$D$4
=Sheet1!$AC$17:$AF$20
=Sheet1
=Sheet1:August
=Sheet1:'Another One'
='Another One'
='Another One'!
=
=Sheet1:August!$AC$17:$AF$20
=Sheet1:August!AC17:AF20
=!AC17:AF20

=(sheet-range)!(cell-range)

where both sheet-range and cell-range are optional, if they are not supplied the default sheet range is all sheets and the default cell range is all cells.

sheet-range:
Either a single sheet name, or two sheet names separated by a colon. If the sheet name includes spaces it must be put in single quotes. Single quotes may be used around any sheet name.

cell-range:
The $ symbols are ignored if present, they are used by Excel to define absolute versus relative ranges. Our values are all absolute (in effect relative ones are relative to the origin).

-- SooGuan - 27 Dec 2005