Excel model - Very fast first time - Very slow second time
 

I have built a model in Excel consisting of VBA-code for transfering
data from different workbooks (where calculations is done) to a
mainbook where the macro is. A strange thing happend: the first time I
run the macro it takes about 15 sec. The next time it takes about 10
min.

Im using:
- named cells in the mainbook and the other books
- No arrayformulas/table is used
- Objectvariables (workbook, worksheet). Have tried to set them to
nothing after use.
- No link cells between the books

I realy hope any can give me a tip for what I should do.

Excel model - Very fast first time - Very slow second time
 

It might help to set Application.Calculation = xlCalculationManual
while the macro is running.



On Oct 6, 8:35*am, "Helge's" wrote:
I have built a model in Excel consisting of VBA-code for transfering
data from different workbooks (where calculations is done) to a
mainbook where the macro is. A strange thing happend: the first time I
run the macro it takes about 15 sec. The next time it takes about 10
min.

Im using:
- named cells in the mainbook and the other books
- No arrayformulas/table is used
- Objectvariables (workbook, worksheet). Have tried to set them to
nothing after use.
- No link cells between the books

I realy hope any can give me a tip for what I should do.