Avoiding Recalculation for a function in automatic mode Lokesh Sharma 18.09.2006 12:16:01 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.

RE: Avoiding Recalculation for a function in automatic mode Bill Pfister 19.09.2006 03:52:01 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: [Quoted Text] > 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.