Friday, 7 October 2011

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 workbooksLimited by available memory and system resources    
Worksheet size1,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
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
Adjustable cells  200    
Custom functionsLimited by available memory    
Zoom range 10 percent to 400 percent    
Reports Limited by available memory    
Sort references64 in a single sort; unlimited when using sequential sorts    
Undo levels 100    
Fields in a data
Workbook parameters 255 parameters per workbook    
Filter drop-down
B Calculation specifications and limits
Feature Maximum limit    
Number precision15 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 arraysLimited by available memory    
Selected ranges2,048    
Arguments in a function 255    
Nested levels of functions 64    
User defined function
Number of available
worksheet functions
Size of the operand stack 1,024    
64,000 worksheets that can refer to other sheets    
Cross worksheet array formula dependency Limited by available memory    
Area dependencyLimited by available memory    
Area dependency per
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
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
C Charting specifications and limits
Feature Maximum limit    
Charts linked to a worksheet Limited by available memory     
Worksheets referred to by a
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
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
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
Calculated item formulas in
a PivotChart report
Limited by available memory    
Length of the MDX name for
a PivotTable item 
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
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)

Related Posts by Categories

No comments:

Post a Comment

Random Posts