XL2000: User-Defined Functions Are Unexpectedly Calculated More Than Once (211747)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q211747

SYMPTOMS

In Microsoft Excel 2000, when you use the Function Wizard to enter a formula containing a user-defined function in a cell, the formula may be calculated more than once.

CAUSE

A user-defined function is calculated multiple times if the following conditions are true:
  • The user-defined function is created in Microsoft Visual Basic for Applications.

    -and-
  • The user-defined function is inserted into the spreadsheet with the Function Wizard.
NOTE: This behavior does not occur if the user-defined function is entered directly into a cell in a worksheet.

WORKAROUND

To work around this issue, do not use the Function Wizard to insert the custom function.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

REFERENCES

For more information about entering formulas, click Microsoft Excel Help on the Help menu, type enter a formula to calculate a value in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MinorLast Reviewed:10/11/2006
Keywords:kbbug kbpending kbProgramming KB211747
©2004 Microsoft Corporation. All rights reserved.