Limited number of matrix operations?

Is there a limit to the number of matrix operations that can be done in one formula?

I have this formula working (a column - 3x1):

=MMULT(MMULT(TRANSPOSE($B$1:$D$1),MINVERSE(MMULT($B$1:$D$1,MMULT(MINVERSE(MMULT(TRANSPOSE(B5:D754),B5:D754)),TRANSPOSE($B$1:$D$1))))),MMULT($B$1:$D$1,TRANSPOSE(F754:H754))-1)

Then I have this formula working (a 3x3 matrix):

=MINVERSE(MMULT(TRANSPOSE(B5:D754),B5:D754))

So my result should be a 3x1 column if I MMULT(second one, first one) them together... no such luck I get error... ie if I do:

MMULT(MINVERSE(MMULT(TRANSPOSE(B5:D754),B5:D754)),MMULT(MMULT(TRANSPOSE($B$1:$D$1),MINVERSE(MMULT($B$1:$D$1,MMULT(MINVERSE(MMULT(TRANSPOSE(B5:D754),B5:D754)),TRANSPOSE($B$1:$D$1))))),MMULT($B$1:$D$1,TRANSPOSE(F754:H754))-1))

FURTHER, I get error if I even attempt to TRANSPOSE(the first one). And I am doing the array operations correctly. It works ok if do each separately, then multiply together, but not all at once, so:

I'm wondering if the first formula is at some limit for number of operations performed in a single cell?

Pretty hard to help without seeing the workbook.

Have you tried watching the formula evaluate using the Auditing toolbar?

EDIT: Never mind, you've hit the nesting limit for Excel 2003.

Please Login or Register  to view this content.

Yes, it increased in Excel 2007 to 64.