Forum Discussion

RAINFIRE's avatar
RAINFIRE
Copper Contributor
Nov 02, 2019

Latest Updates November 2019 Slowed Formula(s) Down - Excel Real World CPU Benchmark

So I wrote this Real World CPU Benchmark for Excel in October. After the latest updates, The Formula Calculations are taking a lot longer. What Happened?

 

Here is the link to my webpage article on it. I also attached the file. The goal was to use it to test new CPU's, but it appears Office Upgrades have threw a monkey-wrench in that . . .

https://intensewebs.com/index.php/benchmark/real-world-cpu-performance-checker-excel

Ran using Microsoft Excel fomr Office 2016 Pro 64-bit and below hardware      LOWER IS BETTER/FASTER
BEFORE      LOWER IS BETTER/FASTER
Mfg.CPURAMDISKCores/
Threads		OSBuildSCORE in Seconds
AMD3700X16 GB, DDR4 3200, CL14PCIe 3 nvme, 3.5Gb/s8 / 16Win 10190375.24011
Inteli7-6500U12 GB, DDR4 2133 SDRAM5400 rpm SATA2 / 4Win 101903570.43384
        
AFTER       
AMD3700X16 GB, DDR4 3200, CL14PCIe 3 nvme, 3.5Gb/s8 / 16Win 101903120
Inteli7-6500U12 GB, DDR4 2133 SDRAM5400 rpm SATA2 / 4Win 101903642
        
excel
Formulas and Functions

1 Reply

  • RAINFIRE's avatar
    RAINFIRE
    Copper Contributor
    Nov 02, 2019

    RAINFIREP.S. I got the Macro to Calculate Formula Calculate Time from Microsoft site. It also now has issues after the latest updates. It only works about half the time now.

     

    https://docs.microsoft.com/en-us/office/vba/excel/concepts/excel-performance/excel-improving-calcuation-performance