Excel updates causing performance issues?

%3CLINGO-SUB%20id%3D%22lingo-sub-1679826%22%20slang%3D%22en-US%22%3EExcel%20updates%20causing%20performance%20issues%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1679826%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20Excel%202016%20MSO%20(16.0.13127.20266)%2032-bit%20on%20a%20Dell%20Precision%207710%20with%20Windows%2010%20and%20an%20extensive%20user%20over%20many%20years%20with%20several%20files%20with%20lots%20of%20VB%20that%20runs%20large%20parts%20of%20my%20business.%20One%20file%20that%20I%20use%20very%20often%20has%20a%20full%20calculation%20pass%20that%20is%20several%20seconds.%20Prior%20to%20early%20June%202020%2C%20it%20would%20take%20about%2030%20seconds.%20Since%20then%20until%20yesterday%2C%20the%20same%20file%20was%20taking%208%20seconds.%20Today%2C%20it's%20back%20to%2031%20seconds.%20I'm%20guessing%20the%20reversion%20of%20performance%20is%20due%20to%20either%20a%20Microsoft%20Office%20upgrade%20or%20Windows%20upgrade%20but%20I'd%20really%20like%20to%20get%20my%20Excel%20performance%20back.%20I%20know%20lots%20of%20spreadsheet%20performance%20tricks%20so%20pretty%20sure%20it's%20not%20that%20but%20rather%20a%20Microsoft%20software%20issue.%20Can%20anyone%20provide%20an%20explanation%20or%20solution%20to%20this%3F%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1679826%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1682284%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20updates%20causing%20performance%20issues%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1682284%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F797712%22%20target%3D%22_blank%22%3E%40KatyPlanner%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPleae%20check%20below%20setting%3A%3C%2FP%3E%3CP%3EFile--%26gt%3BOptions--%26gt%3BAdvanced.%20On%20the%20right%20panel%20scroll%20down%20to%20formula%20and%20make%20sure%20%22Enable%20multi-threaded%20calculation%22%20is%20checked.%20I%20have%20uploaded%20a%20SS%20to%20show%20where%20the%20option%20is.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I am using Excel 2016 MSO (16.0.13127.20266) 32-bit on a Dell Precision 7710 with Windows 10 and an extensive user over many years with several files with lots of VB that runs large parts of my business. One file that I use very often has a full calculation pass that is several seconds. Prior to early June 2020, it would take about 30 seconds. Since then until yesterday, the same file was taking 8 seconds. Today, it's back to 31 seconds. I'm guessing the reversion of performance is due to either a Microsoft Office upgrade or Windows upgrade but I'd really like to get my Excel performance back. I know lots of spreadsheet performance tricks so pretty sure it's not that but rather a Microsoft software issue. Can anyone provide an explanation or solution to this? Thank you!

3 Replies
Highlighted

@KatyPlanner 

Pleae check below setting:

File-->Options-->Advanced. On the right panel scroll down to formula and make sure "Enable multi-threaded calculation" is checked. I have uploaded a SS to show where the option is.

Highlighted

@erol sinan zorlu 

I appreciate the reply. Yes, I always keep the "enable multi-threaded calculation" feature on and use all processors on the computer (e.g. 8). Based on several tests, my gut feeling is that there is something in the Excel source code that changed the way multi-threaded logic works with system resources that can significantly impact performance. It's beyond my capabilities so hoping there is someone out there with Microsoft code knowledge that can interpret what changed with the software update within the last two days so it can be restored or re-optimized.

Highlighted

@KatyPlanner 

Just providing an update to my question earlier this week ... After a large automatic Microsoft Windows and/or Office update today, my Excel performance is now back to where it was earlier this week and even slightly better than it was before. Thanks to the Microsoft folks!