Avoiding Recalculation for a function in automatic mode
 

I got 2 functions in my Excel func1 and func2 and its running in automatic
mode. Since my excel i s running in automatic mode, both functions are called
again and recalculated.
I would like to avoid recalculating of func1 but would like func2 to
recalculate again.

Is there a way for this?? Since when I set EnableCalculation = True , both
functions are called.

Avoiding Recalculation for a function in automatic mode
 

In Excel 2003, you can turn the calculation off on a per sheet basis. If you
put all of your func2's on a sheet and refered to it, you could effectively
freeze the functions. You have to do this in VBA and it can be dangerous
since the user has no visual indication that a particular sheet isn't
updating.


"Lokesh Sharma" wrote:

I got 2 functions in my Excel func1 and func2 and its running in automatic
mode. Since my excel i s running in automatic mode, both functions are called
again and recalculated.
I would like to avoid recalculating of func1 but would like func2 to
recalculate again.

Is there a way for this?? Since when I set EnableCalculation = True , both
functions are called.