Open workbooks: Limited by available memory and system resources.
Why is that important? In memory they don't need to allocate all the memory needed for the whole spreadsheet but only the memory necessary for your data, and every data is tagged with in what cell it is supposed to be in.įound a link to Microsoft's specification for Excel 2013 & 2016 Assuming they use two 32-bit words (64 bit) they use 34 bits for the cell number and have 30 bits for other things. Strange numbers?ġ4 + 20 = 34 bits = more than one 32 bit register can hold.īut they also need to store the format of the cell (text, number etc) and formatting (colors, borders etc). Excel 2007 can have a maximum of 16 384 columns and 1 048 576 rows.
