XL2002: Charts Do Not Update When Source Cells Are Updated (821644)

The information in this article applies to:

Microsoft Excel 2002
Microsoft Excel 2000

SYMPTOMS

When you recalculate a workbook that contains user-defined functions, the cells that contain those functions are updated as expected, but charts that are dependent on those cell values may not update to reflect the new recalculated values.

CAUSE

This problem may occur when Microsoft Excel 2002 recalculates a workbook. When Excel 2002 recalculates a workbook, the chart values that are based on user defined custom function cell values are not processed.

WORKAROUND

You can modify the custom function so that it is both volatile and includes error handling, in a manner that is similar to the following example:

Function Function_Name(function_parameter) 
Application.Volatile
On Error Goto ErrHandler 
    Function code
    Exit Function 
ErrHandler: Function_Name = CVErr(xlErrValue) 
End Function

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Modification Type:	Minor	Last Reviewed:	7/27/2006
Keywords:	kbprb KB821644