SOLVED
Home

Office 2016 - Basic Calculations Very Delayed

%3CLINGO-SUB%20id%3D%22lingo-sub-472032%22%20slang%3D%22en-US%22%3EOffice%202016%20-%20Basic%20Calculations%20Very%20Delayed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-472032%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Morning%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20number%20of%20users%20in%20my%20company%20who%20have%20recently%20been%20complaining%20about%20slow%20Excel%20calculations.%20Initially%20it%20was%20a%20short%20delay%2C%20but%20it%20has%20since%20graduated%20to%20almost%20a%20minute%20per%20edit%20for%20one%20particular%20user.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20are%20the%20details%20of%20the%20Machine%3A%3C%2FP%3E%3CP%3ELenovo%20T460%3C%2FP%3E%3CP%3Ei5-6300U%26nbsp%3B%40%202.40GHz%3C%2FP%3E%3CP%3EBrand%20new%20SSD%20w%2F%20Win%2010%20Pro%20installed%3C%2FP%3E%3CP%3E8GB%20RAM%3C%2FP%3E%3CP%3EOffice%202016%2064-Bit%20installed%20(originally%2032-Bit)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESteps%20completed%20on%20my%20part%3A%3C%2FP%3E%3CP%3E1.%20SSD%20Upgrade%20from%20Win7%20to%20Win%2010%20(LT%20is%20licensed%20for%20Win%2010)%3C%2FP%3E%3CP%3E2.%20Quick%20Repair%3C%2FP%3E%3CP%3E3.%20Full%20Repair%3C%2FP%3E%3CP%3E4.%20Installed%2064-Bit%20for%20full%20resource%20utilization%3C%2FP%3E%3CP%3E5.%20Opened%20workbook%20in%20safe%20mode%3C%2FP%3E%3CP%3E6.%20Tried%20on%20a%20different%2C%20newer%20laptop%3C%2FP%3E%3CP%3E7.%20Downgraded%20to%202013%20on%20a%20different%20LT%3C%2FP%3E%3CP%3E8.%20Manual%20Calculations%20(real%20time%20data%20analysis%20-%20this%20cannot%20be%20a%20permanent%20solution)%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFinally%2C%20I%20should%20note%20the%20workbook%20really%20isn't%20that%20big.%20(~11MB).%20It%20can%20be%20rather%20complicated%20formula%20wise%2C%20but%20in%20this%20instance%2C%20all%20the%20user%20is%20doing%20is%20updating%20a%20column%20with%20hard%20coded%20numbers%2C%20and%20that%20is%20then%20summed%20at%20the%20bottom.%20Is%20this%20somehow%20related%20to%20an%20update%20on%20Windows%2010%2C%20or%20Office%20H%26amp%3BB%202016%2C%20or%20both%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-472032%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-477115%22%20slang%3D%22en-US%22%3ERe%3A%20Office%202016%20-%20Basic%20Calculations%20Very%20Delayed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-477115%22%20slang%3D%22en-US%22%3EYou%20might%20have%20lots%20of%20volatile%20functions%2C%20array%20formulas%2C%20and%20conditional%20formatting%20that%20make%20calculations%20slow.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-479632%22%20slang%3D%22en-US%22%3ERe%3A%20Office%202016%20-%20Basic%20Calculations%20Very%20Delayed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-479632%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20response.%20I%20eventually%20found%20the%20reason%2C%20and%20it%20is%20related%20to%20this.%20There%20are%20a%20number%20of%20predictive%20calculations%20following%20what%20is%20initially%20visible%20from%20the%20user's%20demo.%20I%20should%20have%20followed%20up%20with%20a%20more%20rigorous%20investigation%2C%20but%20I%20have%20found%20the%20more%20complicated%20formulas.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-480496%22%20slang%3D%22en-US%22%3ERe%3A%20Office%202016%20-%20Basic%20Calculations%20Very%20Delayed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-480496%22%20slang%3D%22en-US%22%3EIf%20you%20can%2C%20avoid%20all%20those%20I%20mentioned.%20I%20don%E2%80%99t%20simply%20avoid%20them%2C%20I%20eschew%20them!%3C%2FLINGO-BODY%3E
IamRaeff
New Contributor

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 minute per edit for one particular user.

 

Here are the details of the Machine:

Lenovo T460

i5-6300U @ 2.40GHz

Brand new SSD w/ Win 10 Pro installed

8GB RAM

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? 

3 Replies
Solution
You might have lots of volatile functions, array formulas, and conditional formatting that make calculations slow.

@Twifoo 

 

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. 

Highlighted
If you can, avoid all those I mentioned. I don’t simply avoid them, I eschew them!
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies