XL97: "Not Enough Memory" Opening a Workbook with a Chart

Last reviewed: March 20, 1998
Article ID: Q172948
The information in this article applies to:
  • Microsoft Excel 97 for Windows

SYMPTOMS

When you open a workbook in Microsoft Excel 97, the following problems may occur:

  • You receive the following error message:

          Not enough memory.
    

-and-

  • In the active chart, text is missing from both the legend and the chart title. Also, some or all of the chart series labels contain the text "0."

CAUSE

These problems occur if all of the following conditions are true:

  • When you open the workbook, a chart sheet is the active sheet.

        -and-
    
  • The active chart sheet refers to cells in a worksheet that contain formulas that refer to one or more user-defined functions.

        -and-
    
  • One of the user-defined functions uses the Volatile method by using the following line of code in the function:

          Application.Volatile
    

WORKAROUND

To work around these problems, use either of the following methods:

  • Before you save the workbook, click a worksheet or chart sheet that does not refer to user-defined functions. When you do this, you ensure that the active sheet does not refer to a user-defined function.

        -or-
    
  • Remove Application.Volatile from any user-defined functions that are referenced by the chart sheet.

If you cannot change the active sheet or modify the user-defined functions, you can temporarily correct the chart by following these steps:

  1. Switch to the worksheet that is referenced by the chart sheet.

  2. Press CTRL+ALT+F9.

This forces the entire worksheet to be recalculated. When you switch to the chart sheet, the title, legend, and series labels appear correctly. Note that when you close and reopen the workbook, the problems may occur again.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

A volatile function must be recalculated whenever calculation occurs in any cells on the worksheet. A nonvolatile function is recalculated only when the input variables change.


Additional query words: XL97
Keywords : kberrmsg kbprg kbdta kbdtacode xlvbainfo xlloadsave xlchart
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbprb


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 20, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.