| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook Slow
Hi,
I find my program execution is quite slow and I suspect it is because of the Worksheet_Calculate routine. Is there a way to have Worksheet_calculate programatically run only once instead of once for every change that was made? Also, have it run only on the sheet the change impacted? I already have Application.Screenupdating set to false and Application.EnableEvents set to false -- Thanks for your help. Karen53 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbook Slow
put these at the beginning of your code:
Application.Calculation = xlCalculationManual Application.ScreenUpdating = False and these at the end Application.ScreenUpdating = True Application.Calculation = xlCalculationAutomatic -- Gary "Karen53" wrote in message ... Hi, I find my program execution is quite slow and I suspect it is because of the Worksheet_Calculate routine. Is there a way to have Worksheet_calculate programatically run only once instead of once for every change that was made? Also, have it run only on the sheet the change impacted? I already have Application.Screenupdating set to false and Application.EnableEvents set to false -- Thanks for your help. Karen53 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbook Slow
Oh, wow! I can't get over the difference that made! Now it's 'smokin'
Thank you Gary!! -- Thanks for your help. Karen53 "GKeramidas" wrote: put these at the beginning of your code: Application.Calculation = xlCalculationManual Application.ScreenUpdating = False and these at the end Application.ScreenUpdating = True Application.Calculation = xlCalculationAutomatic -- Gary "Karen53" wrote in message ... Hi, I find my program execution is quite slow and I suspect it is because of the Worksheet_Calculate routine. Is there a way to have Worksheet_calculate programatically run only once instead of once for every change that was made? Also, have it run only on the sheet the change impacted? I already have Application.Screenupdating set to false and Application.EnableEvents set to false -- Thanks for your help. Karen53 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Slow Workbook | Excel Discussion (Misc queries) | |||
| Workbook is now Extremely Slow | Excel Worksheet Functions | |||
| Slow workbook | Excel Discussion (Misc queries) | |||
| My workbook is slow. | Excel Worksheet Functions | |||
| Why is workbook so slow opening? | Excel Discussion (Misc queries) | |||
Linear Mode
