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

• Microsoft Excel 97 for Windows

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