Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation
I check the status of recalculation at the beginning of macros and then turn
it off for faster processing. At the end I set it back to whatever it was (Automatic or Manual). During the macro execution I sometimes recalculate a sheet. At the end when I turn it back on, there is no need to recalculate since I've done whatever calculations are needed. Is it possible to prevent Excel from recalculating when I set Application.Calculation = xlAutomatic ? Thanks for any help on this. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculation help please | Excel Worksheet Functions | |||
Need help with Calculation | Excel Discussion (Misc queries) | |||
Multi threaded calculation (multi CPU) - impact on calculation spe | Excel Discussion (Misc queries) | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions |