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



The information in this article applies to:

  • Microsoft Excel 97 for Windows

This article was previously published under Q136761

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:

151261 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).

Modification Type:MinorLast Reviewed:9/22/2005
Keywords:kbHotfixServer kbQFE kbbug kberrmsg kbfix KB136761