XL98: "Not Enough Memory" Opening a Workbook with a Chart (182300)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q182300 SYMPTOMS
When you open a workbook in Microsoft Excel 98 Macintosh Edition, 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.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are 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.
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbdtacode kberrmsg kbprb kbProgramming KB182300 |
---|
|