Microsoft KB Archive/216531

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

Article ID: 216531

Article Last Modified on 10/6/2005

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q216531





SYMPTOMS
When you calculate your 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 that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Office 2000 SR-1/SR-1a.

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

Keywords: kbbug kbfix kbqfe kbhotfixserver KB216531

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.