Spesifikasi dan Batasan Microsoft Excel

Spesifikasi dan Batasan Microsoft Excel

Spesifikasi dan Batasan Microsoft Excel

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

FEATUREMAXIMUM LIMIT
Open workbooksLimited by available memory and system resources
Worksheet size1,048,576 rows by 16,384 columns
Column width255 characters
Row height409 points
Page breaks1,026 horizontal and vertical
Total number of characters that a cell cancontain32,767 characters
Characters in a header or footer255
Sheets in a workbookLimited by available memory (default is 3 sheets)
Colors in a workbook16 million colors (32 bit with full access to 24 bitcolor spectrum)
Named views in a workbookLimited by available memory
Unique cell formats/cell styles64,000
Fill styles256
Line weight and styles256
Unique font types1,024 global fonts available for use; 512 perworkbook
Number formats in a workbookBetween 200 and 250, depending on the languageversion of Excel that you have installed
Names in a workbookLimited by available memory
Windows in a workbookLimited by available memory
Hyperlinks in a worksheet66,530 hyperlinks
Panes in a window4
Linked sheetsLimited by available memory
ScenariosLimited by available memory; a summary report showsonly the first 251 scenarios
Changing cells in a scenario32
Adjustable cells in Solver200
Custom functionsLimited by available memory
Zoom range10 percent to 400 percent
ReportsLimited by available memory
Sort references64 in a single sort; unlimited when using sequentialsorts
Undo levels100
Fields in a data form32
Workbook parameters255 parameters per workbook
Filter drop-down lists10,000

Calculation Excel 2007

FEATUREMAXIMUM LIMIT
Number precision15 digits
Smallest allowed negative number-2.2251E-308
Smallest allowed positive number2.2251E-308
Largest allowed positive number9.99999999999999E+307
Largest allowed negative number-9.99999999999999E+307
Largest allowed positive number via formula1.7976931348623158e+308
Largest allowed negative number via formula-1.7976931348623158e+308
Length of formula contents8,192 characters
Internal length of formula16,384 bytes
Iterations32,767
Worksheet arraysLimited by available memory
Selected ranges2,048
Arguments in a function255
Nested levels of functions64
User defined function categories255
Number of available worksheet functions341
Size of the operand stack1,024
Cross-worksheet dependency64,000 worksheets that can refer to other sheets
Cross-worksheet array formula dependencyLimited by available memory
Area dependencyLimited by available memory
Area dependency per worksheetLimited by available memory
Dependency on a single cell4 billion formulas that can depend on a single cell
Linked cell content length from closed workbooks32,767
Earliest date allowed for calculationJanuary 1, 1900 (January 1, 1904, if 1904 datesystem is used)
Latest date allowed for calculationDecember 31, 9999
Largest amount of time that can be entered9999:59:59

Charting Excel 2007

FEATUREMAXIMUM LIMIT
Charts linked to a worksheetLimited by available memory
Worksheets referred to by a chart255
Data series in one chart255
Data points in a data series for 2-D charts32,000
Data points in a data series for 3-D charts4,000
Data points for all data series in one chart256,000

PivotTable and Pivot Chart Report Excel 2007

FEATUREMAXIMUM LIMIT
PivotTable reports on a sheetLimited by available memory
Unique items per field1,048,576
Row or column fields in aPivotTable reportLimited by available memory
Report filters in a PivotTable report256 (may be limited by available memory)
Value fields in a PivotTable report256
Calculated item formulas in a PivotTablereportLimited by available memory
Report filters in a PivotChart report256 (may be limited by available memory)
Value fields in a PivotChart report256
Calculated item formulas in a PivotChart reportLimited by available memory
Length of the MDX name for a PivotTable item32,767
Length for a relational PivotTable string32,767

Shared Workbook Excel 2007

FEATUREMAXIMUM LIMIT
Users who can open and share a sharedworkbook at the same time256
Personal views in a shared workbookLimited by available memory
Days that change history is maintained32,767 (default is 30 days)
Workbooks that can be merged at one timeLimited by available memory
Cells that can be highlighted in a sharedworkbook32,767
Colors used to identify changes made bydifferent users when change highlighting is turned on32 (each user is identified by a separate color;changes made by the current user are highlighted with navy blue)
Excel tables in a shared workbook0 (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

FEATUREMAXIMUM LIMIT
Open workbooksLimited by available memory and system resources
Worksheet size1,048,576 rows by 16,384 columns
Column width255 characters
Row height409 points
Page breaks1,026 horizontal and vertical
Total number of characters that a cell cancontain32,767 characters
Characters in a header or footer255
Sheets in a workbookLimited by available memory (default is 3 sheets)
Colors in a workbook16 million colors (32 bit with full access to 24 bitcolor spectrum)
Named views in a workbookLimited by available memory
Unique cell formats/cell styles64,000
Fill styles256
Line weight and styles256
Unique font types1,024 global fonts available for use; 512 perworkbook
Number formats in a workbookBetween 200 and 250, depending on the languageversion of Excel that you have installed
Names in a workbookLimited by available memory
Windows in a workbookLimited by available memory
Hyperlinks in a worksheet66,530 hyperlinks
Panes in a window4
Linked sheetsLimited by available memory
ScenariosLimited by available memory; a summary report showsonly the first 251 scenarios
Changing cells in a scenario32
Adjustable cells in Solver200
Custom functionsLimited by available memory
Zoom range10 percent to 400 percent
ReportsLimited by available memory
Sort references64 in a single sort; unlimited when using sequentialsorts
Undo levels100
Fields in a data form32
Workbook parameters255 parameters per workbook
Items displayed in filter drop-down lists10,000
Noncontiguous cells that can be selected2,147,483,648 cells

Calculation Excel 2010

FEATUREMAXIMUM LIMIT
Number precision15 digits
Smallest allowed negative number-2.2251E-308
Smallest allowed positive number2.2251E-308
Largest allowed positive number9.99999999999999E+307
Largest allowed negative number-9.99999999999999E+307
Largest allowed positive number via formula1.7976931348623158e+308
Largest allowed negative number via formula-1.7976931348623158e+308
Length of formula contents8,192 characters
Internal length of formula16,384 bytes
Iterations32,767
Worksheet arraysLimited by available memory
Selected ranges2,048
Arguments in a function255
Nested levels of functions64
User defined function categories255
Number of available worksheet functions341
Size of the operand stack1,024
Cross-worksheet dependency64,000 worksheets that can refer to other sheets
Cross-worksheet array formula dependencyLimited by available memory
Area dependencyLimited by available memory
Area dependency per worksheetLimited by available memory
Dependency on a single cell4 billion formulas that can depend on a single cell
Linked cell content length from closed workbooks32,767
Earliest date allowed for calculationJanuary 1, 1900 (January 1, 1904, if 1904 datesystem is used)
Latest date allowed for calculationDecember 31, 9999
Largest amount of time that can be entered9999:59:59

Charting Excel 2010

FEATUREMAXIMUM LIMIT
Charts linked to a worksheetLimited by available memory
Worksheets referred to by a chart255
Data series in one chart255
Data points in a data series for 2-D chartsLimited by available memory
Data points in a data series for 3-D chartsLimited by available memory
Data points for all data series in one chartLimited by available memory

PivotTable and Pivot Chart report Excel 2010

FEATUREMAXIMUM LIMIT
PivotTable reports on a sheetLimited by available memory
Unique items per field1,048,576
Row or column fields in aPivotTable reportLimited by available memory
Report filters in a PivotTable report256 (may be limited by available memory)
Value fields in a PivotTable report256
Calculated item formulas in a PivotTablereportLimited by available memory
Report filters in a PivotChart report256 (may be limited by available memory)
Value fields in a PivotChart report256
Calculated item formulas in a PivotChart reportLimited by available memory
Length of the MDX name for a PivotTable item32,767
Length for a relational PivotTable string32,767
Items displayed in filter drop-down lists10,000

Shared workbook Excel 2010

FEATUREMAXIMUM LIMIT
Users who can open and share a sharedworkbook at the same time256
Personal views in a shared workbookLimited by available memory
Days that change history is maintained32,767 (default is 30 days)
Workbooks that can be merged at one timeLimited by available memory
Cells that can be highlighted in a sharedworkbook32,767
Colors used to identify changes made bydifferent users when change highlighting is turned on32 (each user is identified by a separate color;changes made by the current user are highlighted with navy blue)
Excel tables in a shared workbook0 (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

FEATUREMAXIMUM LIMIT
Open workbooksLimited by available memory and system resources
Worksheet size1,048,576 rows by 16,384 columns
Column width255 characters
Row height409 points
Page breaks1,026 horizontal and vertical
Total number of characters that a cell cancontain32,767 characters
Characters in a header or footer
255
Sheets in a workbookLimited by available memory (default is 1 sheet)
Colors in a workbook16 million colors (32 bit with full access to 24 bitcolor spectrum)
Named views in a workbookLimited by available memory
Unique cell formats/cell styles64,000
Fill styles256
Line weight and styles256
Unique font types1,024 global fonts available for use; 512 perworkbook
Number formats in a workbookBetween 200 and 250, depending on the languageversion of Excel that you have installed
Names in a workbookLimited by available memory
Windows in a workbookLimited by available memory
Hyperlinks in a worksheet66,530 hyperlinks
Panes in a window4
Linked sheetsLimited by available memory
ScenariosLimited by available memory; a summary report showsonly the first 251 scenarios
Changing cells in a scenario32
Adjustable cells in Solver200
Custom functionsLimited by available memory
Zoom range10 percent to 400 percent
ReportsLimited by available memory
Sort references64 in a single sort; unlimited when using sequentialsorts
Undo levels100
Fields in a data form32
Workbook parameters255 parameters per workbook
Items displayed in filter drop-down lists10,000
Noncontiguous cells that can be selected2,147,483,648 cells
MAXIMUM LIMITs of memory storage and file sizefor Data Model workbooks32-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

FEATUREMAXIMUM LIMIT
Number precision15 digits
Smallest allowed negative number-2.2251E-308
Smallest allowed positive number2.2251E-308
Largest allowed positive number9.99999999999999E+307
Largest allowed negative number-9.99999999999999E+307
Largest allowed positive number via formula1.7976931348623158e+308
Largest allowed negative number via formula-1.7976931348623158e+308
Length of formula contents8,192 characters
Internal length of formula16,384 bytes
Iterations32,767
Worksheet arraysLimited by available memory
Selected ranges2,048
Arguments in a function255
Nested levels of functions64
User defined function categories255
Number of available worksheet functions341
Size of the operand stack1,024
Cross-worksheet dependency64,000 worksheets that can refer to other sheets
Cross-worksheet array formula dependencyLimited by available memory
Area dependencyLimited by available memory
Area dependency per worksheetLimited by available memory
Dependency on a single cell4 billion formulas that can depend on a single cell
Linked cell content length from closed workbooks32,767
Earliest date allowed for calculationJanuary 1, 1900 (January 1, 1904, if 1904 datesystem is used)
Latest date allowed for calculationDecember 31, 9999
Largest amount of time that can be entered9999:59:59

Charting Excel 2013 & 2016

FEATUREMAXIMUM LIMIT
Charts linked to a worksheetLimited by available memory
Worksheets referred to by a chart255
Data series in one chart255
Data points in a data series for 2-D chartsLimited by available memory
Data points in a data series for 3-D chartsLimited by available memory
Data points for all data series in one chartLimited by available memory

PivotTable and Pivot Chart report Excel 2013 & 2016

FEATUREMAXIMUM LIMIT
PivotTable reports on a sheetLimited by available memory
Unique items per field1,048,576
Row or column fields in a PivotTable reportLimited by available memory
Report filters in a PivotTable report256 (may be limited by available memory)
Value fields in a PivotTable report256
Calculated item formulas in a PivotTable reportLimited by available memory
Report filters in a PivotChart report256 (may be limited by available memory)
Value fields in a PivotChart report256
Calculated item formulas in a PivotChart reportLimited by available memory
Length of the MDX name for a PivotTable item32,767
Length for a relational PivotTable string32,767
Items displayed in filter drop-down lists10,000

Shared workbook Excel 2013 & 2016

FEATUREMAXIMUM LIMIT
Users who can open and share a shared workbook atthe same time256
Personal views in a shared workbookLimited by available memory
Days that change history is maintained32,767 (default is 30 days)
Workbooks that can be merged at one timeLimited by available memory
Cells that can be highlighted in a sharedworkbook32,767
Colors used to identify changes made bydifferent users when change highlighting is turned on32 (each user is identified by a separate color;changes made by the current user are highlighted with navy blue)
Excel tables in a shared workbook0 (zero)
NOTE : A workbook that contains oneor more Excel tables cannot be shared.

Sumber : Excel specifications and limits

Jika berkenan mohon bantu saya identifikasi dibagian mana masing-masing versi ini ada perbedaan. :)


Sebelum pergi jangan lupa di Bookmark dan share artikel tutorial excel ini dengan tombol yang tersedia di bawah. Salam Kelas Excel.

0 komentar