Professor Excel

Comments 10

  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 🙂

  3. Sam BC

    thumbs up for the article.
    it would be interesting too, if by any chance you guys will test out the excel performance difference between laptop vs desktop running similar specs (quad-core processor, 4gb ram, ssd) 🙂

  4. David

    Great article someone who lives and breathes spreadsheets. Thank you for the depth of the research.

  5. Galant Koh

    Thanks for this. Very interesting and useful. There was one aspect I was interested in but that wasn’t included though. I don’t know if you’ve investigated this before or since. Do you know if, all else being equal, more RAM or a faster CPU make more difference?

    For example, an Intel i5 with 4GB or 8GB RAM. vs an Intel i7 with 4GB or 8GB RAM?

    I’d be interested to see which PC components give greater speed for Excel.

    Thanks though. Good read!

  6. jure

    Hello,

    I have one problem with excel on my brand new laptop. It is not working very smooth, when I scroll faster there are grey area showing up for a moment, it looks like the data on the screen is refreshing to slow. I have UHD display, maybe this is a problem. The laptop is Thinkpad T570 i7 7600, UHD display, 16GB RAM DDR4, Invidia GeForce 940mx, 512SSD.. So it is laptop with good specs but excel is working worst than my 8 years old HP. Do you have any suggestions? Thank you for your help, Jure

  7. JMuler

    Hi,
    after several tests with different Excel versions this is my conclusions:

    Equipment:
    -Windows Server 2016
    -Excel 2007 (32bits) Excel 2013 (32 bits) Excel 2016 (32bits) (64 bits discarded due to slow performance)
    -Excel Workbook with 54 sheets and some vba macros.

    Conclusions:

    Faster Excel with VBA code is Excel 2007.

    But the fastest combination I found is Windows Server 2003 (32bits) with Excel 2007 (32 bits).

    And … If you put the affinity to only one CPU, the time is 50% faster. INCREDIBLE…

    All these test have occupied me two weeks.

    Finally in my Company we are working with Excel 2007. Better versions, the older versions.

Leave a comment