Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/170650

From BetaArchive Wiki
Knowledge Base

XL97: VBE: User-Defined Functions Are Calculated Incorrectly

Article ID: 170650

Article Last Modified on 5/8/2002


  • Microsoft Excel 97 Standard Edition

This article was previously published under Q170650


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.


A user-defined function is calculated multiple times in Microsoft Excel 97 for Windows if the following conditions are true:

  • The user-defined function is created in Visual Basic for Applications. -and-

  • The user-defined function is inserted into the spreadsheet with the Function Wizard.

Note that this behavior does not occur if the user-defined function is entered directly in a cell in a worksheet.


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


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

Additional query words: XL97

Keywords: kbprogramming kbprb KB170650