When you open a workbook in Microsoft Excel, the following
problems may occur:
- You receive the following error message:
- 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
These problems occur if all of the following conditions are
- When you open the workbook, a chart sheet is the active
- The active chart sheet refers to cells in a worksheet that
contain formulas that refer to one or more user-defined functions.
- One of the user-defined functions uses the Volatile method by using the following line of code in the function:
To work around these problems, use either of the following
- 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.
- Remove the following code 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
- Switch to the worksheet that is referenced by the chart
- 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
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
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.
Article ID: 213683 - Last Review: January 11, 2015 - Revision: 4.0
- Microsoft Excel 2000 Standard Edition
|kbnosurvey kbarchive kbprb kbchart kbopenfile kbdtacode kberrmsg kbpending kbprogramming KB213683|