Is there an array size limit for MMULT or MINVERSE in excel 2007?

[Guest]

I have searched MS.com for any clue as whether the array size limit has
improved in the latest version of excel. If it has not changed, I am not
going to get it.

 

[Guest]

If I'm interpreting this correctly, it appears the limit is the number of
rows in XL 2007, i.e., approx. 1 million:
http://support.microsoft.com/default.aspx/kb/166342

Dave

 

[Guest]

The XL 07 developers' blog indicates that array limits are limited by
available memory in XL 07:
http://blogs.msdn.com/excel/archive/2005/09/26/474258.aspx

One of the two links I provided must be accurate.

Dave

 

[Alan Beban]

I have searched MS.com for any clue as whether the array size limit has
improved in the latest version of excel. If it has not changed, I am not
going to get it.

What array size limit for MMULT and MINVERSE are you referring to?

Alan Beban

 

[Harlan Grove]

What array size limit for MMULT and MINVERSE are you referring to?

Apparently searching through Microsoft's own Knowledge Base doesn't
occur to you. Try reading http://support.microsoft.com/kb/166342 and
consider not participating in threads for which you're ignorant of the
subject matter.