XL97: Memory Errors Appear When You Calculate a Custom Function in a Cell

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:

Q151261 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


Last Reviewed: September 23, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.