I noticed one of two nearly identical machines going FAR slower on the same Excel code.
So then I made a test macro that is nothing but a while loop comparing a test string against 80,000 cells, 1 by 1 - in a brand new xlsm document.
I'm running it on two new Windows 10 installs with current Excel 365 and pretty much everything similar between the two.
On one machine, the macro takes 0.8 seconds to run. On the other it takes 14.5 seconds or so.
I've benchmarked the two machines with novabench and they score similarly for CPU/RAM tests. I haven't installed any add-ins or anything. This is just 2 fresh installs.
Is there anything I can possibly do to figure out what's slowing one of them down?
So then I made a test macro that is nothing but a while loop comparing a test string against 80,000 cells, 1 by 1 - in a brand new xlsm document.
I'm running it on two new Windows 10 installs with current Excel 365 and pretty much everything similar between the two.
On one machine, the macro takes 0.8 seconds to run. On the other it takes 14.5 seconds or so.
I've benchmarked the two machines with novabench and they score similarly for CPU/RAM tests. I haven't installed any add-ins or anything. This is just 2 fresh installs.
Is there anything I can possibly do to figure out what's slowing one of them down?