The following technical specifications for the worksheet include the number of cells allowed in the worksheet and the nature of the numbers allowed in the worksheet.
Maximum number of rows in a worksheet: 1 billion
Maximum number of columns in a worksheet: 1 billion
Maximum numeric precision: 15 digits (Counting the digits before and after the decimal place)
Maximum numeric resolution: 2.22E-16 (The smallest detectable difference between two numbers)
Maximum absolute value: 1.79769E+308 (The largest value that can be represented)
Minimum absolute value: 2.22507E-308 (The smallest value that is different from zero)
Double precision floating-point numbers can only represent approximately 15 significant decimal digits.
Approximate memory requirements for unformatted numeric data: 10.5 bytes per cell + 24 bytes per column
Example 1
10,000 rows of numbers in 3 columns
30,000 cells x 10.5 bytes/cell = 315,000 bytes (308 Kbytes)
3 columns x 24 bytes/column = 72 bytes
TOTAL MEMORY NEEDED (in addition to memory needed to run the program): 308 Kbytes
Example 2
3 rows of numbers in 10,000 columns
30,000 cells x 10.5 bytes/cell = 315,000 bytes (308 Kbytes)
10,000 columns x 24 bytes/column = 240,000 bytes (234 Kbytes)
TOTAL MEMORY NEEDED (in addition to memory needed to run the program): 542 Kbytes
See Also