Formula needs more than 256 columns

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?

wrote
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.

--
http://ManagedXLL.net/ | http://jens-thiel.de/ | http://QuantLib.net/
Replace MSDN with my first name when replying to my email address!

" wrote...
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.

--
Never attach files.
Snip unnecessary quoted text.
Never multipost (though crossposting is usually OK).
Don't change subject lines because it corrupts Google newsgroup archives.