Microsoft KB Archive/821644

= XL2002: Charts Do Not Update When Source Cells Are Updated =

Article ID: 821644

Article Last Modified on 2/5/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition

-





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.

Additional query words: XL2002 calc udf

Keywords: kbprb KB821644

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.