Forum Discussion
ctz69
Oct 14, 2022Copper Contributor
Terrible recalculation speed on Ryzen processor
Something has happened recently to my copy of Excel 2021. Perhaps it is an update, I'm not sure. My large spreadsheet model now takes 40 seconds to recalculate on my Ryzen 7 3700x, a 16 thread CPU....
JKPieterse
Oct 17, 2022Silver Contributor
ctz69 One thing to try is:
- Open workbook
- Set Excel back to automatically detect # of cores
- Hit control+shift+alt+F9 (this forces Excel to rebuild the calc tree and do a full recalc)
- Let Excel calculate the workbook again (F9), perhaps even multiple times
- Now time the calculation, has it improved any?
NB: If you open an Excel file which has been recalculated last on a different version of Excel, Excel may decide to do a full recalc the first time round. Subsequent calcs should be quick as usual
ctz69
Oct 17, 2022Copper Contributor
Tried this and recalculated 5 times and it ran at 36 seconds each time, down from the original 40 seconds. Turned off multi-threaded calcs and restored the 1-2 second calculation. Bug or working as intended? Maybe it doesn't work properly on AMD CPUs? Considering the processing power of modern CPUs, it must be a bug or bad design.
- JKPieterseOct 17, 2022Silver Contributor
ctz69 Thanks for trying. Let's wait and hear what the team has to say about this. I'll report back if I hear anything.