Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#VALUE error with valid formula
When I open a workbook, one formula may or may not show the #VALUE
error. After pressing F2 and <Enter, the formula is calculated properly. I have tried using the CTL+SHIFT+ALT+F9 to try to refresh the dependency table and then saving the workbook. Upon reopening the workbook, the error persists. Note: Usually the formula that has the error is the last formula calculated before saving the workbook and the formula(s) in question are UDF's. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#VALUE error with valid formula
The udf may? require application.volatile as the first line -- Don Guillett SalesAid Software "jnewby72" wrote in message oups.com... When I open a workbook, one formula may or may not show the #VALUE error. After pressing F2 and <Enter, the formula is calculated properly. I have tried using the CTL+SHIFT+ALT+F9 to try to refresh the dependency table and then saving the workbook. Upon reopening the workbook, the error persists. Note: Usually the formula that has the error is the last formula calculated before saving the workbook and the formula(s) in question are UDF's. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#VALUE error with valid formula
Adding "application.volatile" to the beginning of the UDF's appeared to
work. I didn't get the #VALUE error after opening the workbook. The only problem I have with this method is the recalculating of all the formulas. In a workbook there maybe thousands or tens of thousands of these formulas that have to be recalculated and that can be time consuming. The UDF's that are giving me problems are a part of an third party add-in. I would like to get the problem solved and suggest to the author that the changes be implemented. If all of the formulas need to be recalculated, many other users of this add-in may not appreciate this fix. If I add this fix to my copy of the add-in only, then every time I upgrade the add-in, I'll have to implement this line all over again. Thank you very much for the suggestion, but are there any other options? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions |