| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Disable calculations to speed up Macro
I have a fairly large spreadsheet, that takes a long time to run due to the
number of times it re-calculates. Is there any way i can using code, disable the calculation at the start of the routine and then re-enable at the end? Regards Lee |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Disable calculations to speed up Macro
Application.calculation = xlcalculationmanual
your code Application.calculation = xlcalculationautomatic On Sep 18, 7:42*am, leerem wrote: I have a fairly large spreadsheet, that takes a long time to run due to the number of times it re-calculates. Is there any way i can using code, disable the calculation at the start of the routine and then re-enable at the end? Regards Lee |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Disable calculations to speed up Macro
Application.Calculation = xlCalculationManual
....your code Application.Calculation = xlCalculationAutomatic -- __________________________________ HTH Bob "leerem" wrote in message ... I have a fairly large spreadsheet, that takes a long time to run due to the number of times it re-calculates. Is there any way i can using code, disable the calculation at the start of the routine and then re-enable at the end? Regards Lee |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Speed up macro | Excel Discussion (Misc queries) | |||
| How to increase calculations speed in pivot table with calculated fields & items | Excel Discussion (Misc queries) | |||
| Range Name affecting speed of macro | Excel Worksheet Functions | |||
| Help, need to speed up this macro | Excel Discussion (Misc queries) | |||
| Speed up macro | Excel Discussion (Misc queries) | |||
Linear Mode
