Article ID: 821644 - Last Review: February 5, 2007 - Revision: 2.5

XL2002: Charts Do Not Update When Source Cells Are Updated

View products that this article applies to.

System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.

Expand all | Collapse all

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.

Back to the top

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.

Back to the top

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

Back to the top