Formula needs more than 256 columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to calculate a MMULT formula and I need a table of
319x319 cells. Can I divide the table over 2 sheets or in
two parts on the same sheet and still use it in the MMULT
formula?
 
I want to calculate a MMULT formula and I need a table of
319x319 cells. Can I divide the table over 2 sheets or in
two parts on the same sheet and still use it in the MMULT
formula?
Click to expand...

You could try the Office Spreadsheet control which supports more than 256
columns, but I haven't done MMULT in these.

The other possibility is to move larger calculations away from the worksheet
and only display inputs and results.

Jens.
 
I want to calculate a MMULT formula and I need a table of
319x319 cells. Can I divide the table over 2 sheets or in
two parts on the same sheet and still use it in the MMULT
formula?
Click to expand...

If all you want to do is MMULT, you could hack this without needing more
columns. You could use SUMPRODUCT(ArrayOf319Cells,OtherArrayOf319Cells) to get
each element of the result matrix. You might need some intermediate TRANSPOSE
calls, but it's impossible to say where without seeing exactly what you want to
do.
 
Back
Top