XL97: Error Looping Through Add-ins in a Custom Function. (190358)


The information in this article applies to:

  • Microsoft Excel 97 for Windows
This article was previously published under Q190358

SYMPTOMS

When you enter a formula into a cell, you may receive the following error message:
This program has performed an illegal operation and will be shut down.
If the problem persists, contact the program vendor.
If you click Details, you receive an error message similar to the following:
EXCEL caused an invalid page fault in module MSO97.DLL at 0137:306c2669.

CAUSE

This problem may occur if the following conditions are true:

  • The formula calls a custom function. -and-

  • The custom function loops through the Addins collection.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Excel 97 for Windows.

REFERENCES

For more information about built in add-ins, click the Office Assistant in the Visual Basic Editor, type Add-ins, click Search, and then click to view the desired add-in topic.

NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If Microsoft Help is not installed on your computer, please see the following article in the Microsoft Knowledge Base:

120802 Office: How to Add/Remove a Single Office Program or Component

Modification Type:MajorLast Reviewed:10/22/2000
Keywords:kbbug kberrmsg KB190358
©2002 Microsoft Corporation. All rights reserved.