Getting more than 256 columns in Excel

  • Thread starter Thread starter Mahurshi Akilla
  • Start date Start date
M

Mahurshi Akilla

I have to work with a lot of data (basically a 500x500 matrix of
numbers). I understand that Excel can not handle more than 256
columns at a time. Is there a way to trick it to go beyond that? Are
there any pathes/downloads that can provide this enhancement?

Mahurshi Akilla
 
You can upgrade to xl2007.



Mahurshi said:
I have to work with a lot of data (basically a 500x500 matrix of
numbers). I understand that Excel can not handle more than 256
columns at a time. Is there a way to trick it to go beyond that? Are
there any pathes/downloads that can provide this enhancement?

Mahurshi Akilla
Click to expand...
 
sorry messed up,
if you the the column number should be 400, should be like:
400-250 is 150

=INDIRECT("sheet2!" &ADDRESS(ROW(),150))

not as I previously posted
 
Back
Top