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) |
No comments:
Post a Comment