如果您有一个VBA函数，可以将microsoftexcel变成一个贪吃CPU的怪兽，那么有没有可能驯服它，以便在Excel完成时，您可以继续使用计算机进行其他活动？今天的超级用户Q&A帖子旨在帮助一位沮丧的读者重新掌控Excel。

今天的问答环节是由SuperUser提供的，SuperUser是Stack Exchange的一个分支，是一个由社区驱动的问答网站分组。

外星人战士剪贴画Clker.com网站.

问题

超级用户读者learningAsIGo想知道在计算机上运行VBA脚本时，是否有办法限制Microsoft Excel的CPU使用率：

Is there a way to limit Microsoft Excel’s CPU usage when it is running? I have a VBA script that calculates a large amount of giant array formulas. The entire set of calculati*** takes approximately twenty minutes to complete and uses 100 percent of my CPU. I am unable to use my computer during this time and would rather have Excel ‘running in the background’ while using about 50 percent of my CPU’s capacity so that I can continue to do other things.

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

在运行VBA函数时，有没有办法限制microsoftexcel的CPU使用率？

答案

超级用户贡献者mtone为我们提供了答案：

If a VBA function is called from several formulas or if your script generates or forces the recalculation of several formulas, then this should definitely make use of the multi-threaded calculation feature in Microsoft Excel. Respectively, this would either run multiple instances of your VBA function for each formula, or recalculate multiple cells simultaneously while your VBA script is running on a single thread.

You can limit the number of threads used by Excel to recalculate formulas by going to Opti*** and selecting the Advanced Section, then scrolling down until you reach the Formulas sub-section.

有什么要补充的解释吗？在评论中发出声音。想从其他精通技术的Stack Exchange用户那里了解更多答案吗？在这里查看完整的讨论主题。