Share via

Identify Numbers in given sum

Anonymous
2020-05-15T07:12:11+00:00

Hi Friends I want to Identify Numbers in given sum . but solver has limit on number of variable cells . I have 1300 variable cells and when I click on OK , solver shows an error . "Too many variable cells " . How can I do that without Receive this error  . * Thanks*

Microsoft 365 and Office | Excel | For home | 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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-05-15T07:19:02+00:00

    Hello Jeylan

    I am V. Arya, Independent Advisor, to work with you on this issue. The limit is 200 variable cells. Excel solver will not be able to handle more than this.

    You will need to break your problem in chunks if possible in your case. Otherwise there is a paid solver product (solver was incorporated into Excel by Microsoft from this company only) which has a limit of 2,000 decision variables for linear problems, and 500 variables for nonlinear problems

    https://www.solver.com/standard-excel-solver-de...

    Standard Disclaimer - This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more