Why is excel solver so slow

Register To Reply. Re: Spreadsheet too slow: Excel solver taking long to find values for decision variables. Attached Files Solver Ratings. Last edited by Onditi; at PM. Re: Spreadsheet too slow: Excel solver taking long to find values for decision variables Is there a way to make the workbook faster without altering original formulae?

Re: Spreadsheet too slow: Excel solver taking long to find values for decision variables I've tested your solver setup both in a and a excel environment and in excel solver finds a solution in about 1 second. Using excel it takes 5 second for solver to find a solution so I don't think your model is that slow. Then I got 8 Gb of ram but running the 32 bits versions of excel. To make a faster model, well if you could convert your solver setup from a non-linear to a linear one that should increase the speed but then you have to get rid of a number of of functions in order to do this conversion.

Refer to the release blog for the new 2. View all releases. This means we cannot guarantee that the latest release will work on old versions.

However, please give it a go and let us know of any problems so we can fix them. You can download OpenSolver. Version details and dates of updates are shown on the blog page. SolverStudio is a free alternative to OpenSolver that is better suited to larger problems. The SolverStudio interface is fully Excel-based, with the model being edited and run from Excel and stored inside the Excel file. The example i was using is non linear.

Initially i was using evolutionary was taking a long time switched to grg nonlinear. You must log in or register to reply here. Similar threads J. Question Excel Slover function runs slow in larger sheets, despite no change to the actual calculation. Joe00 Jul 8, Excel Questions. Replies 2 Views Jul 8, Joe Question Using Excel solver or other method with a common objective in multiple cells by changing the same variables, subject to constraints.

Replies 3 Views Dec 16, offthelip. Question Excel Workbook - Too Slow. Replies 8 Views Feb 20, rpbenz. Question Weighted Average Rankings dynamic selections of which values to count. Replies 1 Views Sep 1, StephenCrump. Question Query Connection Property - Refresh every 'n' minutes.