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 minute per edit for one particular user.
Here are the details of the Machine:
i5-6300U @ 2.40GHz
Brand new SSD w/ Win 10 Pro installed
Office 2016 64-Bit installed (originally 32-Bit)
Steps completed on my part:
1. SSD Upgrade from Win7 to Win 10 (LT is licensed for Win 10)
2. Quick Repair
3. Full Repair
4. Installed 64-Bit for full resource utilization
5. Opened workbook in safe mode
6. Tried on a different, newer laptop
7. Downgraded to 2013 on a different LT
8. Manual Calculations (real time data analysis - this cannot be a permanent solution)
Finally, I should note the workbook really isn't that big. (~11MB). It can be rather complicated formula wise, but in this instance, all the user is doing is updating a column with hard coded numbers, and that is then summed at the bottom. Is this somehow related to an update on Windows 10, or Office H&B 2016, or both?
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.