Forum Discussion
IamRaeff
Apr 18, 2019Copper Contributor
Office 2016 - Basic Calculations Very Delayed
Good Morning All, I have a number of users in my company who have recently been complaining about slow Excel calculations. Initially it was a short delay, but it has since graduated to almost a m...
- Apr 19, 2019You might have lots of volatile functions, array formulas, and conditional formatting that make calculations slow.
IamRaeff
Apr 22, 2019Copper Contributor
Thank you for your response. I eventually found the reason, and it is related to this. There are a number of predictive calculations following what is initially visible from the user's demo. I should have followed up with a more rigorous investigation, but I have found the more complicated formulas.
Twifoo
Apr 22, 2019Silver Contributor
If you can, avoid all those I mentioned. I don’t simply avoid them, I eschew them!