Can I make a worksheet with more than 256 columns?

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

I need to multiply a large matrix, say 500 by 500, and I'd like to use
the MMULT function.
The kicker is that MMULT seems to be expecting a row of a matrix to
be in a single row of the spreadsheet.
My questions are two;
1) Can I create a worksheet with more than 256 columns?
2) If I'm limited to 256 columns, is there a work around?
I'm not interested in using VBA because I want to apply SOLVER to this
spreadsheet.
Thanks,
Jim
 
Back
Top