XL97: Memory Errors Appear When You Calculate a Custom Function

ID: Q136761

The information in this article applies to:

Microsoft Excel 97 for Windows

SYMPTOMS

When you recalculate formulas in a worksheet, you may receive the following error message:

   Not Enough Memory. Continue without Undo?

When you click OK or Cancel, the following error message appears:

   Not Enough Memory.

CAUSE

This problem may occur if the following conditions are true:

You are using a custom function that is contained in an add-in.
```
    -and-
```
You repeatedly press F2 and then press ENTER to recalculate the custom function in a cell.

RESOLUTION

To correct this problem, obtain Microsoft Excel 97 Service Release 2 (SR-2).

For additional information about SR-2, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q151261
   TITLE     : OFF97: How to Obtain and Install MS Office 97 SR-2

STATUS

Microsoft has confirmed this to be a problem in Microsoft Excel 97 for Windows. This problem was corrected in Microsoft Office 97 Service Release 2 (SR-2).

Additional query words:

Keywords          : kberrmsg xlformula 
Version           : WINDOWS:97
Platform          : WINDOWS
Issue type        : kbbug
Solution Type     : kbfix

Last Reviewed: May 19, 1999