tags:

views:

42

answers:

3
+1  Q: 

Excel column limit

is excel's columns limited to 256 ? i try to fill my excel file with a matrix of 1200 x 800 and it doesn't seem to work ( i recieve an error that states that any data beyond the 256 column will not be saved ) . any ideas how this could be avoided ?

Regards, Alexandru Badescu

+6  A: 

Older versions of Excel had a maximum of 256 columns. Excel 2007 increased the column limit to over 16000.

Mark Byers
+3  A: 

Nope, limits on worksheet size are way more than that - see here for program constraints (Excel 2007). Your problem must be elsewhere (or in Excel version being older).

1,048,576 rows by 16,384 columns

+2  A: 

Upgrade to a higher version excel, you are using excel 2003 or earlier. 2010 and 2007 offer more columns.

Femaref