For the best only 1

[sfenili]

I have a big excel file with a lot of macros.
This file is slow and the code is not too bad.
The interesting thing is that when we send Excel in background during an excel calculation (macro or other), for example if you active an explorer window, excel is "speedster".
Do you know the reson? Do you know if is possible to set this "excel status" with some computer settings?

 

[katmar]

I suspect that the reason is that when Excel is in the background it automatically turns off the screen refresh function. Keeping the screen updated with the results of all the macros can be more work than the macros themselves, especially if you have lots of iteration.

See

http://www.asap-utilities.com/excel-tips-detail.php?categorie=9&m=79

Katmar Software
Engineering & Risk Analysis Software

http://katmarsoftware.com

 

[sfenili]

Screen update disabled and Manual calculation

 

[handleman]

Nice tip, Katmar! I had one excel macro that basically filled out an entire spreadsheet cell by cell. Time to run it went from about 45s to 5s by adding that one line! Have a star!

 

[sfenili]

Unfortunatelly my problem is not realed to this function.
In any case, if you lock the calculation too (application.calculation=xlmanualcalculation) you can reduce more this lenght of time!

 

[francesca]

Have you considered putting the macros in an Add-In file that loads when you load your file?

Are you sure there's not a badly coded loop in one of the macros?

How much RAM does your computer have? If you go to the Task Manager, is the processor maxed out?

 

[sfenili]

The file is an add-in
The code is OK
I have 512Mb but this is the same on 2Gb computers.
The task manager is OK and in any case send excel in background doesn't change the processor status.