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



The information in this article applies to:

  • Microsoft Excel 97 for Windows

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.

Modification Type:MinorLast Reviewed:10/6/2005
Keywords:kbHotfixServer kbQFE kbbug kbfix kbQFE KB216531