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

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

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.

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: 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.

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.