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
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
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
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
↑ Back to the top