See What happen with UK COVID tracking and Excel? The older, less secure, Excel formats can’t cope with a higher number of rows/columns so Excel limits workbooks to the constraints of the file format.

Excel versionĮxcel 2007 and later get downgraded to the lower Excel 2003 limits (65,536 x 256) when opening a. The reader messages made it clear that it’s still commonly believed that Excel is limited to 65,536 rows when Excel 2007 (32-bit) increased that to 1,048,576 rows. Microsoft rightly wants their documents accessible to all copies of that application and version – regardless of whether it is 32-bit and 64-bit.

Having larger worksheet sizes just for 64-bit Excel would cause all sorts of document compatibility issues. The maximum rows/columns in Excel is limited by the version of the product, not it’s ‘bitness’.

While that might be theoretically possible, it’s not true. A few readers seem to believe that 64-bit Excel will have more rows or columns than the 32-bit version. How many rows and columns does Excel have now and in the last 25 years of Excel for Windows and Mac?Īll the talk about 64-bit versions of Office has raised the issue of maximum rows and columns in Excel.

Most current version of excel for mac