I have an Excel file with several user defined functions (UDF). When I open the file, sometimes (but not always) the cells that contain a UDF shows this error: #NAME?
If I type into a cell that is a parameter for the UDF, sometimes that will make the errors go away -- but not always.
I have tried pressing F9 (recalculate workbook) but that has no effect.
I have tried setting calculation method to manual and then back to automatic, but that also has no effect.
If I save & close the file and then reopen it, the error is gone. (Simply closing it doesn't always work... I have to save & close.)
Why do I sometimes see this error, and what can I do so it does not appear? Obviously there is nothing wrong with the UDF's themselves, or they would always show the #NAME? error. It appears Excel sometimes has a problem with them when opening a file, but I don't understand why.
If I type into a cell that is a parameter for the UDF, sometimes that will make the errors go away -- but not always.
I have tried pressing F9 (recalculate workbook) but that has no effect.
I have tried setting calculation method to manual and then back to automatic, but that also has no effect.
If I save & close the file and then reopen it, the error is gone. (Simply closing it doesn't always work... I have to save & close.)
Why do I sometimes see this error, and what can I do so it does not appear? Obviously there is nothing wrong with the UDF's themselves, or they would always show the #NAME? error. It appears Excel sometimes has a problem with them when opening a file, but I don't understand why.