Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros running slow on Excel 2003 but not on Excel 2002
I have a macro which hide unwanted rows (2500++ rows).
When i run this macro on Excel 2002 everything is fine and very fast (around 10 sec). BUT when i run it on my colleague PC (which has better spec then my PC) and on Excel 2003, the macro runs like a SNAIL. What gives?????????????? It is only running fast when I set the Calculation from Auto to Manual. I know it is easy to just add in two more lines in my macros BUT i have something like 100++ Excel files which has this type of macro and those files are not small. Their size ranges from 5MB to 30MB. Needless to say there are a lot of macros in each file......... Why is Microsoft doing this to me???? *sobs* Would appreciate if anybody can give me an alternative solution (i dont want to spend the next few days just changing macros). Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel (2002) slow after deleting some macros | Excel Discussion (Misc queries) | |||
Macros running slow in Excel 2003 | Excel Discussion (Misc queries) | |||
Slow running of Excel macros embedded in an ActiveX | Excel Programming | |||
excel macros running slow with XP | Excel Programming | |||
Excel 2002 - Slow macros | Excel Programming |