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

ID: Q190358

The information in this article applies to:

Microsoft Excel 97 for Windows

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:

   ARTICLE-ID: Q120802
   TITLE     : Office: How to Add/Remove a Single Office Program or
               Component

Additional query words: XL97 Add-ins

Keywords          : kberrmsg kbdta xlgpf xladdins 
Version           : WINDOWS:97
Platform          : WINDOWS
Issue type        : kbbug
Solution Type     : kbpending

Last Reviewed: November 2, 1998