p****r 发帖数: 165 | 1 after run a macro in excel, if I rerun it, excel become extremely slow. I
have to close all my excel application and restart it. Then the speed come
back. Any suggestions?
only thing that I could think about is my macro creates about 20 workbooks.. | S*********g 发帖数: 5298 | 2 Do you have a lot of formula or slow ones like vlookup in your workbooks?
If yes, you might want to consider stop automatic calculation in your macro
and turn it back on when the macro finishes.
..
【在 p****r 的大作中提到】 : after run a macro in excel, if I rerun it, excel become extremely slow. I : have to close all my excel application and restart it. Then the speed come : back. Any suggestions? : only thing that I could think about is my macro creates about 20 workbooks..
| p****r 发帖数: 165 | 3 thanks.
but why it only slow after I ran it once. If I open the excel the first
time and run it, it is very fast. then if I ran it 2nd time, it is extremely
slow. so I close all my excel workbook and reopen the one with macro, and
run the macro again, it is fast again. I thought it was something wrong with
my macro.
in normal speed, my macro run within 3 min. when it is slow, it ran 3 hours.
macro
【在 S*********g 的大作中提到】 : Do you have a lot of formula or slow ones like vlookup in your workbooks? : If yes, you might want to consider stop automatic calculation in your macro : and turn it back on when the macro finishes. : : ..
| S*********g 发帖数: 5298 | 4 apparently, you did something wrong in your macro.
extremely
with
hours.
【在 p****r 的大作中提到】 : thanks. : but why it only slow after I ran it once. If I open the excel the first : time and run it, it is very fast. then if I ran it 2nd time, it is extremely : slow. so I close all my excel workbook and reopen the one with macro, and : run the macro again, it is fast again. I thought it was something wrong with : my macro. : in normal speed, my macro run within 3 min. when it is slow, it ran 3 hours. : : macro
|
|