can anyone tell me why I cannot get user defined functions
that are called from a worksheet formula to recalculate
when the spreadsheet updates please?

Cheers

Andy

After the first line of the function put:
Application.Volatile True
to have it calculate when ws calculates.
Bob Umlas
Excel MVP

"Andy Ives" wrote in message
...
can anyone tell me why I cannot get user defined functions
that are called from a worksheet formula to recalculate
when the spreadsheet updates please?

Cheers

Andy

Thanks Bob. I'll give that a try.

Andy
-----Original Message-----
After the first line of the function put:
Application.Volatile True
to have it calculate when ws calculates.
Bob Umlas
Excel MVP

"Andy Ives" wrote in message
...
can anyone tell me why I cannot get user defined
functions
that are called from a worksheet formula to recalculate
when the spreadsheet updates please?

Cheers

Andy


.

Excel recalculates UDFs when one of their input arguments change or when
they are volatile.

Best solution is to put all the cells etc that are referenced by the UDF as
arguments to the function. That way the function only gets recalculated when
it needs to.
next best (but simplest) is to add application.volatile which makes the
function always recalculate even when it does not need to.


regards
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm


"Andy" wrote in message
...
Thanks Bob. I'll give that a try.

Andy
-----Original Message-----
After the first line of the function put:
Application.Volatile True
to have it calculate when ws calculates.
Bob Umlas
Excel MVP

"Andy Ives" wrote in message
...
can anyone tell me why I cannot get user defined
functions
that are called from a worksheet formula to recalculate
when the spreadsheet updates please?

Cheers

Andy


.