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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation
dhstein;396498 Wrote: 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.Just turn calculation back on in your before_close macro after all the other tasks have taken place. -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=110732 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation
Doing a Sheet.Calculate flags the workbook as dirty, so that the next time
you get to Automatic Calculation Excel will calculate all open workbooks. The only way to avoid this is to use Application.Calculate rather than Sheet.Calculate or Range.Calculate. If your Automatic recalc is taking a long time you could think about how to reduce workbook volatility, and how to speed up your calculations. regards Charles Williams Decision Models "dhstein" wrote in message ... 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. |
Reply |
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 |