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

• Microsoft Excel 2000

SYMPTOMS

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

CAUSE

This problem occurs when the following conditions are true:

• The workbook contains a custom function that returns an array.
  
  -and-



• The returned array contains 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: XL2000 limit limitation specification maximum udf user defined populate

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