In this article, find all workbook, worksheet, and feature specifications and limits. In Excel 2010, the maximum worksheet size is 1,048,576 rows by 16,384 columns....closed workbooks 32,767 Earliest date allowed for calculation January...1904, if 1904 date system is used) Latest date allowed for calculation...