If you have a VBA feature that transforms Microsoft Excel right into a CPU chomping beast, is it feasible to tame things down to ensure that you can continue to utilize your computer system for various other tasks while Excel is ending up? Today’s SuperUser Q&A post comes to the rescue to assist an aggravated viewers get Excel back controlled.

Today’s Question & Answer session concerns us thanks to SuperUser– a subdivision of Stack Exchange, a community-driven collection of Q&A web sites.

Alien warrior clip art thanks to Clker.com.

The Question

SuperUser viewers learningAsIGo wishes to know if there is a way to restrict Microsoft Excel’s CPU use while running a VBA manuscript on his computer system:

Is there a way to restrict Microsoft Excel’s CPU usage when it is running? I have a VBA manuscript that computes a big amount of giant selection solutions. The whole collection of estimations takes roughly twenty mins to finish and utilizes 100 percent of my CPU. I am unable to utilize my computer during this time as well as prefer to have Excel ‘running in the background’ while utilizing concerning 50 percent of my CPU’s ability to ensure that I can remain to do other things.

Any type of recommendations? My computer system’s operating system is Windows 7 Enterprise 64-bit with a 2007 32-bit variation of Excel installed on it.

Is there a method to restrict Microsoft Excel’s CPU usage while running VBA functions?

The Answer

SuperUser factor mtone has the solution for us:

If a VBA function is called from several solutions or if your script generates or compels the recalculation of several solutions, then this should definitely utilize the multi-threaded calculation feature in Microsoft Excel. Respectively, this would either run multiple circumstances of your VBA feature for each and every formula, or recalculate several cells at the same time while your VBA manuscript is working on a single string.

You can limit the variety of threads used by Excel to recalculate formulas by mosting likely to Options and also choosing the Advanced Section, then scrolling down till you reach the Formulas sub-section.

Have something to include in the explanation? Sound off in the remarks. Wish to read more responses from other tech-savvy Stack Exchange customers? Have a look at the complete discussion string right here.