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


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q250828
IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry

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.

RESOLUTION

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.


To resolve this problem, obtain Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a).

To obtain SR-1/SR-1a, click the article number below to view the article in the Microsoft Knowledge Base:

245025 OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)

After you obtain and install Microsoft Office 2000 Service Release 1 (SR-1), you must also add an entry to the Windows registry. To do this, follow these steps:
  1. On the Start menu, click Run. In the Open box, type regedit. Click OK.
  2. In the left pane of Registry Editor, click the plus signs (+) next to the following items (in order):

    HKEY_CURRENT_USER
    Software
    Microsoft
    Office
    9.0
    Excel

  3. In the left pane, click the Options folder.
  4. On the Edit menu, point to New, and then click DWORD Value.
  5. Type QFE_Calgary, and then press ENTER.
  6. Double-click the QFE_Calgary icon.
  7. In the Value data box, type 1, and then click OK.
This change takes effect the next time that you start Excel.

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:MajorLast Reviewed:11/5/2003
Keywords:kbbug kbfix kbQFE KB250828
©2003 Microsoft Corporation. All rights reserved.