Spesifikasi dan batas-batas Microsoft Office Excel 2007 , 2010 , 2013 dan Excel 2016. Meliputi data yang dapat diolah maupun fitur dan sajian yang ada pada masing-masing model excel.
Sebagaimana program aplikasi yang lain , pastinya excel mempunyai batas-batas-batas-batas spesifikasi tertentu.
Dibawah ini kami tampilakan batas-batas spesifikasi Excel 2007 , 2010 , 2013 dan 2016. Baik data yang bisa diolah maupun fitur dan sajian yang ada pada masing-masing model 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.
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 Jika berkenan mohon bantu saya kenali dibagian mana masing-masing model ini ada perbedaan. 🙂
Sebelum pergi jangan lupa di Bookmark dan share postingan panduan excel ini dengan tombol yang sudah tersedia di bawah. Salam Kelas Excel.
Berikut beberapa seri Tutorial Excel Dasar yang bisa anda pelajari:
