![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Microsoft 365 and Office | Excel | For education | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Hi Yasasw,
"No, the standard Excel Solver has a built-in limit on the number of decision variables you can use, typically around 200, and you cannot directly increase this limit within Excel itself; however, if you need to solve problems with a larger number of variables, you can consider using a third-party add-in like "Solver" from Frontline Systems, which allows for significantly more variables depending on the chosen plan."
"Yes, you can significantly increase the number of variables used by Solver in Frontline Systems by upgrading to their "Premium Solver" or "Analytic Solver Optimization" products, which can handle much larger optimization problems with thousands or even millions of decision variables compared to the standard Excel Solver limitations; essentially allowing you to use a much higher number of variables in your model."
"Premium Solver capabilities:
Frontline's Premium Solver allows you to solve problems with significantly more variables, depending on the specific version and your needs.
- Analytic Solver Optimization: For even larger problems, Frontline offers "Analytic Solver Optimization" which can handle extremely large optimization problems with thousands to millions of variables."