TechNet Home Page 
Microsoft
 This static CD-based web site is representative of the www.microsoft.com/y2k site as of September 15th, 1999.   

XL97: Memory Errors Appear When You Calculate a Custom Function

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
© 1999 Microsoft Corporation. All rights reserved. Terms of Use.