Thanks,

so if I want the udf not volatile I must use the statement
Application.Volatile False before the udf code?
I don't find the message of ytayta555, so I use this to reply to him:
I have 4 sheets with about 150 udfs in it.

Emiliano

"Jim Thomlinson" ha scritto nel
messaggio ...
UDF's are only volatile if you include Application.Volatile in the
function.
Otherwise they use smart calc like any other function in XL.
--
HTH...

Jim Thomlinson


"ytayta555" wrote:

On 2 Sep, 22:15, "eggpap" wrote:
external data, many udfs etc.
The speed of calculation of the results is very much low. Any tips to
increase that speed?

Be carefully with udfs , them are volatile functions , any change in
data
recalculate all udfs ; how many udfs you have ?