Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.setup
|
|||
|
|||
UDF not returning proper value - circular reference/multi workbook
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 |
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel.setup
|
|||
|
|||
UDF not returning proper value - circular reference/multi workbook
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Repost:Automatically inserting a row in external workbook | Excel Discussion (Misc queries) | |||
#VALUE ! errorr for links to other workbook | Excel Worksheet Functions | |||
make hidden window or workbook visible without specify the name | Excel Worksheet Functions | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) |