1

I'm writing a VBA module that uses a lot of computational power. To speed things up, I'm using all available processors on my machine. Excel gives me an option though to use a different number of threads. Is there a difference between (for example) specifying 8 processors versus selecting 8 threads? Would selecting 7 threads limit the machine to using 7 processors?

Thank you

wizlog
  • 13,277
  • 24
  • 77
  • 116
  • What are the names of the options you use for both of these? – dsolimano Aug 23 '17 at 14:53
  • @dsolimano http://ccm.net/faq/11398-excel-select-the-default-number-of-processors-to-be-used-for-calculations – wizlog Aug 23 '17 at 15:13
  • @wizlog, ok, so there's only one option. I think the linked question should probably answer you now. – dsolimano Aug 23 '17 at 15:14
  • @Ƭᴇcʜιᴇ007 I'm specifically referring to how the options within Excel work. – wizlog Aug 23 '17 at 15:14
  • This entirely depends on the processors. If each of those processors were single threaded core processors, then indicating you wanted to use 7 of those processors, would indeed mean your script would be limited to 7 threads. I am not aware of any hardware that supports 7 processors, nor are there a great deal of single threaded core processors on the market. – Ramhound Aug 23 '17 at 15:48

0 Answers0