| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| slow execution time in excel 2007 | Excel Programming | |||
| Excel/Word very slow to open first time after boot/reboot | Excel Discussion (Misc queries) | |||
| why is moving a row slow in excel 2007 where it is fast in 2000 | Excel Worksheet Functions | |||
| Why with Excel Xp takes time to open and in 2003 fast? | Excel Discussion (Misc queries) | |||
| Excel SLOW !! Response time ... | Excel Discussion (Misc queries) | |||
Threaded Mode
