Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Anpu Massri   on Feb 25 In MS Office Category.

  
Question Answered By: Guilherme Silva   on Feb 25

You could certainly stop other things running, so as to make more processor
cycles available to Excel. But you'd have to do this yourself - Excel
can't.

> if the antivirus is running  it will utilize most of the processor resource

If you mean that the antivirus engine is actually running a full machine
scan, then yes it will use considerable resources, and should normally only
be run  when you aren't using the machine for anything else.

If you mean that the antivirus engine is not running a full machine scan,
but is still utilising most of the processor resources, then look at
changing your antivirus engine.

The normal thing that slows down VBA code  to unacceptable levels is having
Excel update the screen whenever the code changes a value of a cell on the
screen and/or changes the focus. You should turn screen updating off while
the code runs.

Another one that soaks resources is auto-calc. You should turn this off
when running code in a spreadsheet that has lots of formulas. Then turn it
back on at the end, and also force a recalculate of the sheet.

Getting these two right can speed  up VBA execution by an enormous amount.

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on How to increase the speed of the Excel Macro? Or get search suggestion and latest updates.


Tagged: