1Not a direct answer, but when people ask me this question I often find they don't really need to see the whole of the 2nd worksheet, they are in reality only checking what happens to one or more values when they make some changes elsewhere. If that is the case, then using the Watch window (on the Formul Ribbon) is a much easier way to do it and is easier to just turn on and off once you have told it what to watch. – AdamV – 2010-11-04T11:58:12.517
1Not a direct answer, but when people ask me this question I often find they don't really need to see the whole of the 2nd worksheet, they are in reality only checking what happens to one or more values when they make some changes elsewhere. If that is the case, then using the Watch window (on the Formul Ribbon) is a much easier way to do it and is easier to just turn on and off once you have told it what to watch. – AdamV – 2010-11-04T11:58:12.517