Program M$ Excel merupakan program spreadsheet yang paling populer dikalangan pengguna pc desktop maupun laptop. Coba, siapa yang tidak mengenal excel sekarang ini, padahal banyak program sejenis yg beredar seperti OO Calc, KSpread, GNUmeric, Corel Quattro, dll.
Karena kegunaannya, banyak pengguna pc menggunakan Excel untuk mengolah data, atau bisa juga digunakan sebagai database. Namun, belakangan ini saya menemukan beberapa limitasi dari program Excel, karena itu, kemudian saya mencoba mencari lagi limitasi yang lainnya dari berbagai sumber. Bagi mereka yang mengandalkan Excel dalam pekerjaannya sehari-hari, penting untuk mengetahui limitasi Excel tersebut, sehingga kedepannya bisa mengantisipasi masalah yang mungkin muncul akibat limitasi tersebut.
Feature Maximum limit:
Open workbooks Limited by available memory and system resources
Worksheet size 65,536 rows by 256 columns
Column width 255 characters
Row height 409 points
Page breaks 1000 horizontal and vertical
Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.
Sheets in a workbook Limited by available memory (default is 3 sheets)
Colors in a workbook 56
Cell styles in a workbook 4,000
Named views in a workbook Limited by available memory
Custom number formats Limited by available memory
Names in a workbook Limited by available memory
Windows in a workbook Limited by system resources
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
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 3 in a single sort; unlimited when using sequential sorts
Undo levels 16
Fields in a data form 32
Custom toolbars in a workbook Limited by available memory
Custom toolbar buttons Limited by available memory
Following are a few related facts:
Corel's Quattro Pro spreadsheet supports 18,278 columns and up to 1,000,000 rows.
The spreadsheet in Microsoft's Office Web Components supports 18,278 columns and 262,144 rows
