Forum Discussion
Solved
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...
- You might have lots of volatile functions, array formulas, and conditional formatting that make calculations slow.
You might have lots of volatile functions, array formulas, and conditional formatting that make calculations slow.
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.
- If you can, avoid all those I mentioned. I don’t simply avoid them, I eschew them!