开发者

Excel column limit

开发者 https://www.devze.com 2023-01-21 08:08 出处:网络
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开发者_Go百科 beyond the 256 col

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开发者_Go百科 beyond the 256 column will not be saved ) . any ideas how this could be avoided ?

Regards, Alexandru Badescu


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


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


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

0

精彩评论

暂无评论...
验证码 换一张
取 消