Link to home
Start Free TrialLog in
Avatar of eureka15
eureka15Flag for United States of America

asked on

Excel macro runs slow

When ever I have two or more open workbooks in excel and run a macro it runs slow, sometimes very slow. But when I do NOT have anything open but the workbook to run the macro on, it runs a lot faster. I have tried this many time with different workbooks open, different macros always the same results.....2 open workbooks macro slow, No workbook open macro fast.

Any clues on what is going on??
Jimi
ASKER CERTIFIED SOLUTION
Avatar of Makrini
Makrini
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Try opening another instance of Excel to run your Macro workbook in...

i.e - If you already have other workbooks open
start menu run excel.  In the new instance of Excel, Open the file you want and run the Macro.  Should be exactly the same as if not with the other workbooks open
Pls post your code

Else you will only get guesses

Cheers

Dave
Avatar of eureka15

ASKER

Makrini
Thanks that was simple.

Jimi