Home

Solver - Speed Differences Between Excel Versions

%3CLINGO-SUB%20id%3D%22lingo-sub-353706%22%20slang%3D%22en-US%22%3ESolver%20-%20Speed%20Differences%20Between%20Excel%20Versions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-353706%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20wondering%20if%20there%20is%20any%20difference%20in%20the%20processing%20speed%20of%20Solver%20as%20between%202010%2F2016%2F2019%2F365%20versions%20of%20Excel%20-%20in%20particular%2C%20whether%20(1)%20newer%20versions%20of%20Solver%20will%20benefit%20from%20increased%20core%20and%20hyper-threading%20chip%20architecture%2C%20and%20(2)%20365%20will%20operate%20slower%20than%202019%20due%20to%20increased%20server%20communication.%26nbsp%3B%20Anyone%20know%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20optimizing%20for%20multi-variable%20non-convex%20non-smooth%20problems%2C%20which%20currently%20takes%20several%20days%20using%20the%20Solver%20Evolution%20engine%20-%20so%20small%20differences%20in%20speed%20will%20matter!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-353706%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-360054%22%20slang%3D%22en-US%22%3ERe%3A%20Solver%20-%20Speed%20Differences%20Between%20Excel%20Versions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-360054%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20is%20Andrew%20Stegmaier%2C%20and%20I'm%20a%20Program%20Manager%20on%20the%20Excel%20team.%20We%20work%20hard%20to%20make%20sure%20that%20performance%20remains%20consistant%20or%20better%20across%20different%20versions%20of%20Excel%2C%20including%20in%20the%20subscription%20(Office365)%20version.%20That%20said%2C%20sometimes%20we%20do%20see%20issues%2C%20so%20if%20you're%20experiencing%20a%20problem%20while%20upgrading%2C%20I'd%20love%20to%20learn%20more.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20address%20your%20specific%20questions%3A%20(1)%20I%20don't%20think%20solver%20has%20been%20modified%20to%20take%20advantage%20of%20multiple%20cores.%20However%2C%20Excel%20formulas%20have%20been%20able%20to%20use%20multiple%20cores%20for%20recalculation%20since%202007%20(see%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fclient-developer%2Fexcel%2Fmultithreaded-recalculation-in-excel%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehere%3C%2FA%3E)%2C%20so%20when%20solver%20is%20used%20in%20conjunction%20with%20formulas%2C%20you%20may%20find%20a%20speed%20increase%20in%20more%20recent%20versions.%20(2)%20The%20aspects%20of%20Office%20365%20that%20communicate%20with%20our%20services%20to%20provide%20cloud%20storage%2C%20updates%2C%20and%20intelligence%20shouldn't%20have%20a%20noticeable%20impact%20on%20Solver%20performance%3A%20Solver%20code%20continues%20to%20run%20locally%20against%20an%20in-memory%20copy%20of%20the%20workbook%20(just%20as%20it%20did%20in%20pre-office-365%20versions).%20If%20you%20notice%20any%20slowdown%2C%20please%20let%20us%20know.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks!%3C%2FP%3E%0A%3CP%3EAndrew%3C%2FP%3E%3C%2FLINGO-BODY%3E
Ron_Dueck
Occasional Visitor

I am wondering if there is any difference in the processing speed of Solver as between 2010/2016/2019/365 versions of Excel - in particular, whether (1) newer versions of Solver will benefit from increased core and hyper-threading chip architecture, and (2) 365 will operate slower than 2019 due to increased server communication.  Anyone know?

 

I am optimizing for multi-variable non-convex non-smooth problems, which currently takes several days using the Solver Evolution engine - so small differences in speed will matter!

 

Thanks!

1 Reply

Hi,

 

This is Andrew Stegmaier, and I'm a Program Manager on the Excel team. We work hard to make sure that performance remains consistant or better across different versions of Excel, including in the subscription (Office365) version. That said, sometimes we do see issues, so if you're experiencing a problem while upgrading, I'd love to learn more.

 

To address your specific questions: (1) I don't think solver has been modified to take advantage of multiple cores. However, Excel formulas have been able to use multiple cores for recalculation since 2007 (see here), so when solver is used in conjunction with formulas, you may find a speed increase in more recent versions. (2) The aspects of Office 365 that communicate with our services to provide cloud storage, updates, and intelligence shouldn't have a noticeable impact on Solver performance: Solver code continues to run locally against an in-memory copy of the workbook (just as it did in pre-office-365 versions). If you notice any slowdown, please let us know.

 

Thanks!

Andrew

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
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies