Hi:

What I have is probably not specific enough or many possible answers to it. I apologize for that.

I have a financial model (lets say 'Model A') with heavy Excel VBA code in it. When I execute the code, I'd get the results I wanted in 2 seconds. But when I open another Excel file (also with complicated code in it) and execute the code in 'Model A', it took me 2 minutes.

I tried to open 'Model A' and an empty workbook. This doesn't make any difference than opening 'Model A' alone. So, the fact that I have another hardcore file opened would affect the overall performance.

Does anybody have some rough ideas of what's happening here?


Regards,
Adrian T

I'm guessing that Model B has a lot of formula calculations in it, and that when you run Model A, 'A-code' at some point calls for a recalc, this will also cause model B to recalc. We suffer the same problem with some of our models - users complaining that things take forever, and then we discover that they're running three big models in the same Excel instance!

Chris

There are two secrets to success in this world:
1. Never tell everything you know

Chris:


That DOES make sense. I wonder how did you work around with this problem? Is there any solutions to it?



Regards,
Adrian T

The only solution we've come up with is 'user education' (a hard task at the best of times:()! Basically, don't open both models in the same Excel instance.
If that's not feasible, then the best bet is to set calculations to manual, and alter the code in the models to explicitly recalc only when they need to and limit the calulation to sheets that you know have changed. This can be a complicated solution as it requires you to know the calculation order of everything you've got in the workbook.

Chris

There are two secrets to success in this world:
1. Never tell everything you know