what is "source evaluates to an error"

I am trying to fix a spreadsheet. When I try to use the drop down boxes and
List, I get the following message.source evaluates to an error. Help Do you
know what is wrong?

Probably the list used for validation is using a name or an expresion that is
not valid. Can you post that information? It should be found in menu Data
-> Validation for the cell that gives the error.
If it is a name, post also the name definition (menu Insert -> Name ->
Define).

"Carol" wrote:

> I am trying to fix a spreadsheet. When I try to use the drop down boxes and
> List, I get the following message.source evaluates to an error. Help Do you
> know what is wrong?