Hi all,
I have a data workbook (values, and matrices) and a workbook does the
calculation (contains UDF). Calculation workbook with circular references is
linked to Data workbook.
When a value is changed in data workbook, the calculation workbook ALWAYS
returns a wrong answer (although the UDF is thoroughly tested and always
yields expected results). It can be corrected when the FIRST (only the
first) cell of the matrices is modified (even by adding 0 to the formula).
Once that problem is fixed, we can then change the value and it will always
returns the right value. Modifing non-leading cells on the matrix does force
recalculation, but it will always give wrong answer.
Does anyone have any idea on how to troubleshoot the problem?
Thanks

hi,

did you ever use Application.Volatile method in your UDF?
Volatile forces UDF run when a worksheet is recalculated.

for more information , goto
http://exceltips.vitalnews.com/Pages...alculated.html

Best regards,

sjoo