Are you sure you spelled the formula name correctly in the cell? And if
you're looking for text, did you put quotes around the text? References to
other sheet without a ' or missing a : in a range will cause that error too.

You can go to Toola - Formula Auditing - Trace Error for more details...



"JC" wrote:

It is checked and I have even used browse to locate and select.

"JE McGimpsey" wrote:

Is it still loaded?

In article ,
JC wrote:

Purchased an add-in from our software vendor. Had been working until
yesterday. Let's me select it in the toolbar and even lists the functions and
appears to complete the func. Won't return value from database - gives
#NAME... Any suggestions or info on why it stopped working or how to fix?