Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
weird recalculation of user defined function | Excel Worksheet Functions | |||
numerical integration | Excel Discussion (Misc queries) | |||
Custom function | Excel Worksheet Functions | |||
MODE function | Excel Worksheet Functions |