If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Formula needs more than 256 columns
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! |
#3
|
|||
|
|||
Formula needs more than 256 columns
" 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. |
Thread Tools | |
Display Modes | |
|
|