Formula needs more than 256 columns

[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?

 

[Jens Thiel]

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?

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.

 

[Harlan Grove]

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?

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.