Microsoft KB Archive/213691

= XL2000: Syntax Errors When Calculating Functions or Opening a Workbook =

Article ID: 213691

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q213691





SYMPTOMS
When you recalculate values in a Microsoft Excel workbook that contains a custom function, the Microsoft Visual Basic Editor may be open and you may receive the following error message:

Compile Error:

Syntax Error

If you switch back to Excel by using the taskbar, Excel may appear to stop responding.

If you attempt to quit the Visual Basic Editor or reset the custom function, you continue to receive the error message.

NOTE: This behavior may also occur when you open an Excel workbook; functions in a workbook are calculated when you open it.



CAUSE
This behavior is caused by a syntax error in a custom function. The error message appears to be in a loop because you receive the error message for each cell in the workbook that calls the custom function.



RESOLUTION
To resolve this issue, correct the syntax error in the custom function. Before you can make the proper corrections, you must dismiss the error messages. To do so, follow these steps:
 * 1) Click the Reset button on the standard toolbar in the Visual Basic Editor.
 * 2) Click OK for each error message.
 * 3) Continue with steps 1 and 2 until no error messages appear.



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

Additional query words: udf XL2000

Keywords: kbbug kberrmsg kbpending kbprogramming KB213691

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.