Is it memory problem?

[Adrian T]

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 mins.

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

 

[Bob Flanagan]

If any of the workbooks contain objects from the Forms toolbar, such as a
checkbox, that can cause interfence with the Excel calculation engine.
Totally undocumented. However, I found it out by trial and error. When I
eliminated the checkbox (which was on a excel 4 dialog sheet), calculation
speed returned to normal.

Robert Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel