Share via

Sensitivity Analysis doesn't show variable cells

han yuting 5 Reputation points
2023-10-16T11:31:43.03+00:00

When I use solver in excel, I choose to outline the "Sensitivity Report". But, when these reports are shown, the variable cells part of the reports don't show the individual cells. Only the range of variable cells is shown so it doesn't show me any "Original Value", "Final Value", "Integer", "Reduced Cost", "Objective Coefficient", "Allowable Increase", and "Allowable Decrease". In the picture below, the variable cells section is blank.

Anyone know how to fix this?

User's image

Microsoft 365 and Office | Excel | For business | Windows
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-11-28T05:09:14.6133333+00:00

    I figured it out. It is displaying all the information it's supposed to show, it's just not visible when the reports immediately come out. Why, I don't know, but here's what you do: Drag to select the whole "missing" Variable Cells table, highlighting all of its cells (even the ones that appear blank), and copy and paste it onto another sheet. You should be able to see the contents of each of the cells then.

    TL;DR Copy and paste the Variable Cells table onto another sheet.

    2 people found this answer helpful.
  2. Akshit Varsani 0 Reputation points
    2024-09-12T18:26:25.34+00:00

    The above does not work

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.