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
Highlighted

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
EXCEL SOLVER: LP Simplex and dual Simplex method choose
Baa Faa in Excel on
1 Replies
Solver
hugo1855 in Excel on
1 Replies
Simple Solver Problem - Can't get it to work
dwhit7 in Excel on
0 Replies