ExcelBanter - Maximum number of elements in array

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Maximum number of elements in array (https://www.excelbanter.com/excel-discussion-misc-queries/212981-maximum-number-elements-array.html)

Juarez

Maximum number of elements in array

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

Ron Rosenfeld

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

All times are GMT +1. The time now is 02:16 PM.