Sebagaimana program aplikasi lainnya, tentu saja excel memiliki batasan-batasan spesifikasi tertentu.
Dibawah
ini kami tampilakan batasan spesifikasi Excel 2007, 2010, 2013 dan
2016. Baik data yang dapat diolah maupun fitur dan menu yang ada pada
masing-masing versi Microsoft Office Excel di ke dalam 5 bagian:
SPESIFIKASI DAN BATASAN EXCEL 2007
Worksheet and workbook Excel 2007
| 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 cancontain | 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 bitcolor spectrum) |
| Named views in a workbook | Limited by available memory |
| Unique cell formats/cell styles | 64,000 |
| Fill styles | 256 |
| Line weight and styles | 256 |
| Unique font types | 1,024 global fonts available for use; 512 perworkbook |
| Number formats in a workbook | Between 200 and 250, depending on the languageversion of Excel that you have installed |
| Names in a workbook | Limited by available memory |
| Windows in a workbook | Limited by available memory |
| Hyperlinks in a worksheet | 66,530 hyperlinks |
| Panes in a window | 4 |
| Linked sheets | Limited by available memory |
| Scenarios | Limited by available memory; a summary report showsonly the first 251 scenarios |
| Changing cells in a scenario | 32 |
| Adjustable cells in Solver | 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 sequentialsorts |
| Undo levels | 100 |
| Fields in a data form | 32 |
| Workbook parameters | 255 parameters per workbook |
| Filter drop-down lists | 10,000 |
Calculation Excel 2007
| FEATURE | MAXIMUM LIMIT |
|---|
| Number precision | 15 digits |
| Smallest allowed negative number | -2.2251E-308 |
| Smallest allowed positive number | 2.2251E-308 |
| Largest allowed positive number | 9.99999999999999E+307 |
| Largest allowed negative number | -9.99999999999999E+307 |
| Largest allowed positive number via formula | 1.7976931348623158e+308 |
| Largest allowed negative number via formula | -1.7976931348623158e+308 |
| 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 datesystem is used) |
| Latest date allowed for calculation | December 31, 9999 |
| Largest amount of time that can be entered | 9999:59:59 |
Charting Excel 2007
| 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 points in a data series for 2-D charts | 32,000 |
| Data points in a data series for 3-D charts | 4,000 |
| Data points for all data series in one chart | 256,000 |
PivotTable and Pivot Chart Report Excel 2007
| FEATURE | MAXIMUM LIMIT |
|---|
| PivotTable reports on a sheet | Limited by available memory |
| Unique items per field | 1,048,576 |
| Row or column fields in aPivotTable report | Limited by available memory |
| 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 PivotTablereport | Limited by available memory |
| Report filters in a PivotChart report | 256 (may be limited by available memory) |
| 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 |
Shared Workbook Excel 2007
| FEATURE | MAXIMUM LIMIT |
|---|
| Users who can open and share a sharedworkbook at the same time | 256 |
| Personal views in a shared workbook | Limited by available memory |
| Days that change history is maintained | 32,767 (default is 30 days) |
| Workbooks that can be merged at one time | Limited by available memory |
| Cells that can be highlighted in a sharedworkbook | 32,767 |
| Colors used to identify changes made bydifferent 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) |
| Excel tables in a shared workbook | 0 (zero). NOTE: A workbook that containsone or more Excel tables cannot be shared. |
Sumber: Excel specifications and limits
SPESIFIKASI DAN BATASAN EXCEL 2010
Worksheet and workbook Excel 2010
| 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 cancontain | 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 bitcolor spectrum) |
| Named views in a workbook | Limited by available memory |
| Unique cell formats/cell styles | 64,000 |
| Fill styles | 256 |
| Line weight and styles | 256 |
| Unique font types | 1,024 global fonts available for use; 512 perworkbook |
| Number formats in a workbook | Between 200 and 250, depending on the languageversion of Excel that you have installed |
| Names in a workbook | Limited by available memory |
| Windows in a workbook | Limited by available memory |
| Hyperlinks in a worksheet | 66,530 hyperlinks |
| Panes in a window | 4 |
| Linked sheets | Limited by available memory |
| Scenarios | Limited by available memory; a summary report showsonly the first 251 scenarios |
| Changing cells in a scenario | 32 |
| Adjustable cells in Solver | 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 sequentialsorts |
| Undo levels | 100 |
| Fields in a data form | 32 |
| Workbook parameters | 255 parameters per workbook |
| Items displayed in filter drop-down lists | 10,000 |
| Noncontiguous cells that can be selected | 2,147,483,648 cells |
Calculation Excel 2010
| FEATURE | MAXIMUM LIMIT |
|---|
| Number precision | 15 digits |
| Smallest allowed negative number | -2.2251E-308 |
| Smallest allowed positive number | 2.2251E-308 |
| Largest allowed positive number | 9.99999999999999E+307 |
| Largest allowed negative number | -9.99999999999999E+307 |
| Largest allowed positive number via formula | 1.7976931348623158e+308 |
| Largest allowed negative number via formula | -1.7976931348623158e+308 |
| 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 datesystem is used) |
| Latest date allowed for calculation | December 31, 9999 |
| Largest amount of time that can be entered | 9999:59:59 |
Charting Excel 2010
| 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 points in a data series for 2-D charts | Limited by available memory |
| Data points in a data series for 3-D charts | Limited by available memory |
| Data points for all data series in one chart | Limited by available memory |
PivotTable and Pivot Chart report Excel 2010
| FEATURE | MAXIMUM LIMIT |
|---|
| PivotTable reports on a sheet | Limited by available memory |
| Unique items per field | 1,048,576 |
| Row or column fields in aPivotTable report | Limited by available memory |
| 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 PivotTablereport | Limited by available memory |
| Report filters in a PivotChart report | 256 (may be limited by available memory) |
| 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 |
| Items displayed in filter drop-down lists | 10,000 |
Shared workbook Excel 2010
| FEATURE | MAXIMUM LIMIT |
|---|
| Users who can open and share a sharedworkbook at the same time | 256 |
| Personal views in a shared workbook | Limited by available memory |
| Days that change history is maintained | 32,767 (default is 30 days) |
| Workbooks that can be merged at one time | Limited by available memory |
| Cells that can be highlighted in a sharedworkbook | 32,767 |
| Colors used to identify changes made bydifferent 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) |
| Excel tables in a shared workbook | 0 (zero). NOTE: A workbook that containsone or more Excel tables cannot be shared. |
Sumber : Excel specifications and limits
SPESIFIKASI DAN BATASAN EXCEL 2013 & 2016
Worksheet and workbook Excel 2013 & 2016
| 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 cancontain | 32,767 characters |
| Characters in a header or footer | 255 |
| Sheets in a workbook | Limited by available memory (default is 1 sheet) |
| Colors in a workbook | 16 million colors (32 bit with full access to 24 bitcolor spectrum) |
| Named views in a workbook | Limited by available memory |
| Unique cell formats/cell styles | 64,000 |
| Fill styles | 256 |
| Line weight and styles | 256 |
| Unique font types | 1,024 global fonts available for use; 512 perworkbook |
| Number formats in a workbook | Between 200 and 250, depending on the languageversion of Excel that you have installed |
| Names in a workbook | Limited by available memory |
| Windows in a workbook | Limited by available memory |
| Hyperlinks in a worksheet | 66,530 hyperlinks |
| Panes in a window | 4 |
| Linked sheets | Limited by available memory |
| Scenarios | Limited by available memory; a summary report showsonly the first 251 scenarios |
| Changing cells in a scenario | 32 |
| Adjustable cells in Solver | 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 sequentialsorts |
| Undo levels | 100 |
| Fields in a data form | 32 |
| Workbook parameters | 255 parameters per workbook |
| Items displayed in filter drop-down lists | 10,000 |
| Noncontiguous cells that can be selected | 2,147,483,648 cells |
| MAXIMUM LIMITs of memory storage and file sizefor Data Model workbooks | 32-bit
environment is subject to 2 gigabytes (GB) ofvirtual address space,
shared by Excel, the workbook, and add-ins that run inthe same process. A
data model’s share of the address space might run up to500 – 700
megabytes (MB), but could be less if other data models and add-insare
loaded.64-bit environment imposes no hard limits on filesize. Workbook
size is limited only by available memory and system resources.
NOTE:
Adding tables to the DataModel increases the file size. If you don’t
plan to create complex Data Modelrelationships using many data sources
and data types in your workbook,uncheck the Add this data to the Data
Model box when you import orcreate tables, pivot tables, or data
connections. |
Calculation Excel 2013 & 2016
| FEATURE | MAXIMUM LIMIT |
|---|
| Number precision | 15 digits |
| Smallest allowed negative number | -2.2251E-308 |
| Smallest allowed positive number | 2.2251E-308 |
| Largest allowed positive number | 9.99999999999999E+307 |
| Largest allowed negative number | -9.99999999999999E+307 |
| Largest allowed positive number via formula | 1.7976931348623158e+308 |
| Largest allowed negative number via formula | -1.7976931348623158e+308 |
| 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 datesystem is used) |
| Latest date allowed for calculation | December 31, 9999 |
| Largest amount of time that can be entered | 9999:59:59 |
Charting Excel 2013 & 2016
| 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 points in a data series for 2-D charts | Limited by available memory |
| Data points in a data series for 3-D charts | Limited by available memory |
| Data points for all data series in one chart | Limited by available memory |
PivotTable and Pivot Chart report Excel 2013 & 2016
| FEATURE | MAXIMUM LIMIT |
|---|
| PivotTable reports on a sheet | Limited by available memory |
| Unique items per field | 1,048,576 |
| Row or column fields in a PivotTable report | Limited by available memory |
| 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 |
| Report filters in a PivotChart report | 256 (may be limited by available memory) |
| 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 |
| Items displayed in filter drop-down lists | 10,000 |
Shared workbook Excel 2013 & 2016
| FEATURE | MAXIMUM LIMIT |
|---|
| Users who can open and share a shared workbook atthe same time | 256 |
| Personal views in a shared workbook | Limited by available memory |
| Days that change history is maintained | 32,767 (default is 30 days) |
| Workbooks that can be merged at one time | Limited by available memory |
| Cells that can be highlighted in a sharedworkbook | 32,767 |
| Colors used to identify changes made bydifferent 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) |
| Excel tables in a shared workbook | 0 (zero). NOTE: A workbook that contains oneor more Excel tables cannot be shared. |
Sumber: Excel specifications and limits
catatan: disarikan dari berbagai sumber
terima kasih materinya
BalasHapus