XL97: Custom Function Returns #VALUE! If Returning Array Larger Than 5,461 Elements

ID: Q216531

The information in this article applies to:

SYMPTOMS

When you calculate your workbook, some cells may contain a #VALUE! error.


CAUSE

You are using a custom function that returns an array containing more than 5,461 elements.


STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Additional query words: XL97 limit limitation specification maximum udf user defined populate 


Keywords          : kbdta 
Version           : WINDOWS:97
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: July 2, 1999