it calculates also when I use the validation
dropdown, even
when the precedent is unchanged.

You may not wish it, but what I'm saying is that it is normal. I'm
guessing the drop-downs are classified among Worksheet_Change events
or something, so the whole sheet is calculated.

I don't know, maybe the UDF can be tweaked to prevent this?