Feature Specification and Limits of Microsoft Excel 2007

There are some new feature of Microsoft Excel 2007, but every feature has specification and limits, such as :

a. Worksheet and workbook specifications and limits
b. Calculation specifications and limits
c. Charting specifications and limits
d. PivotTable and PivotChart report specifications and limits
e. Shared workbook specifications and limit

For details every Specification and Limits , we can see on table below :

A	Worksheet and workbook specifications and limits
Feature	Maximum limit
Open workbooks	Limited by available memory and system resources
Worksheet size	1,048,576 rows by 16,384 columns
Column width	255 characters
Row height	409 points
Page breaks	1,026 horizontal and vertical
Total number of characters that a cell can contain	32,767 characters
Characters in a header or footer	255
Sheets in a workbook	Limited by available memory (default is 3 sheets)
Colors in a workbook	16 million colors (32 bit with full access to 24 bit color spectrum)
Named views in workbook	Limited by available memory
Unique cell formats /cell styles	64,000
Fill styles	32
Line weight and styles	16
Unique font types	1,024 global fonts available for use; 512 per workbook
Number formats in workbook	Between 200 and 250, depending on the language version of Excel that you have installed
Names in a workbook	Limited by available memory
Windows in a workbook	Limited by available memory
Panes in a window	4
Linked sheets	Limited by available memory
Scenarios	Limited by available memory; a summary report shows only the first 251 scenarios (scenario: A named set of input values that you can substitute in a worksheetmodel)
Changing cells in a scenario	32
Adjustable cells	200
Custom functions	Limited by available memory
Zoom range	10 percent to 400 percent
Reports	Limited by available memory
Sort references	64 in a single sort; unlimited when using sequential sorts
Undo levels	100
Fields in a data form	32
Workbook parameters	255 parameters per workbook
Filter drop-down lists	10,000
B	Calculation specifications and limits
Feature	Maximum limit
Number precision	15 digits
Largest number allowed tobe typed into a cell	1.00E+308
Largest allowed positive number	1.79769313486231E+308
Smallest allowed negative number	-2.23E-308
Smallest allowed positive number	2.23E-308
Largest allowed negative number	-1.00E-307
Length of formula contents	8,192 characters
Internal length of formula	16,384 bytes
Iterations	32,767
Worksheet arrays	Limited by available memory
Selected ranges	2,048
Arguments in a function	255
Nested levels of functions	64
User defined function categories	255
Number of available worksheet functions	341
Size of the operand stack	1,024
Cross-worksheet dependency	64,000 worksheets that can refer to other sheets
Cross worksheet array formula dependency	Limited by available memory
Area dependency	Limited by available memory
Area dependency per worksheet	Limited by available memory
Dependency on a single cell	4 billion formulas that can depend on a single cell
Linked cell content length from closed workbooks	32,767
Earliest date allowed for calculation	January 1, 1900 (January 1, 1904, if 1904 date system isused)
Latest date allowed for calculation	31-Dec-99
Largest amount of time that can be entered	9999:59:59
C	Charting specifications and limits
Feature	Maximum limit
Charts linked to a worksheet	Limited by available memory
Worksheets referred to by a chart	255
Data series  in one chart	255 (data series: Related data points that are plotted in a chart. Each data series in a chart has a unique color or pattern and is represented in the chart legend. You can plot one or more data series in a chart. Pie charts have only one data series.)
Data points  in a data series for 2-D charts	32,000 (datapoints:Individual values that are plotted in a chart. Related data points make up a data series. Data points are represented by bars, columns, lines, slices, dots, and other shapes. These shapes are called data markers.)
Data points in a data series for 3-D charts	4,000
Data points for a ll data series in one chart	256,000
D.  Pivot Table and PivotChart report specifications and limits
Feature	Maximum limit
PivotTable reports on a sheet	Limited by available memory (PivotTable report: An interactive, cross tabulated.Excel report that summarizes and analyzes data, such as database records, from various sources, including ones that are external to Excel.)
Unique items per field	1,048,576
Row  in a PivotTable report	Limited by available memory (row field: A field that's assigned a row orientation in a Pivot Table report. Items associated with a row field are displayed as row labels.) or column fields (column field: A field that's assigned a column orientation in a PivotTable report. Items associated with a column field are displayed as column labels.)
Report filters in a PivotTable report	256 (may be limited by available memory)
Value fields in a PivotTable report	256
Calculated item formulas in a PivotTable report	Limited by available memory  (calculated item: An item within a PivotTable field or PivotChart field that uses a formula you create. Calculated items can perform calculations by using the contents of other items within the same field of the PivotTable report or PivotChart report.)
Report filters ina PivotChart report	256 (may be limited by available memory) (PivotChart report: A chart that provides interactive analysis of data, like a PivotTable report. You can change views of data, see different levels of detail, or reorganize the chart layout by dragging fields and by showing or hiding items in fields.)
Value fields in a PivotChart report	256
Calculated item formulas in a PivotChart report	Limited by available memory
Length of the MDX name for a PivotTable item	32,767
Length for a relational PivotTable string	32,767
E	Shared workbook specifications and limits
Feature	Maximum limit
Users who can open and share a shared workbook  at the same time	256 (shared workbook: A workbook set up to allow multiple users on a network to view and make changes at the same time. Each user who saves the workbook sees the changes made by other users.)
Personal views  in a shared workbook	Limited by available memory (view: A set of display and print settings that you can name and apply to a workbook. You can create more than one view of the sameworkbook without saving separate copies of the workbook.)
Days that change history is maintained	32,767 (default is 30 days) (change history: In a shared workbook, information that is maintained about changes made in past editing sessions. The information includes the name of the person who made each change, when the change was made, and what data was changed.)
Workbooks that can be merged at one time	Limited by available memory
Cells that can be highlighted in a shared workbook	32,767
Colors used to identify changes made by different users when change highlighting is turned on	32 (each user is identified by a separate color; changes made by the current user are highlighted with navy blue)