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

Copper Contributor

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 . . .

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
        
1 Reply

@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-calcuat...