It seems that the maximum number of column in Excel is 256 (column IV). IS there a way to go further than this?
It seems that the maximum number of column in Excel is 256 (column IV). IS there a way to go further than this?
no as far as I know. It can be done in the new version of excel.
Order Excel 2007 BEta, it is free, and you only pay for shipping. It goes 1 million cells down, and over to XX I believe.
Ok, I don't really want to use a beta, since it is a beta and is probably not bug-free. Anyway that would improve a bit, but not change the numbers of column significantly. 250 or 500 columns is the same order. I finally switched the rows and the columns in my worksheet, but I will be embarassed the day I need to create a 10000*10000 matrix. I could try to represent it as a 200000*500 table, but that would be really complicated because you wouldn't find the Cells(i,j) symmetric structure. Maybe Excel is just not the good software to represent matrices, but I still not understand why the rows and columns don't play the same role, or at least why you can't configure the numbers or rows or columns you which to use (provided you don't exceed your memory).
Hi Jungix,
I believe the new spreadsheet size is 2^20 rows x 2^14 columns.
Regards
MD
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Thanks mdmackillop,
I look forward to this new version then, 2^14 seems already a bit better
Have you thought about possibly transposing your layout to get it to fit?