Share via

What to do if we have "too many variables" issue in excel solver

Anonymous
2024-01-01T06:32:19+00:00

I have tried to solve capacity planning problems through excel solver function. But at the end it is showing "too many variables" pop up

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-01-01T09:16:40+00:00

    The "too many variables" error message in Excel Solver indicates that the number of decision variables in your model exceeds the maximum limit of Solver. You will need to simplify your model or use a different optimization tool.

    Standard Excel Solver - Dealing with Problem Size Limits | solver

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments