Solver Error when selecting Adjacent Cells

%3CLINGO-SUB%20id%3D%22lingo-sub-1499046%22%20slang%3D%22en-US%22%3ESolver%20Error%20when%20selecting%20Adjacent%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1499046%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20looking%20at%203%20different%20Windows%2010%20PC's%20using%20Excel%20Solver.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20two%20of%20the%20PC's%2C%20when%20%22Sensitivity%20Analysis%22%20is%20selected%20after%20running%20Solver%2C%20it%20shows%20this%20(no%20solution%20in%20the%20top%20table)%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Kathy_Takayama_0-1593533012504.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F202201i14DE18B50B01211A%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Kathy_Takayama_0-1593533012504.png%22%20alt%3D%22Kathy_Takayama_0-1593533012504.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20should%20look%20like%20this%20(which%20the%20third%20computer%20shows%20correctly)%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Kathy_Takayama_1-1593533186271.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F202202i0593CD7C72DFDD4C%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Kathy_Takayama_1-1593533186271.png%22%20alt%3D%22Kathy_Takayama_1-1593533186271.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIn%20all%20three%20cases%2C%20the%20Decision%20Variables%20are%20adjacent%20and%20are%20selected%20by%20dragging.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20the%20two%20computers%20that%20%22failed%22%20in%20the%20first%20example%2C%20if%20they%20select%20each%20individual%20cell%20for%20the%20Decision%20Variables%2C%20the%20Solver%20Sensitivity%20Table%20output%20is%20correct%20(but%20it's%20a%20pain%20in%20the%20butt%20to%20select%20Decision%20Variables%20individually%20as%20our%20spreadsheets%20get%20larger).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHas%20anybody%20seen%20this%20before%3F%20Any%20ideas%20of%20a%20configuration%20change%20we%20should%20be%20making%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%20in%20advance%2C%20for%20any%20suggestions%20you%20can%20provide%2C%3C%2FP%3E%3CP%3EKathy%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1499046%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I am looking at 3 different Windows 10 PC's using Excel Solver.

 

For two of the PC's, when "Sensitivity Analysis" is selected after running Solver, it shows this (no solution in the top table):

Kathy_Takayama_0-1593533012504.png

 

It should look like this (which the third computer shows correctly):

 

Kathy_Takayama_1-1593533186271.png

In all three cases, the Decision Variables are adjacent and are selected by dragging.

 

For the two computers that "failed" in the first example, if they select each individual cell for the Decision Variables, the Solver Sensitivity Table output is correct (but it's a pain in the butt to select Decision Variables individually as our spreadsheets get larger).

 

Has anybody seen this before? Any ideas of a configuration change we should be making?

 

Thank you, in advance, for any suggestions you can provide,

Kathy

0 Replies