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
Highlighted
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. 

If you can, avoid all those I mentioned. I don’t simply avoid them, I eschew them!
Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies