View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Maximum number of elements in array

On Tue, 9 Dec 2008 07:35:03 -0800, Juarez
wrote:

Which is the maximum number of elements to calculate a mmult function without
problems?


It depends, to some extent, on the version of Excel you are using.

see http://support.microsoft.com/kb/166342 for a discussion.

From that article: "The MMULT function returns #VALUE! if the output exceeds
5460 cells."
--ron