Scenario Summary

[linda]

In a workbook that contains a Scenario Summary sheet, how
can I refresh the Scenario Summary automatically when
other elements of the workbook have been changed?

The items being changed are not the "changing cells" of
the scenarios, but rather other parameters that underlie
the calculation. They will not normally change in
evaluating scenarios, but are changing occasionally in the
course of debugging the speadsheet. I don't want to
simply rerun the Scenario Summary on a new sheet each time
because other calculations link to and depend on the
content of the original Scenario Summary.

I have shied away from using a Pivot Table so far because
the complexity thereof seems all out of line with the
relative simplicity of the calculations I am performing.

 

[ZW]

I don't think it is possible to refresh the results. The reason being
that the information that you see in the summary is not linked anymore
to the source when you look at it.

But you are lucky to have gone so far with this feature, I'm still
trying to figure it out....