Professor Excel

Comments 4

  1. AC

    Thank you for this – very useful article, particularly for somebody trying to figure out how to make using Excel on a Mac a better experience (looks like Bootcamp is the way to go)

  2. Charles Trudel

    In response to this,
    Therefore if you got an idea of why 3 threads are slightly faster, please let us know.

    Well, my guess would be that having three threads, it takes three cores for them, the fourth core is use by the operating system.

    Where as if we use 4 threads, the 4th core has a conflict with the system.

    Does that make sense?

    • Henrik Schiffner

      Hi Charles,
      Thanks for the feedback. Unfortunately, there is not much information about this issue available. That leaves me with guessing. Therefore, your idea could be correct. I would just like to add, that it highly depends on your workbook. As far as I know, Excel tries to divide the calculation performance by the calculation chains. Because of that, the performance could differ for different workbooks.
      Can I also encourage you to measure it for your own workbook and environment? The test workbook can be downloaded above (or slightly improved from this page: http://professor-excel.com/performance-book/) Please let me know what you find out 🙂

Leave a comment